- Home
- Skills
- Data & Databases
- MySQL/PostgreSQL MCP Server
Works with the AI Agents you already use
MySQL/PostgreSQL MCP Server
Connect agents to MySQL/MariaDB or PostgreSQL via MCP for safe schema discovery, paginated queries, catalog inspection, and guarded writes.
Free
MySQL/PostgreSQL MCP Server
Example session with this skill installed
Show me the tables in the 'inventory' database and describe the 'products' table.
- Read your context and instructions
- Compiled the mysql postgresql mcp
I have retrieved the schema information for the requested database.
MySQL summary
- Database: inventory
- Mode: read-only
- What ran:
mysql_queryto show tables and describe products
Findings
The inventory database contains four tables. The products table stores core item data including pricing and stock levels, using an auto-incrementing integer as the primary key.
Data sample
| Table Name | Type |
|---|---|
| categories | BASE TABLE |
| products | BASE TABLE |
| stock_levels | BASE TABLE |
| suppliers | BASE TABLE |
Structure of products:
| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL |
| sku | varchar(50) | NO | UNI | NULL |
| name | varchar(255) | NO | NULL | |
| price | decimal(10,2) | NO | 0.00 | |
| status | enum('active','deleted') | YES | 'active' |
Next steps
- Run a
SELECTquery onproductswith alimitto see sample data. - Use
mysql_catalogif you need to see triggers associated with theproductstable. - Verify if
MYSQL_PII_COLUMNSis configured if you plan to query customer-linked data.
Connects securely to your tools. The creator never sees your data.
About this skill
Interacting with MySQL, MariaDB, or PostgreSQL from an LLM chat often means risky shell commands or exposed credentials. This skill gives agents a structured workflow for @eduartedev/mysql-mcp-server: configure MCP once, discover schema first, then run paginated queries with strict security defaults.
What it does
- Multi-engine MCP — one binary for MySQL/MariaDB (
mysql_query/mysql_catalog) or PostgreSQL (postgres_query/postgres_catalog), selected withDB_ENGINEor port autodetect. - Schema discovery — map tables/columns (
SHOW/DESCRIBEor Postgres equivalents) before writing complex SQL. - Safe querying — read-only by default, with result caps to protect the context window.
- Automated pagination — follow
hasMore/nextOffsetacross pages (limitdefault 20, max 100). - Logic inspection — read views, triggers, functions, and procedures via catalog tools.
- Write guardrails —
INSERT/UPDATE/DELETEonly whenDB_ACCESS_MODE=readwrite, with mandatory realWHEREchecks and allowlists (:ro/:rw). - PII masking & TLS — sensitive columns returned as
***; optionalDB_SSL=requiredfor RDS and other TLS setups.
How it works
- Configure MCP — add the stdio server (
npx -y @eduartedev/mysql-mcp-server) withDB_*env (host, credentials, allowlist, optional SSL). - Discover scope — list tables/schemas and describe columns before querying.
- Execute and paginate — run validated SQL and continue with
nextOffsetwhilehasMoreis true.
Frameworks & tools
Built for @eduartedev/mysql-mcp-server on Node.js 18+. Works with MCP stdio clients such as Cursor, Claude Code, and Codex CLI.
Why this beats prompting it yourself
Generic prompts push agents toward mysql/psql shells or invented schemas. This skill enforces discovery-then-query, PII masking, blocked DDL/admin commands, and controlled writes.
Use cases
- Debug row-level issues with a least-privilege, readonly DB user.
- Audit database logic by reading trigger/function/procedure definitions.
- Run safe, paginated exports for local analysis or reporting.
- Query MySQL locally or PostgreSQL on RDS with TLS + CA bundle.
Known limitations
Requires Node.js 18+ and an MCP client with stdio. No multi-statement queries, no DDL (DROP/ALTER/CREATE/…), no LOAD DATA / admin paths like GRANT. Writes stay off until you set DB_ACCESS_MODE=readwrite and restart MCP.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.
Requires Node.js 18+ and an MCP client with stdio support. No support for multi-statement queries, DDL operations, or administrative commands like GRANT.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 5 days ago
- Free with an Agensi account
- Software
- @eduartedev/mysql-mcp-server
Node.jsEnabled MCPConfig MCP