mcp-server

Chat2DB

Chat2DB is a free, cross-platform, local-first database client and SQL workspace for developers, DBAs, analysts, and data teams. Connect to 40+ databases
28,310 stars+5★ this week3,042 forksJavaUpdated 10/9/2026100% free · open source
What it does

Chat2DB gives you a visual SQL editor and AI‑assistant that can generate, explain, and optimise queries for any of 40+ databases, all running locally on your machine or in Docker.

When to use it
  • •You need a quick UI to explore a new database without writing SQL by hand.
  • •Your team wants AI‑generated queries or explanations directly in the query editor.
  • •You prefer a self‑hosted, free tool that works on Windows, macOS, Linux, or via Docker.
Ready-to-paste prompt
Generate a SQL query that returns order_id, customer_name, and total_amount for all orders placed in the last 7 days, sorted by total_amount descending.
Heads up: AI features require an LLM key; set the environment variable `CHAT2DB_OPENAI_KEY` (or configure another model) before using the assistant, otherwise the AI tab will stay disabled.
Saves to your device
Use with Claude
New

Skip the builder — one click puts this in Claude, Cursor, Antigravity and more.

✅ Light setup

Installs with a command or two; your AI agent can do it for you.

Try it instantly — no install
Claude Code
mkdir -p ~/.claude/skills/2ee35816-ac85-4206-869b-3a9f25e51b4a && curl -fsSL https://workflowstacks.com/api/skills/2ee35816-ac85-4206-869b-3a9f25e51b4a/claude-skill -o ~/.claude/skills/2ee35816-ac85-4206-869b-3a9f25e51b4a/SKILL.md
Open in another AI app

Opens the app with this repo with the prompt ready to go — no copy-paste needed.

Connect the whole catalog (MCP)
claude mcp add --transport http workflowstacks https://workflowstacks.com/api/mcp

Adds a WorkflowStacks connector to Claude Code: search and load any skill here by chatting.

How Chat2DB works
Codeflow
Free to inspect

Chat2DB is a very large Java project (~343k lines across 3402 code files, plus 394 test files). Setup is light: installs like a normal app. Reading the code is optional. Last commit this month, Other license, has a test suite.

Size
Very large codebase
~343k lines · 3402 code files · days to read — use, don't read
Setup
One-command install
Installs like a normal app. Reading the code is optional.
Runs on
Docker
No API keys detected
Java 57%TypeScript 30%ANTLR 7%TSQL 3%Shell 1%
Where to start reading
  1. 1
    README.md
    Start here — what it does and how to install it
  2. 2
    AGENTS.md
    The instructions the AI actually follows
What's in each folder
docs/Documentation3 files
script/Helper scripts78 files
jpackage/Folder6 files
docker/Deployment / infrastructure4 files
.github/CI / automation (GitHub Actions)32 files
spec/Tests — proof it works6 files
READMEHas testsDocumentedCI checksDocker readyOther licenseUpdated this month
Quick Actions
Details
Creator
OtterMind
Language
Java
Category
mcp-server
Published
6/20/2023

Are you the creator of this tool? and earn 85% of every sale.

Show it off in your README:

Featured on WorkflowStacks
[![Featured on WorkflowStacks](https://workflowstacks.com/api/badge/2ee35816-ac85-4206-869b-3a9f25e51b4a.svg)](https://workflowstacks.com/skills/2ee35816-ac85-4206-869b-3a9f25e51b4a?utm_source=github&utm_medium=badge)
🔥 Hot this week, in your inbox
Skills like this, every Monday.

The five fastest-growing open-source AI skills, ranked by GitHub star growth. One email a week, unsubscribe anytime.

Do this with a working workflow

Pages we wrote and tested that put a skill like this to work — importable n8n templates, outcome guides and Claude Desktop configs.

Related skills

More mcp-server tools founders pair with this one.