// the find
OtterMind/Chat2DB
AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
Chat2DB is a Java-based desktop/web database client that adds natural language to SQL generation on top of standard DB management features. It targets developers and DBAs who want a DBeaver-style tool with an LLM layer bolted on. The open-source community edition covers the basics; the real AI features are paywalled in Pro.
The breadth of database support is real — 16+ databases including ClickHouse, MongoDB, Redis, and OceanBase covers most production stacks without driver gymnastics. The custom Monaco-based SQL editor ships with per-dialect IntelliSense (MySQL, PostgreSQL, Oracle, SQL Server, Redis) rather than generic token completion. Docker deployment is a single run command with a persistent volume mount, which is actually usable. The architecture separates the Spring Boot backend from the React frontend cleanly enough that you can self-host without the Electron wrapper.
The community/Pro split is egregious — data export, import, schema diff, editing query results, and the intelligent SQL editor are all Pro-only, which makes the open-source version a demo. The AI SQL generation requires you to bring your own API key in community edition, so you get the least capable version of the feature at the highest friction. The frontend pins Node 16 and requires yarn, which is already a maintenance debt given Node 16 hit EOL in 2023. There are no visible tests in the tree — for a tool that constructs and executes SQL against production databases, that's a real trust problem.