{"id":"youngsu5582-mcp-server-mysql","name":"mcp-server-mysql","homepage":null,"repo_url":"https://github.com/youngsu5582/mcp-server-mysql","category":"infrastructure","subcategories":[],"tags":["mcp","mysql","database","ai-agents","backend","java","data-access"],"what_it_does":"An MCP (Model Context Protocol) server that connects to a MySQL database and exposes operations to list tables, read table contents, and execute SQL queries via a structured, agent-facing interface, using MySQL credentials supplied via environment variables.","use_cases":["Letting AI assistants explore a MySQL schema (list tables, inspect data)","Building data analysis workflows where an agent needs controlled database access","Prototyping MCP-based database tools in a Java environment"],"not_for":["Production environments without least-privilege DB users and query restrictions","Use cases requiring strong authorization (per-user/per-role) at the MCP layer","Untrusted agent workloads where SQL execution cannot be constrained"],"best_when":"You have a dedicated low-privilege MySQL user and a local/controlled environment where an MCP client will interact with the database safely.","avoid_when":"You cannot restrict database permissions or need robust protections against overly broad SQL execution (e.g., destructive queries) or data exfiltration attempts.","alternatives":["Other MCP database servers for PostgreSQL/MySQL if available with stronger query whitelisting","Database access through a purpose-built API (REST/GraphQL) with strict server-side authorization","Direct read-only database connectors (e.g., read replicas) paired with an LLM tool that enforces query templates"],"af_score":37.2,"security_score":41.2,"reliability_score":23.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:45:10.365799+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":["Java"],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["MySQL credentials via environment variables (MYSQL_USER/MYSQL_PASSWORD)"],"oauth":false,"scopes":false,"notes":"Authentication is delegated to MySQL via a configured database user; the MCP layer authentication/authorization mechanisms are not described in the provided README."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No pricing information in provided content."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":37.2,"security_score":41.2,"reliability_score":23.8,"mcp_server_quality":58.0,"documentation_accuracy":45.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":30.0,"rate_limit_clarity":0.0,"tls_enforcement":35.0,"auth_strength":45.0,"scope_granularity":15.0,"dependency_hygiene":40.0,"secret_handling":70.0,"security_notes":"Security guidance is included at a high level (least-privilege DB user, avoid root, monitor/log operations, consider query whitelisting). However, the README does not document MCP-layer authorization, SQL query allow/deny rules, or whether database connections use TLS. Secrets are expected via environment variables, but detailed handling (e.g., logging/obfuscation) is not verified from the provided content.","uptime_documented":0.0,"version_stability":30.0,"breaking_changes_history":20.0,"error_recovery":45.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["SQL execution can be risky without query whitelisting and a constrained DB user","The README references an installation command for Python tooling (pip) that may not match this Java repo, which could confuse operators/agents setting up the server"]}}