vikashruhil-mysql-mcp 1.0.0

Secure read-only MySQL MCP server with query impact analysis

vikashruhil-mysql-mcp

Secure read-only MySQL MCP server with query impact analysis.

Features

• list_tables — list all tables in the connected database
• describe_table — show schema for a table (columns, types, keys)
• run_query — execute read-only SELECT/SHOW queries
• explain_query — run EXPLAIN on a SELECT to inspect execution plan
• list_indexes — list indexes for a table
• Write operations blocked — INSERT/UPDATE/DELETE/DROP/etc. are rejected

Usage via uvx (zero install)

DB_HOST=localhost DB_USER=myuser DB_PASS=secret DB_NAME=mydb uvx vikashruhil-mysql-mcp

Environment Variables

Variable	Default	Required
DB_HOST	localhost	No
DB_USER	—	Yes
DB_PASS	—	Yes
DB_NAME	—	Yes
DB_PORT	3306	No

Claude Code Plugin Integration

Install the ai-agent-manager-plugin and set env vars in your shell profile:

export DB_USER=myuser
export DB_PASS=mypassword
export DB_NAME=mydb

The plugin's .mcp.json will auto-run uvx vikashruhil-mysql-mcp on first use.

Publishing

pip install hatch
cd mcps/mysql
hatch build
hatch publish   # prompts for PyPI token