{"id":"koh-yoshimoto-mysql-mcp-server","name":"mysql-mcp-server","af_score":59.2,"security_score":53.2,"reliability_score":26.2,"what_it_does":"Provides an MCP (Model Context Protocol) server for connecting to a MySQL database and exposing tools for SELECT-only querying, schema inspection (tables and columns), and execution-plan analysis via EXPLAIN/EXPLAIN ANALYZE. Also provides an execute tool for data-modifying statements (INSERT/UPDATE/DELETE) with a dry-run + confirmation token flow.","best_when":"You want an agent-friendly way to introspect and query a MySQL database locally/in your environment using MCP, and you can provide appropriately privileged (preferably read-only) credentials.","avoid_when":"You need robust access control beyond database-user permissions, or you cannot enforce the two-step confirmation process for write operations.","last_evaluated":"2026-04-04T19:51:43.889452+00:00","has_mcp":true,"has_api":false,"auth_methods":["Environment-variable based database credentials (MYSQL_HOST/PORT/USER/PASSWORD/DATABASE) used by the MCP server"],"has_free_tier":false,"known_gotchas":["The execute tool supports only INSERT/UPDATE/DELETE and uses dry_run + confirm_token; agents must follow the two-step pattern to avoid failed writes.","EXPLAIN ANALYZE may execute the query to gather real statistics; can be risky for long-running or heavy queries.","Query tool is restricted to SELECT statements only; agents may need to route data-modifying intent to the execute tool."],"error_quality":0.0}