skills.rest
reason-machines
reason-machinesOFFICIAL
Explore all skills by this author →
Website𝕏@reasonmachinesGitHub

universal-db-mcp-connector

Connect AI assistants to 17 database types via MCP for natural language queries.

7|2|Updated May 16, 2026
Search Tags:#database#postgresql#MCP#MySQL#natural language query#claude desktop#connector
One-click install
npx skills add https://github.com/reason-machines/mcp-skills --skill universal-db-mcp-connector-reason-machines
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: universal-db-mcp-connector
Source: https://github.com/reason-machines/mcp-skills/tree/main/skills/universal-db-mcp-connector
Command: npx skills add https://github.com/reason-machines/mcp-skills --skill universal-db-mcp-connector-reason-machines

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires universal-db-mcp.

What problem does it solve? Connecting AI assistants like Claude or Cursor to databases normally requires custom integration code for each database type. This Skill configures a universal MCP connector that lets AI tools query MySQL, PostgreSQL, MongoDB, Oracle, and 13 other databases using natural language, without writing boilerplate connection logic. ## Core Features & Use Cases - Multi-Database MCP Server: Supports 17 database types including MySQL, PostgreSQL, MongoDB, Redis, Oracle, SQL Server, SQLite, and Chinese databases like Dameng, KingbaseES, and GaussDB. - Dual Operation Modes: Runs in stdio mode for Claude Desktop and Cursor, or HTTP mode exposing MCP over SSE/Streamable HTTP plus a REST API for Dify and remote access. - Built-in MCP Tools: Provides execute_query, get_schema, get_table_info, get_sample_data, connect_database, and cache management tools, with read-only mode and automatic sensitive data masking. - Use Case: Configure Claude Desktop with a read-only connection to a production MySQL database, then ask questions like "What are the top 10 products by revenue this month?" and Claude automatically inspects the schema, generates SQL, and explains the results. ## Quick Start Set up the universal-db-mcp connector in Claude Desktop to connect to my local MySQL database in read-only mode so I can query it with natural language.

Frequently Asked Questions about universal-db-mcp-connector

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect Claude Desktop to a MySQL database with MCP?▼

Add an entry to claude_desktop_config.json under mcpServers with command "npx" and args including universal-db-mcp, --type mysql, host, port, user, password, and database. Restart Claude Desktop and the database tools become available for natural language queries.

What databases does universal-db-mcp support?▼

It supports 17 database types: MySQL, PostgreSQL, MongoDB, Redis, Oracle, SQL Server, SQLite, Dameng, KingbaseES, GaussDB, OceanBase, TiDB, ClickHouse, PolarDB, Vastbase, HighGo, and GoldenDB. Each uses a type value like mysql, postgres, or dm.

Can I use universal-db-mcp with Dify or remote HTTP access?▼

Yes, run it in HTTP mode by setting MODE=http and HTTP_PORT, which exposes MCP over SSE or Streamable HTTP plus REST endpoints like /api/query and /api/schema. Secure it with API_KEYS and pass database credentials via X-DB-* headers.

How do I prevent write queries when using MCP database access?▼

Pass the --readonly flag when starting the server, which restricts execute_query to SELECT statements only. Combine this with a least-privilege database user granted only SELECT permissions for defense in depth.

Why is Claude Desktop not detecting my MCP database server?▼

Verify the JSON syntax in claude_desktop_config.json, fully restart Claude Desktop, and check the mcp log files under ~/Library/Logs/Claude on macOS. Also test the npx universal-db-mcp command manually in a terminal to confirm it starts.

Does universal-db-mcp mask sensitive data in query results?▼

Yes, enabling --mask-sensitive-data automatically masks phone numbers, emails, ID cards, and bank card numbers in results, for example turning an email into user***@example.com. This is recommended when exposing production data to AI assistants.

Related Skills

Explore More Software Engineering Skills→
Pear-CommercePear-Commerce

intern-app-db-access

Automate MySQL database provisioning and scoped access for intern apps.

Official
Advanced
johwerjohwer

data-analysis-workflows

Analyze business data from dbt models, raw tables, and API feeds into reports and dashboards.

Community
Advanced
pohlai88pohlai88

postgres

Executes read-only SQL queries on configured PostgreSQL databases with schema exploration support.

Community
Intermediate
bomberoxenviosdosruedasbomberoxenviosdosruedas

prisma-driver-adapter-implementation

Implement Prisma ORM v7 driver adapters for custom databases.

Community
Advanced