{"id":"askdba-mysql-mcp-server","name":"mysql-mcp-server","homepage":null,"repo_url":"https://github.com/askdba/mysql-mcp-server","category":"infrastructure","subcategories":[],"tags":["database","mysql","mariadb","mcp","agent-tools","introspection","read-only","vector-search","go","security"],"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.","use_cases":["Schema exploration and documentation (list databases/tables, describe tables)","Read-only debugging assistance for MySQL/MariaDB","Building internal tooling for safe analytics over operational databases","Vector similarity search on MySQL 9.0+ vector columns","Connection/pool health and server info retrieval (ping, server_info, connections)"],"not_for":["Modifying data (INSERT/UPDATE/DELETE/DDL)","Running unbounded or expensive queries without limits","Public internet exposure without network controls/auth at the HTTP layer","Handling production workloads without careful DSN privilege and resource sizing"],"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.","alternatives":["Direct database access with read-only credentials (agent-side SQL)","Dedicated BI/metadata services (read-only SQL gateways)","Other MCP DB tools or schema/introspection APIs","SQL proxy solutions that enforce read-only and query limits"],"af_score":66.5,"security_score":56.2,"reliability_score":33.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"high","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-03-30T15:34:18.348618+00:00","interface":{"has_rest_api":true,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["MySQL DB credentials via DSN (username/password in connection string or config)"],"oauth":false,"scopes":false,"notes":"No separate app-layer auth is documented for MCP stdio. For optional HTTP mode, auth/authN is not described in the provided README content; HTTP exposure should be treated as needing external network protection."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Self-hosted open-source style package; no pricing info in provided content."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":66.5,"security_score":56.2,"reliability_score":33.8,"mcp_server_quality":85.0,"documentation_accuracy":80.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":70.0,"tls_enforcement":80.0,"auth_strength":55.0,"scope_granularity":35.0,"dependency_hygiene":50.0,"secret_handling":60.0,"security_notes":"Strengths: supports TLS for MySQL connections (including skip-verify/preferred mapping), encourages read-only usage, provides query timeouts and max row caps, and mentions audit logs. Concerns/unknowns: no explicit app-layer authentication/authorization for the optional HTTP/REST mode is described in the provided README; HTTP exposure therefore should be protected via network controls. Scope granularity is limited to tool-level read-only enforcement rather than cryptographically scoped permissions. Secrets appear to be supplied via DSN/env vars; the README does not explicitly state whether secrets are redacted from logs (structured logging exists, but redaction is not documented).","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":40.0,"error_recovery":50.0,"idempotency_support":"false","idempotency_notes":"Most read-only tools are effectively non-mutating; however, the README does not explicitly describe idempotency semantics for tool invocations.","pagination_style":"none","retry_guidance_documented":false,"known_agent_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."]}}