📈 GH Trending Explorer 🎲 Surprise me

← all repos

OtterMind / Chat2DB

git clone https://github.com/OtterMind/Chat2DB.git v5.3.8 · 13d ago

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.

+5
stars, 24h · #2,980
+~35
stars, 7 days · #3,608
+~150
stars, 30 days · #3,604
28k
★ total · +0% this week
3.0k
forks · 242 open issues

Star history (as recorded here)

2026-10-20 · 28,324 ★ 2026-10-22 · 28,329 ★
LanguageJava
License—
Created2023-06-20 (3y ago)
Last push2d ago
Watchers166
OwnerOrganization

GitHub topics

Links

README excerpt
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 |
| --- | --- |
| | |
| 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:
 [code] 
Then open `http://localhost:10825` in your browser.
Alternatively, use the bundled Compose definition:
 [code] 
Notes:
- To update, pull the new image, remove the old container, and run the start command again. Keep `~/.config/chat2db-community/encryption.key` across rebuilds.
- The `docker run` example stores application data in `$HOME/.chat2db-community-docker`; the Compose definition uses the `chat2db-community-data` named volume. These locations do not share data.
- Chat2DB Community 5.3.0 uses the independent `/root/.chat2db-community` directory and does not