Favicon of Chat2DB

Chat2DB

A free local-first database client for Windows, macOS and Linux that connects to your own AI model to generate, explain and optimize SQL.

Screenshot of Chat2DB website

Chat2DB Community is a database client and AI SQL workspace for developers, database administrators and analysts. It runs on Windows, macOS and Linux, with Docker and browser access also available. Its AI assistant connects to a model you configure to generate, explain and optimize SQL. Where AI requests are processed depends on that model connection.

The SQL workspace supports editing, completion, formatting, execution, saved queries and execution history. You can browse database metadata, manage tables and edit records. Supported databases include PostgreSQL, MySQL, SQLite, Oracle, SQL Server, ClickHouse, MongoDB and Redis, as well as Snowflake and BigQuery.

Community includes data import and export, dashboards and charts. An open-source CLI provides MCP support for connecting AI tools.

Community is a single-user application with no user accounts or authorization boundaries. Keep its HTTP service bound to localhost. Stored database passwords and model API keys are encrypted with AES-256-GCM; preserve the installation encryption key across upgrades and container rebuilds.

Similar to Chat2DB