{"id":"simple-mysql-mcp-server","name":"simple-mysql-mcp-server","homepage":"https://pypi.org/project/simple-mysql-mcp-server/","repo_url":null,"category":"databases","subcategories":[],"tags":["mcp","mysql","database","sql","agent-tools","devtools"],"what_it_does":"Provides an MCP server that exposes “simple” MySQL connectivity as agent-callable tools (for querying/updating a MySQL database) with configuration supplied by the host environment.","use_cases":["Let an LLM/agent read from a MySQL database to answer questions","Generate and run SQL for reporting/diagnostics with controlled access","Automate lightweight data retrieval tasks from existing operational databases"],"not_for":["Running arbitrary destructive SQL in a production database without strong safeguards","Handling sensitive regulated data without compensating controls","Multi-tenant or internet-exposed use cases where DB credentials and access need strict isolation"],"best_when":"You have an internal MySQL instance, you can control access/credentials, and you want an agent to perform database reads (and optionally constrained writes) via MCP tools.","avoid_when":"You cannot restrict the agent from issuing harmful SQL (DROP/DELETE/UPDATE), or you lack secure network/credential handling; avoid exposing the MCP server broadly.","alternatives":["Using a REST API layer in front of MySQL with explicit allow-listed endpoints/queries","Database-specific “tooling” frameworks that enforce query allow-lists (e.g., read-only replicas + enforced SQL policies)","Using existing database connectors plus a custom agent tool wrapper with strict validation"],"af_score":39.5,"security_score":33.2,"reliability_score":28.8,"package_type":"mcp_server","discovery_source":["pypi"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T21:44:25.120207+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":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["MySQL credentials (username/password) provided via environment/configuration"],"oauth":false,"scopes":false,"notes":"No OAuth-style auth indicated; security is likely delegated to DB credentials and network access. Fine-grained tool-level authorization/scopes are not evidenced from the provided information."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Open-source package; no pricing info."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":39.5,"security_score":33.2,"reliability_score":28.8,"mcp_server_quality":55.0,"documentation_accuracy":45.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":60.0,"rate_limit_clarity":0.0,"tls_enforcement":40.0,"auth_strength":35.0,"scope_granularity":10.0,"dependency_hygiene":50.0,"secret_handling":35.0,"security_notes":"Security depends heavily on how the MCP server is deployed: DB creds must be protected, ideally with read-only accounts; tool-level authorization/SQL allow-lists and parameterization are critical to prevent destructive or exfiltrating queries. TLS enforcement and secret handling cannot be confirmed from the provided information.","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":40.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":"Write operations (if supported) are typically not idempotent; no evidence of idempotency design.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Agents may attempt to run unsafe/non-parameterized SQL; enforce allow-lists and read-only credentials where possible.","Agents may hallucinate schema/columns; require schema introspection or provide schema context.","If the MCP server does not clearly surface SQL errors, agents may repeatedly retry failing queries without improvement."]}}