OtterMind /Chat2DB

Chat2DB is a free, cross-platform, local-first database client and SQL workspace for developers, DBAs, analysts, and data teams. Connect to 40+ databases, manage data, edit and run SQL, and use your own AI model to generate, explain, and optimize queries. Available on desktop, web, Docker, and CLI, with MCP support.

★ 28,362⑂ 3,045👁 160⑃ 1,247● 1,613▤ 13
JavaNOASSERTIONCreated 2023-06-20chat2db.ai
Download: Chat2DB v5.3.8Chat2DB-5.3.8 ↓5.3.82026-10-09
+0
Daily
+13
Weekly
+52
Monthly
28,362
stars
3,045
forks
160
watchers
1,247
prs
1,613
issues
13
releases

README

Powered by  OtterMind

  
  An AI-powered database client and SQL workspace for developers, DBAs, analysts, and data teams.



  
  
  
  
  


 What is Chat2DB?

Chat2DB Community is a free, cross-platform database client for Windows, macOS, and Linux. It runs entirely on your machine and combines a full-featured SQL workspace with an AI assistant that you connect to your own model.

- 40+ databases — 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, Apache Derby, and more via plugins — new JDBC databases can be added through configuration only, without code changes.
- SQL workspace — editing, completion, formatting, execution, saved SQL, and execution history.
- AI assistant — bring your own AI model to generate, explain, and optimize SQL in natural language.
- Database management — browse metadata, manage tables and objects (DDL/DML), and edit data in place.
- Data import and export, dashboards and charts, and an open-source CLI with MCP support.







 Screenshots

| Dashboards and charts | ER diagrams |
| --- | --- |
| !Dashboards and charts | !ER diagram |

| Visual data management | Data import and export |
| --- | --- |
| !Visual data management | !Data import and export |

 Early preview

The next feature line ships as an early preview before it reaches the regular Beta channel:

- Chat2DB Community 5.4.0-beta.1 (early preview) — installers for macOS, Windows and Linux.
- It adds an optional local agent runtime with skills, external MCP servers, and file and terminal tools; choose Pi Agent in the AI input's runtime selector to enable it (the first selection asks for confirmation and downloads the runtime).
- This preview is neither the stable nor the regular Beta release: Latest stays on the stable build, and the regular Beta line continues with 5.3.8-beta.x. Enable Receive Beta versions in Settings → About Us to receive it in the app.

 Quick Start

 Option 1: Desktop App

Download the installer for your platform from GitHub Releases, install it, and start connecting to your databases. No further setup is required.

 Option 2: Docker

Requirements: Docker 19.03.0+, Docker Compose 2.0.0+ (Compose V2, only for the Compose variant), 2+ CPU cores, 4+ GiB RAM.

First create the encryption key (see Encryption Key for why it matters), then start the container:

bash
 Run once from a repository checkout. Re-running reuses the same valid key.
git clone https://github.com/OtterMind/Chat2DB.git && cd Chat2DB
./script/security/init-community-encryption-key.sh

docker run --detach \
  --name chat2db-community \
  --restart unless-stopped \
  --publish 127.0.0.1:10825:10825 \
  --volume "$HOME/.chat2db-community-docker:/root/.chat2db-community" \
  --env CHAT2DB_COMMUNITY_ENCRYPTION_KEY_FILE=/run/secrets/chat2db-community-encryption.key \
  --volume "$HOME/.config/chat2db-

Top issues

Discussions

Latest release

Chat2DB v5.3.8 v5.3.8 2026-10-09
Chat2DB Community 5.3.8 reads, copies and exports complete large values instead of truncated previews - including for views, aggregations and tables without a primary key - adds the SQLX command line integration to Settings, and fixes table browsing and the KingbaseES procedure list.

 Added (1)

1. SQLX command line integration: install, update and locate the OtterMind SQLX CLI from Settings, import the connections Chat2DB already stores, and see the Skill command an agent needs; credentials go to the child process on stdin and are never written to disk, the renderer or the logs. by @openai02

Snapshot: 2026-11-16T09:23:14Z · Data license Apache-2.0 · JSON