AI tools, scored for your job
Get paid to train AI
🤝 You're in the Free & Open Source library — community-built tools you can use without paying. A different concept from our scored AI directory.
Home › Free & Open Source › Productivity › Chat2DB
✦ Free & open sourceProductivity

Chat2DB

An AI-powered database client and SQL workspace for 40+ databases.

AI-Powered Database Client & SQL Workspace

Connect to 40+ databases, manage data, and run AI-assisted queries locally.

Free forever · source-available · Licence not stated in the repository
✓ Light setup✓ Browser-based✓ Real-time collaboration
8.2
ZEKAI
Local-first multi-database client
Free & open source · Productivity
Ease of setup6
Usefulness8
Maintenance9.5
Community9.2
★ 28,364
GITHUB
Nov 2026
UPDATED
Licence not stated in the repository
LICENSE
🛠 Don't want to self-host? We can set it up →
⚡ Quick answer

Chat2DB is a cross-platform, local-first database client that combines a full-featured SQL workspace with an AI assistant connected to your own model. It is designed for developers, DBAs, analysts, and data teams who need to manage multiple database types.

Runs on
Cross-platform
Hosting
Desktop
Languages
Java
License
Licence not stated in the repository

What it is

The application provides a visual SQL workspace with editing, completion, formatting, and execution history across over 40 database systems. You can browse metadata, manage DDL/DML, edit data in place, build charts, and use your own AI model to generate and optimize queries.

Who it's for

It suits data professionals and developers managing diverse SQL and NoSQL databases who want an integrated AI assistant. It does not suit teams requiring strict multi-user authorization boundaries or centralized user management.

Key features

40+ Database Support

Connect to MySQL, PostgreSQL, Oracle, MongoDB, and dozens of others with plugin support.

Bring Your Own AI

Connect your own AI model to generate, explain, and optimize SQL queries in natural language.

Visual Data Management

Browse metadata, manage tables, execute DDL/DML, and view ER diagrams.

Local CLI and MCP

Includes an open-source CLI with MCP support and an optional local agent runtime.

How to start

Up and running in 3 steps

1
Download the desktop app installer from GitHub or run the Docker container.
2
Initialize your AES-256-GCM encryption key file for secure credential storage.
3
Connect to your databases and configure your preferred AI model.
Real talk

Our honest verdict

What's great

  • Supports over 40 database types including niche engines via plugins
  • Local-first architecture keeps your data and workspace on your machine
  • Bring your own AI model for query generation and optimization
  • Provides visual tools like ER diagrams, dashboards, and data import/export

Where it falls short

  • Single-user application with no built-in user authorization boundaries
  • Requires manual setup and secure backup of the per-installation encryption key
  • Docker deployment requires manual configuration of encryption keys and volumes
Cost

Pricing & license

Free under its open-source setup, with the only cost being the hardware and time required to run it yourself.

Paid work

Open remote AI-training roles

880 open remote AI-training roles, updated November 16, 2026; most pay $20–$175 an hour. Zekai lists them free; the application goes to the employer’s platform.

See all open roles →
Compare

Alternatives

Get more

Use it, or have us set it up

📄 Free PDF: Chat2DB for Productivity
A plain-language guide to getting your first result. Sent to your inbox.
🔔 64 people want a full video tutorial — add your vote
🛠 Don't want to set it up yourself?
We'll install, host & configure Chat2DB for you — and train your team.
Get it done for you ↗
Questions

FAQ

How does the AI assistant connect to models?

You bring your own AI model configuration to generate, explain, and optimize SQL queries.

Is my data stored securely?

Yes, datasource passwords and AI keys are encrypted with AES-256-GCM using a local per-installation key file.

Can I add custom JDBC databases?

Yes, new JDBC databases can be added through configuration without code changes.

Radar

Latest AI news

✉️ The weekly free toolkit
The best new free & open-source tools for Productivity — one short email a week, in your language.
Free · 1 email/week · unsubscribe anytime
Get paid to train AI →

See Zekai first in Google