chat2db

Chat2DB Community is a free, cross-platform, local-first database client and SQL workspace developed by OtterMind. Its README describes it as an AI-powered tool for developers, DBAs, analysts, and data teams, running on Windows, macOS, and Linux and combining a full SQL workspace with an AI assistant connected to a user-supplied model. Key capabilities include connecting to more than 40 databases, such as MySQL, PostgreSQL, Oracle, SQL Server, ClickHouse, MongoDB, Redis, SQLite, MariaDB, TiDB, Hive, DB2, Snowflake, BigQuery, Elasticsearch, Trino, TimescaleDB, Greenplum, YugabyteDB, CrateDB, QuestDB, Apache IoTDB, Firebird, HSQLDB, and Apache Derby. New JDBC databases can be added through configuration without code changes. The SQL workspace provides editing, completion, formatting, execution, saved SQL, and execution history. The AI assistant can generate, explain, and optimize SQL using natural language with the user's own AI model. Database management features include metadata browsing, table and object management through DDL/DML, and in-place data editing. The project also lists data import and export, dashboards and charts, and an open-source CLI with MCP support. Deployment options include desktop installers from GitHub Releases, a Docker image with Docker Compose support, browser access at localhost:10825, and a CLI. Docker is documented as requiring Docker 19.03.0+, Docker Compose 2.0.0+ for the Compose variant, 2+ CPU cores, and 4+ GiB RAM. Building from source requires Eclipse Temurin 17, Node.js 18.17.0 or later, and Maven 3.8 or later. Security and encryption: Chat2DB Community is described as a single-user, local-first application without user accounts or authorization boundaries. The README advises binding the HTTP service to 127.0.0.1 or ::1 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. Web/headless startup fails without a valid key, while Desktop mode can create a missing key automatically. The key file should be backed up and retained across upgrades and container rebuilds. Custom JDBC drivers are executable Java code and should be installed only from trusted sources. Licensing and editions: Chat2DB Community 5.3.0 and later uses a source-available license based on Apache License 2.0 with additional conditions. Releases before 5.3.0, including 0.3.7 and earlier historical tags, remain under Apache License 2.0. The commercial Pro and Enterprise editions add hosted AI services, user accounts, cloud storage and multi-device sync, and team collaboration and governance features.