{"id":"gokeep-projects-mysql-mcp-server","name":"mysql-mcp-server","homepage":null,"repo_url":"https://github.com/gokeep-projects/mysql-mcp-server","category":"ai-ml","subcategories":[],"tags":["mcp","mysql","quarkus","ai-agents","database-tools","sse","http"],"what_it_does":"Provides an MCP (Model Context Protocol) server that exposes MySQL metadata and query capabilities to AI assistants. Built with Quarkus and supports MCP connectivity via SSE (/mcp/sse) and a streamable HTTP endpoint (/mcp) over an HTTP listener.","use_cases":["Allowing AI agents to inspect MySQL databases (databases/tables/schema)","Executing read-only or ad-hoc SQL queries via MCP tools for analysis/debugging","Integrating MySQL-backed data exploration into MCP-capable clients (e.g., MCP tools in IDEs/assistants)"],"not_for":["Production deployments that require strong authentication/authorization guarantees without additional front-end controls","Workloads requiring strict SQL safety controls (e.g., prevention of destructive queries) unless explicitly documented and enforced","Use cases needing formal enterprise SLAs, audit logging, or compliance certifications (not evidenced in provided docs)"],"best_when":"You control the network environment (e.g., internal Kubernetes cluster/VPC) and want a lightweight MCP-to-MySQL bridge with SSE/HTTP connectivity.","avoid_when":"You cannot restrict access to the MCP endpoints and database credentials; or you need clearly documented protections against unsafe SQL execution.","alternatives":["Dedicated SQL tools behind an authenticated API gateway","General MCP server frameworks with custom MySQL connectors","Database-aware agent tools (vendor/OSS) that provide safer query execution policies"],"af_score":35.2,"security_score":25.2,"reliability_score":22.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T20:02:33.289523+00:00","interface":{"has_rest_api":true,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":"http://{ip}:29000/mcp (streamable) and http://{ip}:29000/mcp/sse (SSE)","has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["None documented","MySQL credentials supplied to server via environment variables or JVM system properties"],"oauth":false,"scopes":false,"notes":"No MCP/API authentication mechanism (API keys, OAuth, basic auth, IP allowlisting) is documented. The docs only describe MySQL connection credentials for the server to reach the database."},"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 project; no pricing information in provided materials."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":35.2,"security_score":25.2,"reliability_score":22.5,"mcp_server_quality":75.0,"documentation_accuracy":55.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":20.0,"rate_limit_clarity":0.0,"tls_enforcement":30.0,"auth_strength":10.0,"scope_granularity":0.0,"dependency_hygiene":45.0,"secret_handling":50.0,"security_notes":"Security posture is unclear for the MCP endpoints: no auth/authorization is documented, so access control likely depends on network placement (e.g., private network, firewall, ingress rules). Server credentials are accepted via env vars/system properties (better than hardcoding, but still requires safe handling to avoid leaking via logs/process args). TLS enforcement for the HTTP listener is not documented.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"Not documented; MCP tools that execute SQL may be non-idempotent depending on query type.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["No authentication for MCP endpoints is documented; agents may be able to reach the server from any network path unless access is externally restricted.","SQL execution tool behavior/safety (read-only enforcement, disallowed statements) is not documented.","Idempotency/retry guidance is not documented; retries could repeat SQL execution if not read-only."]}}