{"id":"cdatasoftware-mysql-mcp-server-by-cdata","name":"mysql-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/mysql-mcp-server-by-cdata","category":"devtools","subcategories":[],"tags":["mcp","mysql","jdbc","stdio","data-access","read-only","llm-integration"],"what_it_does":"Provides a local MCP (Model Context Protocol) server that exposes MySQL data via tools for listing tables/columns and running SQL SELECT queries (read-only MCP). It wraps CData JDBC Driver for MySQL and is intended for use with MCP-capable desktop clients (e.g., Claude Desktop) over stdio.","use_cases":["Let an LLM query live MySQL data without writing SQL (e.g., answering questions about operational metrics).","Data exploration: list available tables and columns and then retrieve subsets via SELECT queries.","Integrate local MySQL read access into an MCP-enabled desktop workflow."],"not_for":["Production deployment as a network-accessible API service (stdio-only, local use).","Full CRUD operations via MCP tools (the README describes this as read-only).","Handling sensitive data in untrusted environments without controls (the tool can run arbitrary SELECT SQL)."],"best_when":"You want to query a local MySQL instance (or reachable MySQL) from an MCP-enabled desktop client with minimal setup and only read access.","avoid_when":"You need remote/networked MCP access, strict query safety/whitelisting, or robust operational controls like rate limits, retries, and structured error contracts.","alternatives":["CData’s managed MCP platform (CData Connect AI) for more complete read/write/update/delete capabilities.","Direct database connections using an agent tool that supports parameterized queries and strict SQL safety controls.","Building a custom MCP server specifically for your MySQL schema with vetted, parameterized operations."],"af_score":48.2,"security_score":48.5,"reliability_score":22.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:59:53.805783+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":["CData JDBC Driver authentication as configured in the JDBC connection string (and possibly browser OAuth for OAuth-backed sources per JDBC driver behavior)."],"oauth":false,"scopes":false,"notes":"The MCP server itself is launched locally with a .prp file that references the JDBC driver and JDBC URL. The README mentions that if the data source uses OAuth you may need to authenticate in a browser, but it does not describe OAuth flows or scopes at the MCP server layer."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"The README indicates licensing for the CData JDBC Driver. No explicit pricing tiers for the MCP server are provided."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":48.2,"security_score":48.5,"reliability_score":22.5,"mcp_server_quality":55.0,"documentation_accuracy":65.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":10.0,"tls_enforcement":70.0,"auth_strength":55.0,"scope_granularity":20.0,"dependency_hygiene":45.0,"secret_handling":50.0,"security_notes":"Security is largely delegated to the CData JDBC Driver configuration (credentials in the JDBC URL/connection properties via the .prp). The README does not describe TLS requirements, secret redaction/logging, query allowlisting, or any authentication at the MCP tool layer. Because a SQL SELECT execution tool is exposed, agents should be constrained to safe/limited queries to reduce data exfiltration risk.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"Read-only tools are inherently safer for idempotency, but the interface includes an SQL execution tool (SELECT). The README does not describe idempotency semantics or guarantees.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio, so it must run on the same machine as the MCP client.","If a JDBC URL (or underlying CData driver) requires OAuth/browser auth, the setup may require interactive authentication steps before the server can function.","The run_query tool accepts raw SQL SELECT; an agent may generate inefficient or overly broad queries if not constrained."]}}