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

Navigation

Verified details

These details have been verified by PyPI
Maintainers
Avatar for clarkcw1 from gravatar.com clarkcw1 Avatar for markwalker from gravatar.com markwalker

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: MIT License (MIT)
  • Author: Chris Clark
  • Maintainer: Mark Walker
  • Tags django, sql, explorer, reports, reporting, csv, database, query
  • Requires: Python >=3.6
Classifiers

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

Verified details

These details have been verified by PyPI
Maintainers
Avatar for clarkcw1 from gravatar.com clarkcw1 Avatar for markwalker from gravatar.com markwalker

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: MIT License (MIT)
  • Author: Chris Clark
  • Maintainer: Mark Walker
  • Tags django, sql, explorer, reports, reporting, csv, database, query
  • Requires: Python >=3.6
Classifiers

Release history Release notifications | RSS feed

5.3

5.3b2 pre-release

5.3b1 pre-release

5.2

5.2b1 pre-release

5.1.1

5.1

5.1b1 pre-release

5.0.2

5.0.1

5.0

5.0b3 pre-release

5.0b2 pre-release

5.0b1 pre-release

4.4b3 pre-release yanked

Reason this release was yanked:

Rereleased as 5.0 beta

4.4b1 pre-release yanked

Reason this release was yanked:

Re-released as 5.0 beta

4.3

4.2

4.2b1 pre-release

4.1

4.1b6 pre-release

4.1b5 pre-release

4.1b4 pre-release

4.1b2 pre-release

4.1b1 pre-release

4.0.2

4.0.1

4.0 yanked

Reason this release was yanked:

Supposed to be a beta

4.0b4 pre-release

4.0b3 pre-release

4.0b2 pre-release

3.2.1

3.2

3.1.1

3.1

3.0.1

3.0

2.5

2.5b0 pre-release

This version

2.4.2

2.4.1

2.4

2.3

2.2

2.1.3

2.1.2

2.1.1

2.1

2.0

1.1.3

1.1.2

1.1.1

1.1

1.0

0.9.2

0.9.1

0.9

0.8

0.7

0.6

0.5.1

0.5

0.4.1

0.4

0.3

0.2

0.1.1

0.1

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.4.2.tar.gz (338.6 kB view details)

Uploaded Source

Built Distribution

django_sql_explorer-2.4.2-py3-none-any.whl (364.9 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: django-sql-explorer-2.4.2.tar.gz
  • Upload date:
  • Size: 338.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.8.0 pkginfo/1.8.2 readme-renderer/32.0 requests/2.27.1 requests-toolbelt/0.9.1 urllib3/1.26.8 tqdm/4.62.3 importlib-metadata/4.10.1 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.13

File hashes

Hashes for django-sql-explorer-2.4.2.tar.gz
Algorithm Hash digest
SHA256 7e224a382a86229f323ce8373afe06b4f3ebc948b9a805e72b7d55d53c4479bb
MD5 772a1972fc390c82645232d5f1c4a87c
BLAKE2b-256 3553c9d47b0bc268bc0a8f1f3e2079c44b4c95968176d1301809f8c8d9a58cee

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: django_sql_explorer-2.4.2-py3-none-any.whl
  • Upload date:
  • Size: 364.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.8.0 pkginfo/1.8.2 readme-renderer/32.0 requests/2.27.1 requests-toolbelt/0.9.1 urllib3/1.26.8 tqdm/4.62.3 importlib-metadata/4.10.1 keyring/23.5.0 rfc3986/2.0.0 colorama/0.4.4 CPython/3.9.13

File hashes

Hashes for django_sql_explorer-2.4.2-py3-none-any.whl
Algorithm Hash digest
SHA256 e98363d7f3402d553ba436708cad2db0dcc3f96b001cbf7ccd440c929a8e62e9
MD5 038bd1eb26d60d4da77c327911b10062
BLAKE2b-256 7d1cad093aff8b50f5d5376be1d1f78d59aa57072ad4434f45d805994bed61c8

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