workflowstacks
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

From the repo · “Chat2DB is a free, cross-platform, local-first database client and SQL workspace for developers, DBAs, analysts, and data teams. Connect to 40+ databases, manage data, edit and run SQL, and use your own AI model to generate, explain, and optimize queries. Available on desktop, web, Docker, and CLI, with MCP support.”

28,331 stars+8★ this week3,048 forksJavaUpdated 10/20/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/chat2db && curl -fsSL https://workflowstacks.com/api/skills/chat2db/claude-skill -o ~/.claude/skills/chat2db/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
chat2db-community-server/Folder2513 files
chat2db-community-client/Folder1511 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/chat2db.svg)](https://workflowstacks.com/skills/chat2db?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.

MCP config

PostgreSQL MCP config

Let Claude run read-only queries against your Postgres database.

Related skills

More mcp-server tools founders pair with this one.

mcp-server★ 376,837
Rea: Reverse Engineer Apps
Inspect apps down to binary level with Rea. For founders needing code clarity.
mcp-server★ 288,000
ECC supercharges AI‑agent performance for founders building Claude, Codex, and Cursor
Founders gain optimized skills, memory, security, and research‑first development for Claude Code, Codex, Opencode, Cursor, backed by 280k+ GitHub stars.
mcp-server★ 156,636
open-webui: Self‑hosted AI Chat UI for Faster LLM Integration
Launch a sleek, web‑based AI interface that works with Ollama, OpenAI API, and more—ideal for founders needing a quick, customizable LLM front‑end. 153k+ GitHub stars.
mcp-server★ 406
clawdcursor: Transform Screen UI into Stable, Scriptable Elements
For founders building automation, clawdcursor merges accessibility data and OCR into a single UI map, letting you run reusable scripts with verified actions and a safety gate.
mcp-server★ 5,214
ha-mcp: Boost Home Assistant Automation with a Proven MCP Server
ha-mcp delivers a robust, community‑backed MCP server for Home Assistant, letting founders streamline device communication and AI integration. 5.1k+ GitHub stars.
mcp-server★ 219
node9-proxy – Secure deterministic governance for autonomous AI agents
Add a hardened execution layer that enforces sudo‑style controls and records audit logs for AI‑driven agents. Ideal for founders building safe LLM‑powered services.