{"id":"cdatasoftware-ibm-db2-mcp-server-by-cdata","name":"ibm-db2-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/ibm-db2-mcp-server-by-cdata","category":"ai-ml","subcategories":[],"tags":["mcp","ibm-db2","cdata","jdbc","stdio","read-only","data-access"],"what_it_does":"Provides a read-only MCP (Model Context Protocol) server that exposes IBM DB2 data to local AI clients via CData JDBC Driver. It runs as a stdio-based MCP server and offers tools to list tables/columns and execute SQL SELECT queries against DB2 without requiring end users to write SQL.","use_cases":["Letting an LLM query live DB2 data (read-only) from tools like Claude Desktop","Exploring available schemas (tables/columns) and answering analytics questions over DB2 data","Ad-hoc reporting via natural-language questions translated into SQL SELECT queries"],"not_for":["Write/update/delete operations (explicitly described as read-only)","Remote/shared multi-tenant deployment where stdio requires network exposure alternatives","Production workloads needing strong API-level governance (this is a thin wrapper around JDBC and SQL)"],"best_when":"You want a local, read-only MCP integration that can query DB2 through CData JDBC with minimal setup in a desktop client workflow.","avoid_when":"You need fine-grained query/row-level security controls, pagination/limits, or you require robust server-to-server (network) access patterns instead of local stdio.","alternatives":["CData's full (non-read-only) MCP server for IBM DB2 (if write capabilities are needed)","Direct JDBC access from your application with an internal LLM-to-SQL layer","A custom MCP server wrapping a DB2 client library with enforced query constraints and pagination"],"af_score":52.5,"security_score":38.5,"reliability_score":28.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:58:17.820531+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":["DB2 connectivity via CData JDBC (credentials/connection string in .prp; may include OAuth depending on JDBC configuration)"],"oauth":false,"scopes":false,"notes":"The README indicates that OAuth may be required for certain underlying data sources via the JDBC driver, but it does not describe MCP-level OAuth/scopes; authentication is delegated to the JDBC connection configured in the .prp and JDBC driver."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"CData JDBC driver licensing is required (README instructs to run the driver jar with --license). No MCP server pricing/tiers are described."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":52.5,"security_score":38.5,"reliability_score":28.8,"mcp_server_quality":75.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":5.0,"tls_enforcement":40.0,"auth_strength":55.0,"scope_granularity":10.0,"dependency_hygiene":45.0,"secret_handling":40.0,"security_notes":"Authentication is handled via CData JDBC driver configuration (.prp / connection string) rather than MCP-level auth; the MCP wrapper does not describe fine-grained scopes or row-level security controls. stdio-based local execution reduces exposure over a network but can still run with high privilege to the underlying DB. README does not document secret handling practices (e.g., whether logs could include connection strings). No explicit query constraints beyond read-only are described.","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":50.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio, so it generally only works with clients on the same machine unless you create an alternative local proxy/execution model.","No explicit pagination/row limits are documented; large queries may be slow or fail depending on DB2/CData behavior.","Read-only only; agents should not attempt mutations even if they attempt generic data-access patterns.","SQL execution tool expects valid SQL SELECT statements; agents may need schema discovery first using get_tables/get_columns."]}}