https://github.com/explorerhq/django-sql-explorer Skip to content Navigation Menu Toggle navigation Sign in * Product + Actions Automate any workflow + Packages Host and manage packages + Security Find and fix vulnerabilities + Codespaces Instant dev environments + GitHub Copilot Write better code with AI + Code review Manage code changes + Issues Plan and track work + Discussions Collaborate outside of code Explore + All features + Documentation + GitHub Skills + Blog * Solutions By size + Enterprise + Teams + Startups By industry + Healthcare + Financial services + Manufacturing By use case + CI/CD & Automation + DevOps + DevSecOps * Resources Resources + Learning Pathways + White papers, Ebooks, Webinars + Customer Stories + Partners * Open Source + GitHub Sponsors Fund open source developers + The ReadME Project GitHub community articles Repositories + Topics + Trending + Collections * Enterprise + Enterprise platform AI-powered developer platform Available add-ons + Advanced Security Enterprise-grade security features + GitHub Copilot Enterprise-grade AI features + Premium Support Enterprise-grade 24/7 support * Pricing Search or jump to... Search code, repositories, users, issues, pull requests... Search [ ] Clear Search syntax tips Provide feedback We read every piece of feedback, and take your input very seriously. [ ] [ ] Include my email address so I can be contacted Cancel Submit feedback Saved searches Use saved searches to filter your results more quickly Name [ ] Query [ ] To see all available qualifiers, see our documentation. Cancel Create saved search Sign in Sign up You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert {{ message }} explorerhq / django-sql-explorer Public * Notifications You must be signed in to change notification settings * Fork 346 * Star 2.5k Easily share data across your company via SQL queries. License View license 2.5k stars 346 forks Branches Tags Activity Star Notifications You must be signed in to change notification settings * Code * Issues 20 * Pull requests 9 * Discussions * Actions * Projects 0 * Wiki * Security * Insights Additional navigation options * Code * Issues * Pull requests * Discussions * Actions * Projects * Wiki * Security * Insights explorerhq/django-sql-explorer This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. master BranchesTags Go to file Code Folders and files Last Last Name Name commit commit message date Latest commit History 981 Commits .github .github docs docs explorer explorer requirements requirements test_project test_project .editorconfig .editorconfig .eslintignore .eslintignore .gitignore .gitignore .nvmrc .nvmrc .pre-commit-config.yaml .pre-commit-config.yaml .readthedocs.yaml .readthedocs.yaml AUTHORS AUTHORS HISTORY.rst HISTORY.rst LICENSE LICENSE MANIFEST.in MANIFEST.in README.rst README.rst manage.py manage.py package-lock.json package-lock.json package.json package.json public_key.pem public_key.pem pypi-release-checklist.md pypi-release-checklist.md ruff.toml ruff.toml setup.cfg setup.cfg setup.py setup.py tox.ini tox.ini vite.config.mjs vite.config.mjs View all files Repository files navigation * README * License Documentation Status Latest Version Downloads License SQL Explorer * Live Demo * Documentation * Website * Demo video: inline-image 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. 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 * AI-powered SQL assistant * Quick access to schema information to make querying easier (including autocomplete) * In-browser pivot tables (which can also be shared via URLs) * 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) * Basic code-completion in the SQL editor * 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 Development Included is a test_project that you can use to kick the tires. Just create a new virtualenv, cd into test_project and run start.sh (or walk through the steps yourself) to get a test instance of the app up and running. You can now navigate to 127.0.0.1:8000/explorer/ and begin exploring! About Easily share data across your company via SQL queries. Topics django sql analytics python3 Resources Readme License View license Activity Custom properties Stars 2.5k stars Watchers 66 watching Forks 346 forks Report repository Releases 34 5.0.2 Latest Jul 3, 2024 + 33 releases Packages 0 No packages published Used by 417 * @Lyn4ever29 * @aclark4life * @aclark4life * @carloosf * @DadosGovPE * @aclark4life * @explorerhq * @ssec-jhu + 409 Contributors 90 * @chrisclark * @marksweb * @jproffitt * @daneah * @dsanders11 * @lawson89 * @dependabot[bot] * @spapas * @pre-commit-ci[bot] * @grantmcconnaughey * @meIias * @gosborn * @MattFisher * @jtrain + 76 contributors Languages * Python 57.3% * JavaScript 27.6% * HTML 13.4% * Other 1.7% Footer (c) 2024 GitHub, Inc. Footer navigation * Terms * Privacy * Security * Status * Docs * Contact * Manage cookies * Do not share my personal information You can't perform that action at this time.