Secure read-only MySQL MCP server with query impact analysis
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"vikashruhil-mysql-mcp","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# MySQL Read-Only MCP Server A secure, feature-rich Model Context Protocol (MCP) server providing safe read-only access to MySQL databases with **query impact analysis** and **multi-database support**. ## Overview This MCP server enables Claude (via Claude Desktop or Claude Code) to safely query MySQL databases while protecting against performance issues through intelligent query analysis. It supports: - **Read-only SELECT queries** with automatic validation and sanitization - **Query impact analysis** using EXPLAIN to detect slow queries before execution - **Multi-database support** with dynamic database switching via profiles - **Schema introspection** (list tables, describe structures) - **Database statistics** (size, row counts, table metrics) - **Smart caching** for improved performance ### Key Features ✅ **Security First** - Read-only enforcement (no INSERT, UPDATE, DELETE, ALTER) - Dangerous keyword blocking - SQL injection prevention via identifier sanitization - Parameterized queries ✅ **Performance Protection** - EXPLAIN-based query analysis before execution - Detection of full table scans and slow queries - Optimization suggestions - HIGH-risk query blocking ✅ **Multi-Database Support** - Switch between different MySQL databases and instances - Environment-variable based profile configuration - Connection validation before switching - Automatic schema cache clearing ✅ **Developer Friendly** - Natural language query descriptions - Detailed analysis reports with metrics - Table structure introspection - Database size and statistics ## Quick Start ### Prerequisites - Docker installed and running - MySQL server with database access - Claude Desktop or Claude Code installed ### For Claude Desktop **Fastest Way:** 1. **Build the Docker image** (one time): ```bash cd /Users/vikashruhil/Documents/work/Tray/mcps/mysql chmod +x build.sh run.sh ./build.sh ``` 2. **Set database secrets:** ```bash # Interactive setup ./setup-se…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.