---
id: django-sql-explorer
version: "5.3"
license: MIT
license_treatment: permissive
maintenance: aging
---

# django-sql-explorer — SQL Reporting that Just Works. Fast, simple, and confusion-free.Write and share queries in a delightful SQL editor, with AI assistance

License: permissive · Maintenance: aging · Downloads: 435.7K/mo

## What it is and what it does

Django SQL Explorer is a web-based SQL query interface you add to an existing Django site or run standalone. It provides a browser-based editor for writing and executing SQL queries against any database Django supports (PostgreSQL, MySQL, SQLite, Oracle, etc.), plus the ability to upload and query CSV, JSON, or SQLite files directly. Results display in the browser with built-in statistics, pivot tables, and scatter plots.

The package includes optional AI assistance—connect an OpenAI API key and get an LLM-powered SQL assistant that helps write and debug queries with automatic schema context. You can save queries for reuse, schedule snapshots to capture data over time, expose saved queries as JSON APIs, email results, and manage query history and logs. It's designed for teams that need to share data insights without requiring everyone to know SQL or have direct database access.

Use it for:

- Ad-hoc SQL reporting and data exploration without leaving your Django app or needing separate BI tools
- Non-technical users querying uploaded CSV/JSON files with a friendly UI and optional AI query help
- Scheduled data snapshots to track metrics or KPIs over time and detect trends
- Exposing read-only query results as JSON APIs for downstream applications or dashboards
- Team collaboration on SQL queries with shared history, saved queries, and email delivery of results

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

A Django-based SQL query editor and business intelligence tool that lets you write, execute, and share SQL queries against any Django-supported database or uploaded CSV/JSON/SQLite files, with optional AI-powered query assistance.

Yes, if you run Django and need a lightweight, self-hosted SQL query tool for your team. The permissive MIT license, low install friction, and production-stable status make it a solid choice. The aging maintenance (689 days since last release) is a minor concern but not a blocker—the codebase is stable and has no known vulnerabilities. Install it if you want to avoid external BI tools; skip it if you need real-time dashboards or complex visualizations beyond basic pivot tables.

## Install

pip install django-sql-explorer
uv add django-sql-explorer
poetry add django-sql-explorer

## Installing django-sql-explorer

Before you install: Low install friction with a pure Python wheel distribution. The package is in production/stable status with 2879 repository stars, though maintenance is aging—last release was 689 days ago. Five runtime dependencies (Django, sqlparse, requests, django-cryptography-django5, cryptography) are standard and well-maintained.

License in practice: MIT license is permissive and imposes no restrictions on commercial or private use. You can integrate this into proprietary Django projects without licensing concerns.

Quickstart:

pip install django-sql-explorer

# In Django settings.py, add to INSTALLED_APPS:
# 'explorer'

# In urls.py:
from explorer import urls as explorer_urls
urlpatterns = [path('explorer/', include(explorer_urls))]

# Then navigate to /explorer/ in your Django app

Requires an existing Django project (3.2, 4.2, or 5.0) and Python 3.8 or later. Database must be one that Django supports or an uploaded CSV/JSON/SQLite file.

Verify before relying:

- Whether the LLM-powered SQL assistant requires a specific OpenAI API version or if other LLM providers are fully supported
- Performance characteristics when querying very large datasets or complex joins
- Whether parameterized query UI generation works with all SQL dialects Django supports

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: aging
- Downloads: 435.7K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

django sql query editor, sql explorer reporting tool, django database query interface, sql query builder django, business intelligence sql dashboard, django query execution ui, sql reporting django app, django-admin, sql-query-tool, business-intelligence

[View on SkillFed](https://skillfed.io/packages/django-sql-explorer) · [View on PyPI](https://pypi.org/project/django-sql-explorer/)