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
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- Low install friction with a pure Python wheel distribution.
License · maintenance · safety
MIT (permissive) — MIT license is permissive and imposes no restrictions on commercial or private use. You can integrate this into proprietary Django projects without licensing concerns.
last release 2024-09-24 (689 days) · last repo commit 2025-04-23 · 2,879 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 435,708 downloads/mo, #6,678 on PyPI
Alternatives
Verify before relying
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- 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
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 on this page. Verify before relying on it.
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
django-sql-explorer on PyPI
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.
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.
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 appVerify 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 the current Python release >=3.8 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 5 packagesDjangosqlparserequestsdjango-cryptography-django5cryptography |
| Maintenance | Aging 689 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 435,708 / month, #6,678 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableFramework :: Django :: 3.2Framework :: Django :: 4.2Framework :: Django :: 5.0Intended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseProgramming Language :: Python :: 3Programming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Topic :: Utilities |
Evidence: django_sql_explorer-5.3-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “django sql query editor”
- django-sql-explorerA Django-based SQL query editor and business intelligence tool that…
- django-aceIntegrates the ACE code editor into Django forms as a widget,…
- django-query-builderBuilds and executes complex SQL queries dynamically in Django…
Give your agent the search over MCP, or paste the wish link into any chat.
More Utilities packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Detects and normalizes text encoding from unknown or ambiguous sources, supporting all IANA character sets that Python's core library provides codecs for, with the ability to register custom codecs.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Pygments is a syntax highlighter that colorizes source code and text in over 500 languages and formats, outputting to HTML, LaTeX, RTF, SVG, images, or ANSI terminal sequences.
Install it if you need to display or transform source code.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
See also django-data-browser · altimate-datapilot-cli · django-queryinspect · django-query-builder · django-import-export · vanna · datasette · django-json-widget · django-querycount · osquery