Skip to main content

A pluggable app that allows users (admins) to execute SQL, view, and export the results.

Project description

Documentation Status Build Status Latest Version Downloads License

SQL Explorer

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 inspired by any number of great query and reporting tools out there.

The original idea came from Stack Exchange’s Data Explorer, but also owes credit to similar projects like Redash and Blazer.

You can read the full documentation here

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

A view of a query

https://s3-us-west-1.amazonaws.com/django-sql-explorer/2019_2.png

Viewing all queries

https://s3-us-west-1.amazonaws.com/django-sql-explorer/2019_querylist.png

Quick access to DB schema info

https://s3-us-west-1.amazonaws.com/django-sql-explorer/2019_3.png

Snapshot query results to S3 & download as csv

https://s3-us-west-1.amazonaws.com/django-sql-explorer/2019_snapshots.png

Alternatives

  • django-sql-dashboard: provides an authenticated interface for executing read-only SQL queries directly against your PostgreSQL database, bringing a useful subset of Datasette to Django.

Project details


Release history Release notifications | RSS feed

This version

2.3

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django-sql-explorer-2.3.tar.gz (217.4 kB view details)

Uploaded Source

Built Distribution

django_sql_explorer-2.3-py3-none-any.whl (247.8 kB view details)

Uploaded Python 3

File details

Details for the file django-sql-explorer-2.3.tar.gz.

File metadata

  • Download URL: django-sql-explorer-2.3.tar.gz
  • Upload date:
  • Size: 217.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/50.3.0 requests-toolbelt/0.9.1 tqdm/4.50.0 CPython/3.8.0

File hashes

Hashes for django-sql-explorer-2.3.tar.gz
Algorithm Hash digest
SHA256 031788a88938102c454679b0d97a41d0e177280fd4c39aebf73b157ece62c960
MD5 0055ca3424b0adbeedae9803e62a65dc
BLAKE2b-256 bbdfdcc3eb4e8bcdfc4a24784d40b097eea8c413ed6597659a3510344054a33b

See more details on using hashes here.

Provenance

File details

Details for the file django_sql_explorer-2.3-py3-none-any.whl.

File metadata

  • Download URL: django_sql_explorer-2.3-py3-none-any.whl
  • Upload date:
  • Size: 247.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/50.3.0 requests-toolbelt/0.9.1 tqdm/4.50.0 CPython/3.8.0

File hashes

Hashes for django_sql_explorer-2.3-py3-none-any.whl
Algorithm Hash digest
SHA256 4fc032c8cb9abad491703854a5ff5ae4576b4aacf63100aa0356d301432d8373
MD5 6a9210f6003f245ed3f812d2dcfed086
BLAKE2b-256 4b0636f0fe932670d02ade2fa9e4c69fdbf2cf8a92d8a16dd6312839facea736

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page