{"id":"cdatasoftware-apache-cassandra-mcp-server-by-cdata","name":"apache-cassandra-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/apache-cassandra-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","cassandra","jdbc","data-access","claude-desktop","read-only","stdio"],"what_it_does":"Provides a local, read-only MCP server that wraps the CData JDBC Driver for Apache Cassandra and exposes tools to list tables/columns and run SQL SELECT queries over Cassandra data via Claude Desktop (stdio transport on the same machine).","use_cases":["Natural-language querying of Cassandra data from an MCP-capable client (e.g., Claude Desktop)","Exploratory analysis: list available tables and columns, then run read-only queries","Building agent workflows that need low-friction access to Cassandra data without writing SQL"],"not_for":["Untrusted remote access over the network (stdio requires local co-location)","Write operations (the project explicitly describes itself as read-only)","Environments needing strong operational controls like query cost limits, row-level security enforcement, or standardized pagination"],"best_when":"You want an on-device MCP integration for read-only Cassandra analytics/exploration, and you already manage Cassandra credentials/driver licensing on the same host.","avoid_when":"You require robust security boundaries, auditing, and safety controls around query execution; or you need write/update/delete or remote multi-tenant access.","alternatives":["Other Cassandra data access methods (direct Cassandra drivers, REST APIs, or BI connectors)","A managed MCP platform from the same vendor (e.g., CData Connect AI) for remote access","A generic SQL MCP server/proxy (if available) that can connect to Cassandra via JDBC with similar tooling"],"af_score":54.0,"security_score":33.2,"reliability_score":23.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:33.137116+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 licensing required (separate step)","Database connection authentication via JDBC connection string embedded in a .prp file (may include OAuth depending on Cassandra connector configuration)"],"oauth":false,"scopes":false,"notes":"Authentication details for Cassandra are delegated to the CData JDBC Driver; the MCP server itself uses a local stdio process and does not document additional auth layers or scope controls."},"pricing":{"model":"CData JDBC Driver + potentially CData MCP licensin","free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver for Apache Cassandra (trial/licensing referenced)","Managed MCP platform (CData Connect AI) mentioned for remote/full capabilities"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No MCP-specific pricing details are provided in the README; the JDBC driver licensing step is required and the managed alternative is referenced."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":54.0,"security_score":33.2,"reliability_score":23.8,"mcp_server_quality":78.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":60.0,"rate_limit_clarity":10.0,"tls_enforcement":30.0,"auth_strength":45.0,"scope_granularity":10.0,"dependency_hygiene":40.0,"secret_handling":40.0,"security_notes":"Security controls are largely delegated to the CData JDBC Driver and the database. The README indicates local stdio usage but does not document TLS, secrets storage practices (only that credentials are placed into a .prp / JDBC URL), query restrictions, auditing, or fine-grained scope enforcement. Running a query tool that accepts SQL increases risk of unintended heavy queries if an agent is not constrained.","uptime_documented":0.0,"version_stability":35.0,"breaking_changes_history":35.0,"error_recovery":25.0,"idempotency_support":"false","idempotency_notes":"Read-only operations (tables/columns/query SELECT) are generally idempotent, but the README does not specify idempotency semantics or safeguards for repeated query execution.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Transport is stdio, so the MCP server must run on the same machine as the client (no remote access).","Tool outputs are returned in CSV format; agents may need to parse CSV carefully.","The MCP interface includes a run_query tool that takes raw SQL SELECT; agents should constrain query size to avoid excessive results/timeouts (no limits are documented)."]}}