Chat2DB

Open source

A free, local-first desktop database client and SQL workspace that supports 40+ databases and lets you connect your own AI model to write, explain and optimize SQL.

chat2db.ai
Chat2DB homepage screenshot
GitHub stars
28k
Last 30 days
+51(+0%)
Last commit
2 days ago
Repository age
3 years
Version
v5.3.8
Licence
Custom
Self-hosted
Yes

About Chat2DB

Chat2DB is a free desktop database client and SQL workspace aimed at developers, DBAs, analysts and data teams on any platform. The Community edition runs entirely on your own machine on Windows, macOS and Linux, and pairs a full SQL editor with an AI assistant that you connect to the model of your choice rather than one bundled with the app.

It connects to more than 40 databases, including MySQL, Oracle, PostgreSQL, SQL Server, MongoDB, Redis, ClickHouse, SQLite, MariaDB, TiDB, Snowflake and BigQuery, and new JDBC databases can be added through configuration alone. The SQL workspace covers editing, completion, formatting, execution, saved queries and history. Database management features let you browse metadata, manage tables and other objects and edit data in place, and there are tools for data import and export, dashboards and charts, plus a command line interface.

The AI assistant generates, explains and optimizes SQL from natural-language requests, and topics mention MCP support. Chat2DB is written in Java and powered by OtterMind, and its license is listed as 'Other' on GitHub, so check the terms before redistribution. It suits people who want one tool for many databases and would like to keep queries and credentials local.

Key features

  • Connects to 40+ databases via JDBC
  • SQL editor with completion and history
  • Bring-your-own-model AI for SQL generation
  • Table and object management with in-place editing
  • Data import, export, dashboards and charts
  • Runs locally on Windows, macOS and Linux

Good fit for

  • Managing several database types from one client
  • Generating SQL from plain-language questions
  • Keeping database credentials and queries on your own machine
Tags
database-client
sql
ai
jdbc
desktop-app
database-gui
local-first
mcp

Chat2DB: questions and answers

What is Chat2DB used for?
Chat2DB is a free, local-first desktop database client and SQL workspace that supports 40+ databases and lets you connect your own AI model to write, explain and optimize SQL. It is a good fit for managing several database types from one client, generating SQL from plain-language questions, and keeping database credentials and queries on your own machine.
Is Chat2DB open source?
Yes. Chat2DB is open source under a custom licence. Its source code is on GitHub at OtterMind/Chat2DB and is written mainly in Java.
Is Chat2DB free?
Yes. Chat2DB is open source, so the software itself is free to use under the terms of its own licence.
What is Chat2DB an alternative to?
Chat2DB is an open-source alternative to DataGrip, Navicat, TablePlus and DbVisualizer. Other open-source alternatives to DataGrip include Dbx, DBeaver and Beekeeper Studio.
Is Chat2DB actively maintained?
Yes. The most recent commit to Chat2DB was on 11 November 2026, and the latest release is v5.3.8, published on 9 October 2026. The project has 28k stars on GitHub, with 51 added in the last 30 days.

Open-source alternatives to Chat2DB

See all

SaaS alternatives to Chat2DB

See all