django-sql-explorer

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

These details have not been verified by PyPI

Project links

Project description

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

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

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!

Project details

These details have not been verified by PyPI

Project links

Release history Release notifications | RSS feed

5.3

Sep 24, 2024

5.3b2 pre-release

Sep 10, 2024

5.3b1 pre-release

Aug 29, 2024

5.2

Aug 19, 2024

5.2b1 pre-release

Aug 15, 2024

5.1.1

Aug 2, 2024

5.1

Jul 30, 2024

5.1b1 pre-release

Jul 24, 2024

5.0.2

Jul 3, 2024

5.0.1

Jun 26, 2024

5.0

Jun 25, 2024

5.0b3 pre-release

Jun 21, 2024

5.0b2 pre-release

Jun 17, 2024

5.0b1 pre-release

Jun 7, 2024

4.4b3 pre-release yanked

Jun 4, 2024

Reason this release was yanked:

Rereleased as 5.0 beta

4.4b1 pre-release yanked

Jun 4, 2024

Reason this release was yanked:

Re-released as 5.0 beta

4.3

May 27, 2024

4.2

Apr 26, 2024

4.2b1 pre-release

Apr 25, 2024

4.1

Apr 23, 2024

4.1b6 pre-release

Apr 23, 2024

4.1b5 pre-release

Apr 19, 2024

4.1b4 pre-release

Apr 18, 2024

4.1b2 pre-release

Apr 17, 2024

4.1b1 pre-release

Apr 17, 2024

4.0.2

Feb 7, 2024

4.0.1

Feb 7, 2024

4.0 yanked

Feb 1, 2024

Reason this release was yanked:

Supposed to be a beta

This version

4.0b4 pre-release

Feb 5, 2024

4.0b3 pre-release

Feb 5, 2024

4.0b2 pre-release

Feb 1, 2024

3.2.1

Jul 13, 2023

3.2

May 17, 2023

3.1.1

Feb 27, 2023

3.1

Feb 25, 2023

3.0.1

Dec 16, 2022

3.0

Dec 15, 2022

2.5

Oct 9, 2022

2.5b0 pre-release

Aug 31, 2022

2.4.2

Aug 30, 2022

2.4.1

Mar 10, 2022

2.4

Feb 10, 2022

2.3

Jul 24, 2021

2.2

Jun 14, 2021

2.1.3

May 14, 2021

2.1.2

Jan 19, 2021

2.1.1

Jan 19, 2021

2.1

Jan 13, 2021

2.0

Oct 9, 2020

1.1.3

Sep 23, 2019

1.1.2

Aug 25, 2018

1.1.1

Mar 31, 2017

1.1

Mar 19, 2017

1.0

Jun 24, 2016

0.9.2

Feb 2, 2016

0.9.1

Feb 2, 2016

0.9

Feb 2, 2016

0.8

Oct 21, 2015

0.7

Feb 19, 2015

0.6

Nov 6, 2014

0.5.1

Sep 2, 2014

0.5

Jun 6, 2014

0.4.1

Feb 25, 2014

0.4

Feb 14, 2014

0.3

Jan 25, 2014

0.2

Jan 6, 2014

0.1.1

Dec 31, 2013

0.1

Dec 30, 2013

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-4.0b4.tar.gz (649.6 kB view details)

Uploaded Feb 5, 2024 Source

Built Distribution

django_sql_explorer-4.0b4-py3-none-any.whl (678.5 kB view details)

Uploaded Feb 5, 2024 Python 3

File details

Details for the file django-sql-explorer-4.0b4.tar.gz.

File metadata

Download URL: django-sql-explorer-4.0b4.tar.gz
Upload date: Feb 5, 2024
Size: 649.6 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/4.0.2 CPython/3.11.7

File hashes

Hashes for django-sql-explorer-4.0b4.tar.gz
Algorithm	Hash digest
SHA256	`ebeb85375ab0de928b38200e808e91ccf07a9637d4e1a601610ec5ab14f758c6`
MD5	`054edef20b40b078214c0f12af02c777`
BLAKE2b-256	`7df726c85c8c0724d032a8ff47ad945051207023156d8ea78d44fe699968f46a`

See more details on using hashes here.

Provenance

File details

Details for the file django_sql_explorer-4.0b4-py3-none-any.whl.

File metadata

Download URL: django_sql_explorer-4.0b4-py3-none-any.whl
Upload date: Feb 5, 2024
Size: 678.5 kB
Tags: Python 3
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/4.0.2 CPython/3.11.7

File hashes

Hashes for django_sql_explorer-4.0b4-py3-none-any.whl
Algorithm	Hash digest
SHA256	`56b9448018616bb807792fa062a7a0a34b1cf96f13eab7ceecedacb028821c78`
MD5	`0186f68ef60a52162cc2880700b12e80`
BLAKE2b-256	`1f5023653689c799c5b2c3e9c3f95be4f3ed8995c368bfee0c4b636d5f30a8f9`