ottermind/chat2db

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.