AI-powered database client and MCP server for desktop and web, supporting Postgres, MySQL, MariaDB, SQL Server, ClickHouse and SQLite.
- Stars
- 28,322
- Forks
- 3,197
- Open issues
- 242
- Last commit
- 4 days ago
What is it?
Chat2DB is a cross-platform database client for Windows, macOS and Linux that runs entirely on your machine. It provides a SQL workspace with editing, completion, formatting, execution, saved SQL and execution history, along with tools to browse metadata, manage tables and objects, and edit data in place.
The built-in AI assistant lets you connect your own model to generate, explain and optimize SQL from natural language. The project supports 40+ databases including MySQL, PostgreSQL, Oracle, SQL Server, ClickHouse, MongoDB, Redis and SQLite, and new JDBC databases can be added through configuration alone.
Chat2DB is available as a desktop app, a Docker image and a web interface served locally, and an open-source CLI with MCP support is provided separately. Datasource passwords and AI API keys are encrypted with a per-installation key.
Key features
- 01Connects to 40+ databases, including MySQL, PostgreSQL, Oracle, MongoDB and Redis.
- 02Provides a SQL editor with completion, formatting, execution and history.
- 03Uses your own AI model to generate, explain and optimize SQL.
- 04Supports browsing metadata, managing tables and editing data in place.
- 05Offers data import and export, dashboards, charts and ER diagrams.
- 06Runs as a desktop app, Docker container or local web service.
Use cases
- Daily querying and editing across several MySQL or PostgreSQL instances from one client.
- Asking an AI model to draft or tune complex SQL against a local database.
- Exploring unfamiliar schemas with metadata browsing and ER diagrams.
- Running a shared local database client in a Docker container for a small team on a trusted network.
Quick start
- 1
Download the installer for your platform from GitHub Releases
- 2
Install the app, then start connecting to your databases
Things to know
- The license is source-available with additional conditions, not a standard open-source license, and the metadata shows no detected license.
- It is a single-user local application with no user accounts, so it is not suited to shared or multi-user access.
- Losing the encryption key makes stored datasource passwords and AI API keys unreadable, so it must be backed up.
- Custom JDBC drivers are executable Java code and must come from trusted sources.
Topics
FAQ
- What is Chat2DB?
- A free, local-first, AI-assisted database client and SQL workspace supporting 40+ databases across desktop, web, Docker and CLI. Chat2DB is a cross-platform database client for Windows, macOS and Linux that runs entirely on your machine. It provides a SQL workspace with editing, completion, formatting, execution, saved SQL and execution history, along with tools to browse metadata, manage tables and objects, and edit data in place.
- Is Chat2DB free to use? What license does it have?
- Chat2DB is open source under the Other license. Check the license terms before using it in commercial products.
- Is Chat2DB still maintained?
- Actively maintained. The last commit to Chat2DB was on Oct 16, 2026.
- What can I use Chat2DB for?
- Daily querying and editing across several MySQL or PostgreSQL instances from one client. Asking an AI model to draft or tune complex SQL against a local database. Exploring unfamiliar schemas with metadata browsing and ER diagrams. Running a shared local database client in a Docker container for a small team on a trusted network.
- How do I install Chat2DB?
- Download the installer for your platform from GitHub Releases Install the app, then start connecting to your databases
- Where can I get Chat2DB?
- The source code and installation instructions are on GitHub: https://github.com/OtterMind/Chat2DB
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
Free multi-platform desktop SQL client and database tool supporting 100+ databases via JDBC and ODBC drivers.
Lightweight cross-platform database client for 100+ databases, with desktop, Docker, CLI, a built-in AI SQL assistant and an MCP server.
AI-powered cross-platform desktop SQL client built with Flutter, supporting MySQL, PostgreSQL, SQL Server, SQLite and more.
Cross-platform SQL editor and database manager for Linux, macOS, and Windows, supporting MySQL, PostgreSQL, SQLite, SQL Server and many more.
A CLI and Go library for managing database schema changes through versioned SQL files or Go functions.