SnapQL is an AI-powered client for PostgreSQL and MySQL databases, designed for data analysts and developers. It simplifies data exploration by generating schema-aware SQL queries and automatically creating charts from data, all while keeping database credentials local.

How It Works

SnapQL leverages AI models (requiring user-provided OpenAI or Claude API keys) to interpret natural language requests and generate SQL queries. It then visualizes the results, offering a streamlined workflow for data interaction without exposing sensitive credentials to external services.

Quick Start & Requirements

• Install globally via make install-global after cloning the repository.
• Requires Node.js and npm. macOS users need Xcode installed.
• Supports PostgreSQL and MySQL databases.

Highlighted Details

• AI-powered query generation from natural language.
• Automatic data charting.
• Local-first architecture for enhanced security.
• Support for multiple database connections with history and favorites.

Maintenance & Community

• Community feedback is encouraged via a Telegram group.

Licensing & Compatibility

• The repository does not explicitly state a license.

Limitations & Caveats

• Currently requires local building; precompiled binaries are not yet available.
• Relies on user-provided API keys for AI functionality.