Repolode
OtterMind

OtterMind/Chat2DB

A free, local-first, AI-assisted database client and SQL workspace supporting 40+ databases across desktop, web, Docker and CLI.

Open-source alternative to:NavicatDBeaverDataGrip

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. 1

    Download the installer for your platform from GitHub Releases

  2. 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