Included is a complete test project that you can use to kick the tires.
docker compose up
This will also run a Vite dev server with hot reloading for front-end changes.
SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. It will happily connect to any SQL database that Django supports as well as user-uploaded CSV, JSON, or SQLite databases.
Quickly write and share SQL queries in a simple, usable SQL editor, view the results in the browser, and keep the information flowing.
Add an OpenAI (or other provider) API key and get an LLM-powered SQL assistant that can help write and debug queries. The assistant will automatically add relevant context and schema into the underlying LLM prompt.
SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. The project is MIT licensed, and pull requests are welcome.
Some key features include:
Writing a query and viewing the schema helper
Using the SQL AI Assistant
Viewing all queries
Query results w/ stats summary
Pivot in browser
View logs