Django SQL Explorer

SQL Explorer

Official Website

Full Documentation

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!

SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. Sql Explorer is MIT licensed, and pull requests are welcome.

Some key features include:

• Support for multiple connections

• Quick access to schema information to make querying easier

• 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

Viewing all queries

Query results rendered in browser

Pivot in browser

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/ and begin exploring!

Contents:

• Features
  • Security
  • Easy to get started
  • SQL Assistant
  • Snapshots
  • Email query results
  • Parameterized Queries
  • Schema Helper
  • Template Columns
  • Pivot Table
  • Displaying query results as charts
  • Query Logs
  • Multiple Connections
  • Power tips
• Install
  • AI SQL Assistant
  • Other Parameters
  • Installing From Source
• Running Locally (quick start)
• Installing From Source
• Tests
• Running Celery
• Settings
  • SQL Blacklist
  • Default rows
  • Include table prefixes
  • Exclude table prefixes
  • Include views
  • ASYNC schema
  • Default connection
  • Database connections
  • Permission view
  • Permission change
  • Transforms
  • Recent query count
  • User query views
  • Token Authentication
  • Token
  • Celery tasks
  • S3 access key
  • S3 secret key
  • S3 bucket
  • S3 region
  • S3 endpoint url
  • S3 destination path
  • S3 link expiration
  • S3 signature version
  • From email
  • Data exporters
  • Unsafe rendering
  • No permission view
  • Anonymous Usage Stat Collection
• Dependencies
  • Python
  • JavaScript & CSS
• Change Log
  • `4.1.0`_ (TBD)
  • `4.0.2`_ (2024-02-06)
  • 4.0.0.beta1 (2024-02-01)
  • 3.2.1 (2023-07-13)
  • 3.2.0 (2023-05-17)
  • 3.1.1 (2023-02-27)
  • 3.1.0 (2023-02-25)
  • 3.0.1 (2022-12-16)
  • 3.0 (2022-12-15)
  • 2.5.0 (2022-10-09)
  • 2.4.2 (2022-08-30)
  • 2.4.1 (2022-03-10)
  • 2.4.0 (2022-02-10)
  • 2.3.0 (2021-07-24)
  • 2.2.0 (2021-06-14)
  • 2.1.3 (2021-05-14)
  • 2.1.2 (2021-01-19)
  • 2.1.1 (2021-01-19)
  • 2.1.0 (2021-01-13)
  • 2.0.0 (2020-10-09)
  • 1.1.3 (2019-09-23)
  • 1.1.2 (2018-08-14)
  • 1.1.1 (2017-03-21)
  • 1.1.0 (2017-03-19)
  • 1.0.0 (2016-06-16)
  • 0.9.2 (2016-02-02)
  • 0.9.1 (2016-02-01)
  • 0.8.0 (2015-10-21)
  • 0.7.0 (2015-02-18)
  • 0.6.0 (2014-11-05)
  • 0.5.1 (2014-09-02)
  • 0.5.0 (2014-06-06)
  • 0.4.1 (2014-02-24)
  • 0.4 (2014-02-14 Happy Valentine’s Day!)
  • 0.1.1 (2013-12-31)