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
+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
#2476[aw] AI Issue Assistant failed16 comments · 2026-08-04#1873Chat2DB Community: Start here12 comments · 2026-07-19#2944Parameterised Queries: Interactive SQL Query Parameters in SQL Console9 comments · 2026-09-20#2665请问怎么通过MCP接口对软件进行操作,MCP有文档吗7 comments · 2026-08-10#2983[aw] Detection Runs5 comments · 2026-10-16#2892终端有问题5 comments · 2026-09-09#2567[MySQL] Community feature support and contribution plan5 comments · 2026-08-05#1929国产统信uos操作系统无法安装社区版软件(deb)4 comments · 2026-07-22
Discussions
#2999[Question] How to use custom port?1 comments · 2026-11-11#2954[Question] 如何验证邮箱验证大学生0 comments · 2026-09-23#2884模型列表支持的提供方太少了0 comments · 2026-09-08#2842[Idea] Unified Theme Plugin System / 统一主题插件系统0 comments · 2026-08-31#2663[Community] mac版本的数据库查询页面不显示0 comments · 2026-08-10#2565把 Chat2DB 内置 AI 从「Chat 型」强化为「任务型 Agent Runtime」6 comments · 2026-08-05#2412[Design] How should Chat2DB integrate Codex and ChatGPT subscription access?1 comments · 2026-08-03#2256[Design] Redesign SQL editor AI interaction and result workflow0 comments · 2026-07-27
Latest release
Chat2DB v5.3.8 v5.3.8 2026-10-09Chat2DB 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