SQL Explorer is a Django-based business intelligence tool designed for fast, simple, and confusion-free SQL reporting. It empowers users, from analysts to developers, to write, share, and visualize SQL queries with an intuitive editor and AI assistance, reducing reliance on external tools for data exploration.

How It Works

SQL Explorer connects to any Django-supported SQL database or user-uploaded CSV/JSON files. It features a robust SQL editor with schema information and autocompletion. An AI assistant, powered by OpenAI or other providers, aids in query writing and debugging by incorporating schema context into LLM prompts. Results can be visualized directly in the browser with features like pivot tables and scatter-plots, and queries can be scheduled for snapshots or exposed as JSON APIs.

Quick Start & Requirements

• Install/Run: docker compose up (from the project root). Navigate to 127.0.0.1:8000/explorer/ with admin/admin credentials.
• Prerequisites: Docker.
• Setup Time: Minimal via Docker.
• Links: Official Website, Live Demo, Documentation

Highlighted Details

• AI-powered SQL assistant for query generation and debugging.
• Supports multiple database connections and user-uploaded data (CSV, JSON).
• Features include query scheduling, history, parameterized queries, and in-browser statistics/pivot tables.
• Saved queries can be exposed as simple JSON APIs.

Maintenance & Community

The project is actively maintained, with a focus on stability and ease of use. Pull requests are welcomed. Further community engagement details are not explicitly provided in the README.

Licensing & Compatibility

• License: MIT License.
• Compatibility: Compatible with commercial use and closed-source linking due to its permissive MIT license.

Limitations & Caveats

The AI assistant requires an API key from a supported provider. While it supports various data sources, advanced BI features might require dedicated tools. The project is presented as a "quick-n-dirty" solution for JSON APIs, implying potential limitations for robust API development.