This utility is a lightweight interactive web-based SQL editor for various database types. Quickly run unlimited SQL queries across different databases simultaneously in a notebook format. Inspired by my heavy use of Jupyter Notebooks, I wanted a similar utility for quickly querying against databases.
This utility also ships with its own database so you can jump to adding data and querying as well if desired. Although it's designed to allow you to connect to and query an unlimited number of databases, no external database is technically required.
- Postgres
- Oracle
- SQL Server
- SQLite (add your own connections if desired, but SQLite also comes included)
Connections are created in the UI and automatically stored within the system's SQLite database. The database is auto-created the first time the application starts up. Connection details will remain stored there and can be updated or deleted in the UI automatically in the "Manage Connections" section.
All library dependencies are included within requirements.txt. Simply run "pip install -r requirements.txt" in your virtual environment to build the dependencies.
- The UI is designed using Flowbite
- The editor built-in is built on top of Ace editor
- Customizable themes have been included to modify the look/feel of the editor as desired
| Task | Status |
|---|---|
| Finalize query delivery logic against target databases | COMPLETED ✅ |
| Cascading results windows | In Progress |
| Results export to CSV, Excel, and more | In Progress |
| Implement Redis or local DB for caching of historical queries | Pending |
| Docker deployment | Pending |
In accordance wih their attribution requirements, the favicon was designed using resources from Flaticon.com