Connect to and manage multiple databases like MySQL, PostgreSQL, and MongoDB from one desktop app.
Write, format, and run SQL queries and save your execution history.
Use your own AI model to generate, explain, and optimize SQL using natural language.
Build visual dashboards, create charts, and view entity relationship diagrams for your data.
| ottermind/chat2db | kestra-io/kestra | qiurunze123/miaosha | |
|---|---|---|---|
| Stars | 26,770 | 26,792 | 26,604 |
| Language | Java | Java | Java |
| Setup difficulty | easy | hard | hard |
| Complexity | 2/5 | 4/5 | 4/5 |
| Audience | developer | ops devops | developer |
Figures from each repo's GitHub metadata at analysis time.
Download the desktop installer for zero-setup use, or run via Docker which requires generating a custom encryption key to protect stored passwords.
Chat2DB is a free, open-source database client that runs on Windows, macOS, and Linux. It is designed for developers, database administrators, analysts, and data teams who need to connect to and manage databases. The application works entirely on your local machine and pairs a standard SQL workspace with an AI assistant that you can connect to your own AI model. The tool supports connections to more than 30 different database systems. These include popular options like MySQL, PostgreSQL, Oracle, SQL Server, and SQLite, along with newer systems like ClickHouse, MongoDB, Redis, Snowflake, BigQuery, and Elasticsearch. You can manage tables, browse database metadata, edit data directly in the interface, and import or export information. It also includes features for building dashboards, creating charts, and viewing entity relationship diagrams. A command-line tool with MCP support is available as a separate open-source project. The SQL workspace provides a full editing environment. You can write, format, and execute SQL queries, save them for later use, and review your execution history. The AI assistant component lets you bring your own model to generate, explain, and optimize SQL using natural language requests. To get started, you can download a desktop installer from the GitHub Releases page, which requires no additional setup. Alternatively, you can run Chat2DB in a Docker container, which requires Docker version 19.03.0 or newer, at least two CPU cores, and four or more gigabytes of RAM. The Docker approach involves generating an encryption key before starting the container, after which you access the application through your web browser at a local address. Security is a notable focus. Chat2DB Community is a single-user, local-first application with no user accounts or authorization boundaries. The documentation advises keeping the service bound to your local machine and not exposing it to untrusted networks. Stored datasource passwords and AI model API keys are encrypted with AES-256-GCM using a per-installation key. You must back this key up, because losing it makes previously stored passwords and keys unreadable. Custom Java database drivers are executable code, so the documentation warns to install them only from trusted sources.
Chat2DB is a free desktop database client for Windows, Mac, and Linux that lets you manage 30+ databases with a full SQL editor and an AI assistant you can connect to your own model.
Mainly Java. The stack also includes Java, Docker.
This is an open-source project, but the specific license terms are not detailed in the provided explanation.
Setup difficulty is rated easy, with roughly 5min to a first successful run.
Mainly developer.
This repo across BitVibe Labs
Verify against the repo before relying on details.