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 <https://docs.djangoproject.com/en/5.0/ref/databases/>_ 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

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

Using the SQL AI Assistant

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

Viewing all queries

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

Query results w/ stats summary

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

Pivot in browser

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

View logs

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

Keywords

django sql explorer reports reporting csv json database query

FAQs

What is django-sql-explorer?

Is django-sql-explorer well maintained?

Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install