{"id":"jamessmith888-mcp-db-server","name":"mcp-db-server","homepage":null,"repo_url":"https://github.com/JamesSmith888/mcp-db-server","category":"ai-ml","subcategories":[],"tags":["mcp-server","database","sql","sse","spring-ai","groovy","jdbc","agent-tools"],"what_it_does":"An MCP server (Spring AI based) that exposes database access to an AI agent, intended to execute SQL queries against one or more configured data sources, with support for SSE transport and additional SQL safety controls and Groovy-based extensions.","use_cases":["Agent-assisted querying of relational databases","Building internal analytics workflows where an LLM can run controlled SQL","Rapid prototyping of agent-to-database tools across multiple DB engines"],"not_for":["Untrusted public exposure without strong network/auth controls","Running arbitrary destructive SQL in production without strict safety policies","Use as a general-purpose “SQL execution for anyone” service"],"best_when":"Teams need an agent to query databases via MCP using SSE, with clearly configured data sources and SQL safety rules.","avoid_when":"When you cannot restrict accounts/permissions, or you lack the ability to validate/monitor the generated SQL and results.","alternatives":["Dedicated database query gateways with explicit allowlists","Vendor-specific BI/query APIs (e.g., Read-only SQL endpoints)","Other MCP DB servers (e.g., MySQL-focused)","Custom middleware that uses parameterized queries and strict schemas"],"af_score":30.8,"security_score":26.0,"reliability_score":20.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:50:23.787306+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":"http://localhost:6789/sse","has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":[],"oauth":false,"scopes":false,"notes":"No authentication/authorization mechanism is described in the provided README (only a local SSE URL example and JDBC datasource credentials)."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":null},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":30.8,"security_score":26.0,"reliability_score":20.0,"mcp_server_quality":55.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":20.0,"dependency_hygiene":50.0,"secret_handling":30.0,"security_notes":"README indicates SQL safety controls and a desire to prevent dangerous SQL, plus configurable datasources with usernames/passwords. However, no authentication for the MCP endpoint is documented, no TLS requirement is stated, and no details are provided about scope/authorization model. Database credentials should be treated as sensitive; the README shows password in config as a value, but does not describe secret management best practices.","uptime_documented":0.0,"version_stability":30.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Executing SQL generated by an LLM can cause unintended side effects; ensure SQL safety configuration and least-privilege DB users.","SSE transport may require client-specific configuration (README notes some clients need manual SSE selection).","Multiple database/data source routing requires correct datasource.yml configuration."]}}