SQL Explorer

Video Tour

Quick Start

Included is a complete test project that you can use to kick the tires.

Run docker compose up
Navigate to 127.0.0.1:8000/explorer/
log in with admin/admin
Begin exploring!

This will also run a Vite dev server with hot reloading for front-end changes.

About

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:

Support for multiple connections, admin configured or user-provided.
Users can upload and immediately query JSON or CSV files.
AI-powered SQL assistant
Quick access to schema information to make querying easier (including autocomplete)
Ability to snapshot queries on a regular schedule, capturing changing data
Query history and logs
Quick in-browser statistics, pivot tables, and scatter-plots (saving a trip to Excel for simple analyses)
Parameterized queries that automatically generate a friendly UI for users who don’t know SQL
A playground area for quickly running ad-hoc queries
Send query results via email
Saved queries can be exposed as a quick-n-dirty JSON API if desired
…and more!

Screenshots

Writing a query and viewing the schema helper

https://sql-explorer.s3.amazonaws.com/5.0-query-with-schema.png

Using the SQL AI Assistant

https://sql-explorer.s3.amazonaws.com/5.0-assistant.png

Viewing all queries

https://sql-explorer.s3.amazonaws.com/5.0-query-list.png

Query results w/ stats summary

https://sql-explorer.s3.amazonaws.com/5.0-query-results.png

Pivot in browser

https://sql-explorer.s3.amazonaws.com/5.0-pivot.png

View logs

https://sql-explorer.s3.amazonaws.com/5.0-querylogs.png

Release files for django-sql-explorer 5.3.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for django-sql-explorer 5.3.1
File	Size	Uploaded
django_sql_explorer-5.3.1.tar.gz	912.2 kB	Sep 24, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for django-sql-explorer 5.3.1
File	Interpreter	ABI	Platform	Reset
django_sql_explorer-5.3.1-py3-none-any.whl 959.9 kB Sep 24, 2026	Python 3	none	any	Details

Total release size: 1.9 MB

Release files / django_sql_explorer-5.3.1.tar.gz

Download URL	django_sql_explorer-5.3.1.tar.gz
Size	912.2 kB
Tags	Source
SHA-256 checksum How to use checksums	`602b7e7392a359c21e57717b40559e9c70c170be9ac7c6f6918656dfe5f6474e`
BLAKE2b-256 checksum How to use checksums	`20ac10dbd41b5321172df7ab0b9f08a5bf7cef7bb9ab6efb70a27cdbde9aeb1d`
Upload date	Sep 24, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/explorerhq/sql-explorer
Publishing commit: github.com/explorerhq/sql-explorer/tree/82cc7e40784279a235705b08d092f186fd201e96

Workflow

Publishing configuration: github.com/explorerhq/sql-explorer/blob/82cc7e40784279a235705b08d092f186fd201e96/.github/workflows/publish-pypi.yml
Publishing logs: github.com/explorerhq/sql-explorer/actions/runs/36057901360/attempts/1

Artifact

Subject: django_sql_explorer-5.3.1.tar.gz
SHA-256 checksum: 602b7e7392a359c21e57717b40559e9c70c170be9ac7c6f6918656dfe5f6474e Verifying attestations

Release files / django_sql_explorer-5.3.1-py3-none-any.whl

Download URL	django_sql_explorer-5.3.1-py3-none-any.whl
Size	959.9 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`e9fcf617e51e78c26161622d218d5a03d891f56477ed49b28483d12c2aef6381`
BLAKE2b-256 checksum How to use checksums	`8916841361f1449cfe073136a178ed113134dacb9a6439293b0e6f4499ede41a`
Upload date	Sep 24, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/explorerhq/sql-explorer
Publishing commit: github.com/explorerhq/sql-explorer/tree/82cc7e40784279a235705b08d092f186fd201e96

Workflow

Publishing configuration: github.com/explorerhq/sql-explorer/blob/82cc7e40784279a235705b08d092f186fd201e96/.github/workflows/publish-pypi.yml
Publishing logs: github.com/explorerhq/sql-explorer/actions/runs/36057901360/attempts/1

Artifact

Subject: django_sql_explorer-5.3.1-py3-none-any.whl
SHA-256 checksum: e9fcf617e51e78c26161622d218d5a03d891f56477ed49b28483d12c2aef6381 Verifying attestations