sql-explorer
SQL reporting that Just Works. Fast, simple, and confusion-free. Write and share queries in a delightful SQL editor, with AI assistance.
What is sql-explorer?
SQL reporting that Just Works. Fast, simple, and confusion-free. Write and share queries in a delightful SQL editor, with AI assistance.
Overview of sql-explorer
What it is
SQL Explorer is a Django-based application for SQL reporting. It can be added to an existing Django site or used as a standalone business intelligence tool. It connects to any SQL database that Django supports, as well as user-uploaded CSV, JSON, or SQLite databases. The project is MIT licensed and accepts pull requests.
Key features
- Support for multiple connections, admin configured or user-provided.
- Users can upload and immediately query JSON or CSV files.
- AI-powered SQL assistant (requires an OpenAI or other provider API key).
- Quick access to schema information with autocomplete.
- Ability to snapshot queries on a regular schedule, capturing changing data.
- Query history and logs.
- In-browser statistics, pivot tables, and scatter plots.
- Parameterized queries that generate a friendly UI for non-SQL users.
- Playground area for ad-hoc queries.
- Send query results via email.
- Saved queries can be exposed as a JSON API.
Use cases
SQL Explorer is suitable for teams that need to share SQL queries and results without confusion. It can be used for ad-hoc data exploration, scheduled reporting, and providing non-technical users with parameterized query interfaces. The AI assistant helps write and debug queries. It also supports quick analysis with in-browser pivot tables and statistics.
Getting started
A complete test project is included. To run it: docker compose up Then navigate to 127.0.0.1:8000/explorer/ and log in with admin / admin.
License and pricing
The project is open source under the MIT license. Pricing is not stated beyond being open source.
Based on the project's public README and repository metadata.