Django SQL Explorer

SQL Explorer

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.

Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing!

Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more.

SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise.

Sql Explorer is MIT licensed, and pull requests are welcome.

A view of a query

Viewing all queries

Quick access to DB schema info

Snapshot query results to S3 & download as csv

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
  • Snapshots
  • Email query results
  • Parameterized Queries
  • Schema Helper
  • Template Columns
  • Pivot Table
  • Displaying query results as charts
  • Query Logs
  • Multiple Connections
  • Power tips
• Install
  • Installing From Source
• 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
• Dependencies
  • Python
  • JavaScript & CSS
  • Tests
  • Running Locally
• Change Log
  • `4.0b2`_ (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.3 (2014-01-25)
  • 0.2 (2014-01-05)
  • 0.1.1 (2013-12-31)
  • 0.1 (2013-12-29)