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)
LanguageJava
License—
Created2023-06-20 (3y ago)
Last push2d ago
Watchers166
OwnerOrganization
GitHub topics
aiclickhousedatabasedatabase-clientdatabase-guidatabase-managementjdbcllmmcpmongodbmysqloraclepostgresqlredissqlsql-clientsql-editorsql-serversqlitetext-to-sql
Links
- GitHub: github.com/OtterMind/Chat2DB
- Homepage: https://chat2db.ai
- Releases · Issues · Hacker News mentions
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