sql-explorer

SQL reporting that Just Works. Fast, simple, and confusion-free. Write and share queries in a delightful SQL editor, with AI assistance.

What is sql-explorer?

SQL reporting that Just Works. Fast, simple, and confusion-free. Write and share queries in a delightful SQL editor, with AI assistance.

Overview of sql-explorer

What it is

SQL Explorer is a Django-based application for SQL reporting. It can be added to an existing Django site or used as a standalone business intelligence tool. It connects to any SQL database that Django supports, as well as user-uploaded CSV, JSON, or SQLite databases. The project is MIT licensed and accepts pull requests.

Key features

  • Support for multiple connections, admin configured or user-provided.
  • Users can upload and immediately query JSON or CSV files.
  • AI-powered SQL assistant (requires an OpenAI or other provider API key).
  • Quick access to schema information with autocomplete.
  • Ability to snapshot queries on a regular schedule, capturing changing data.
  • Query history and logs.
  • In-browser statistics, pivot tables, and scatter plots.
  • Parameterized queries that generate a friendly UI for non-SQL users.
  • Playground area for ad-hoc queries.
  • Send query results via email.
  • Saved queries can be exposed as a JSON API.

Use cases

SQL Explorer is suitable for teams that need to share SQL queries and results without confusion. It can be used for ad-hoc data exploration, scheduled reporting, and providing non-technical users with parameterized query interfaces. The AI assistant helps write and debug queries. It also supports quick analysis with in-browser pivot tables and statistics.

Getting started

A complete test project is included. To run it: docker compose up Then navigate to 127.0.0.1:8000/explorer/ and log in with admin / admin.

License and pricing

The project is open source under the MIT license. Pricing is not stated beyond being open source.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/explorerhqsql-explorer.svg)](https://yunodb.com/tools/explorerhqsql-explorer?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/explorerhqsql-explorer?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/explorerhqsql-explorer.svg" alt="Featured on YunoDB" height="20"></a>