A SQL GUI extension for JupyterLab that enables point-and-click database exploration and query execution.
jupyterlab-sql is a JupyterLab extension that adds a graphical SQL interface to the JupyterLab environment. It enables users to explore database tables visually and execute SQL queries directly within JupyterLab, eliminating the need to switch to external database tools.
Data scientists, analysts, and researchers who use JupyterLab for data work and need to interact with SQL databases as part of their workflow.
It integrates database management directly into JupyterLab, offering a seamless, point-and-click SQL experience without leaving the notebook environment, which boosts productivity and reduces tool fragmentation.
SQL GUI for JupyterLab
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Launches seamlessly from the launcher or command palette, fitting directly into the JupyterLab UI as shown in the README with launcher.png, reducing context switching.
Works with SQLite, PostgreSQL, MySQL, and other SQLAlchemy-supported databases, offering flexibility for multiple database types without custom configuration.
Provides a point-and-click interface to browse tables and schemas, streamlining data exploration without manual query writing.
Allows executing custom SQL queries with shift+enter or ctrl+enter directly in JupyterLab, integrating querying into data science workflows.
The README admits in issue #113 that support for non-standard databases is lacking and requires community contributions, making it unsuitable for niche backends.
Installation steps differ between JupyterLab 1.x and legacy versions, which can lead to confusion and errors during setup.
For SQLite in-memory databases, data persistence is tied to the Jupyter server lifetime, causing data loss on server restart as noted in the README.