{"id":27090,"library":"jupysql-plugin","title":"JupySQL Plugin","description":"JupyterLab extension for JupySQL, providing a graphical interface for SQL queries in notebooks. Current version 0.4.5, released sporadically with minor updates.","status":"active","version":"0.4.5","language":"python","source_language":"en","source_url":"https://github.com/ploomber/jupysql-plugin.git","tags":["jupyterlab-extension","sql","jupysql","notebook"],"install":[{"cmd":"pip install jupysql-plugin","lang":"bash","label":"PyPI"},{"cmd":"conda install -c conda-forge jupysql-plugin","lang":"bash","label":"Conda"}],"dependencies":[{"reason":"Core query engine, required for plugin functionality","package":"jupysql","optional":false},{"reason":"Plugin is a JupyterLab extension, version 3.x required","package":"jupyterlab","optional":false}],"imports":[{"note":"Module is installed as a separate package, not part of jupysql","wrong":"from jupysql import plugin","symbol":"jupysql_plugin","correct":"import jupysql_plugin"}],"quickstart":{"code":"import jupysql_plugin\n%load_ext sql\nimport os\ndb_url = os.environ.get('DATABASE_URL', 'sqlite://')\n%sql $db_url\n%sql SELECT 1 as test;","lang":"python","description":"After installation, reload the page, specify connection string, and run a query."},"warnings":[{"fix":"Install jupysql-plugin in the JupyterLab kernel's Python environment.","message":"Plugin must be installed in the same environment as JupyterLab. Installing via pip outside the active Jupyter environment will not work.","severity":"gotcha","affected_versions":"all"},{"fix":"Use JupyterLab 3 or downgrade: conda install jupyterlab=3","message":"JupyterLab 4 is not supported; only JupyterLab 3.x works.","severity":"gotcha","affected_versions":"all"},{"fix":"Keep jupysql at version <0.10 or check for plugin updates.","message":"The plugin's SQL editor UI may break with newer versions of JupySQL (>=0.10). Compatibility is not guaranteed.","severity":"deprecated","affected_versions":"0.4.x"},{"fix":"Re-enable the extension: jupyter labextension enable jupysql_plugin","message":"Plugin version 0.3.0 changed the extension name from 'jupysql-plugin' to 'jupysql_plugin' in some contexts. Old configurations may not work.","severity":"breaking","affected_versions":">=0.3.0"}],"env_vars":null,"last_verified":"2026-04-27T00:00:00.000Z","next_check":"2026-07-26T00:00:00.000Z","problems":[{"fix":"Run: jupyter labextension enable jupysql_plugin","cause":"Extension not enabled after installation or not built.","error":"JupyterLab extension 'jupysql_plugin' is not installed"},{"fix":"Install in the correct environment: pip install jupysql-plugin","cause":"Package not installed in the Jupyter kernel's Python environment.","error":"ModuleNotFoundError: No module named 'jupysql_plugin'"},{"fix":"Downgrade to JupyterLab 3: conda install jupyterlab=3","cause":"JupyterLab 4 is not compatible.","error":"Error: This extension does not support JupyterLab 4"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}