# universal-db-mcp-connector

The universal-db-mcp-connector skill stands up an MCP server against your database, so the assistant writes and runs queries itself. It covers 17 database types, among them MySQL, PostgreSQL and MongoDB.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 203 installs · ★ 9 repo stars
- Author: reason-machines
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/mcp-skills/tree/HEAD/skills/universal-db-mcp-connector/SKILL.md
- Updated: 2026-10-09
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/universal-db-mcp-connector

## What it does

The skill installs the `universal-db-mcp` server and shows where to register it with your assistant. Once it is wired up you ask in plain language, and the assistant fetches the schema and runs the query. Types on the list include MySQL, PostgreSQL, MongoDB, Redis, Oracle, SQL Server, SQLite, ClickHouse and TiDB, plus Dameng, KingbaseES and GaussDB.

Two modes are covered. Under stdio the server is an MCP process declared through `command` and `args` in `claude_desktop_config.json` or `.cursor/config.json`. Under http it runs as a service with SSE and Streamable HTTP and exposes REST routes `/api/health`, `/api/connect` and `/api/query` for remote clients and Dify.

Passwords in the examples come from the environment (`${DB_PASSWORD}`) instead of sitting in the config file. `--type` is the only argument marked required; flags such as `--port`, `--pool-size` and `--cache-ttl` carry defaults. The sample configs also switch on `--readonly`, which keeps the assistant from writing to your tables.

## Requirements
- Works with: PostgreSQL, MongoDB

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill universal-db-mcp-connector -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/universal-db-mcp-connector/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/universal-db-mcp-connector/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill universal-db-mcp-connector -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/universal-db-mcp-connector/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill universal-db-mcp-connector -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/universal-db-mcp-connector/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/mcp-skills skills/universal-db-mcp-connector
```

2. **Manually: put the files in place**
- File: `.github/skills/universal-db-mcp-connector/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill universal-db-mcp-connector -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/mcp-skills --path skills/universal-db-mcp-connector
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/universal-db-mcp-connector/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill universal-db-mcp-connector -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/mcp-skills/tree/HEAD/skills/universal-db-mcp-connector/SKILL.md

## When to use it
- Point Claude Desktop at the production MySQL instance and ask what is slow
- Count last week's orders in PostgreSQL without writing SQL by hand
- Hand a local SQLite file to the assistant inside Cursor
- Run the HTTP mode behind an API key for a remote client
- Turn on `--readonly` so the assistant cannot change rows

## Example prompts
- Wire up my local `myapp` MySQL database to Claude Desktop over MCP, read-only.
- Start the connector in HTTP mode on port 3000 using the keys in `API_KEYS`.
- Write a Cursor config for PostgreSQL at `analytics.example.com`, schema `public`, schema cache 600 seconds.

## Similar
- [whodb](https://affpapa.org/en/nevibecode/plugins/whodb.md) — plugin · ★ 5065 repo stars
- [valv](https://affpapa.org/en/nevibecode/mcp/valv.md) — MCP server · ★ 5 repo stars
- [database-attacker](https://affpapa.org/en/nevibecode/agents/database-attacker.md) — subagent · ★ 2482 repo stars
- [Rowsafe](https://affpapa.org/en/nevibecode/mcp/rowsafe.md) — MCP server · ★ 3 repo stars
- [database-administrator](https://affpapa.org/en/nevibecode/agents/database-administrator.md) — subagent · 452 installs
- [mirrord-db-branching](https://affpapa.org/en/nevibecode/skills/mirrord-db-branching.md) — skill · ★ 31 repo stars

From the same set: [reason-machines/mcp-skills](https://affpapa.org/en/nevibecode/by/reason-machines/mcp-skills.md) — 98 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
