{"id":"askdba-mysql-mcp-server","name":"mysql-mcp-server","af_score":66.5,"security_score":56.2,"reliability_score":33.8,"what_it_does":"Provides an MCP server (and optional HTTP/REST mode) that connects to one or more MySQL/MariaDB instances and exposes read-only database introspection tools and controlled, row-limited SQL querying plus optional vector search. Intended for agent clients like Claude Desktop/Cursor to safely explore schemas and run safe read-only queries.","best_when":"You can run the server locally or inside a controlled network with a least-privilege DB user and you need agent-friendly read-only MySQL introspection via MCP (optionally with row caps and timeouts).","avoid_when":"You cannot restrict network access to the MCP/HTTP endpoints or you must guarantee strict safety beyond read-only SQL filtering and row limits.","last_evaluated":"2026-03-30T15:34:18.348618+00:00","has_mcp":true,"has_api":true,"auth_methods":["MySQL DB credentials via DSN (username/password in connection string or config)"],"has_free_tier":false,"known_gotchas":["Safety relies on SQL type restrictions (SELECT/SHOW/DESCRIBE/EXPLAIN) and row limits; agents may still craft expensive SELECTs unless timeouts/row caps are configured.","HTTP mode is optional and may be mutually exclusive with stdio MCP; ensure correct env vars (MYSQL_MCP_HTTP vs stdio) to avoid unexpected interface behavior.","Token dashboard availability depends on token tracking and the metrics HTTP sidecar settings (especially for stdio mode).","Multi-DSN tool behavior depends on correct configuration of MYSQL_DSN_N and *_NAME/ *_DESC fields."],"error_quality":0.0}