{"id":"cdatasoftware-sap-hana-xs-advanced-mcp-server-by-cdata","name":"sap-hana-xs-advanced-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/sap-hana-xs-advanced-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","sap","hana","jdbc","data-access","read-only","claude-desktop","java"],"what_it_does":"Provides a read-only Model Context Protocol (MCP) server that wraps the CData JDBC Driver for SAP HANA XS Advanced, exposing underlying SAP HANA data as MCP tools (table/column discovery and SQL SELECT queries) for LLM clients like Claude Desktop.","use_cases":["Letting an LLM answer questions by querying live SAP HANA XS Advanced data without writing SQL","Interactive exploration of available tables and columns via MCP tools","Reporting/analysis workflows where read-only access to SAP HANA data is sufficient"],"not_for":["Use cases requiring write/update/delete or data modification (explicitly stated as read-only for this project)","Security-sensitive environments where allowing an LLM to run ad-hoc SQL is unacceptable without strong query controls","Client/server deployments where stdio-based MCP is incompatible with network separation needs"],"best_when":"You want a local-machine MCP integration (stdio) to enable natural-language read-only analytics over SAP HANA XS Advanced using existing CData JDBC connectivity.","avoid_when":"Avoid when you cannot safely provision JDBC credentials to a locally running process or when you need networked access, fine-grained query/row-level enforcement, or robust pagination/limits for large result sets.","alternatives":["CData’s MCP Server for SAP HANA XS Advanced with full CRUD and simplified setup","Direct use of the CData JDBC Driver from your own application (without MCP)","Building a custom MCP server that enforces query allowlists and parameterization"],"af_score":46.5,"security_score":45.2,"reliability_score":22.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:58:09.641360+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":["Uses CData JDBC Driver connection string (.prp) for authentication to SAP HANA XS Advanced; OAuth may require browser-based authentication when supported by the JDBC driver"],"oauth":true,"scopes":false,"notes":"Authentication is delegated to the CData JDBC Driver via the provided JDBC URL/connection string in the .prp file. The README does not specify MCP-level auth or fine-grained scopes for the tools."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No pricing described for this MCP server itself; README indicates licensing the CData JDBC Driver (e.g., trial or license key)."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":46.5,"security_score":45.2,"reliability_score":22.5,"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":0.0,"tls_enforcement":60.0,"auth_strength":55.0,"scope_granularity":30.0,"dependency_hygiene":50.0,"secret_handling":30.0,"security_notes":"TLS requirements for the JDBC connection are not documented here; security relies on CData JDBC Driver/SAP HANA configuration. Credentials are placed in a local .prp file (likely contains JDBC URL/connection details), which can be a risk if the file permissions are weak. The toolset includes an interface to run SQL SELECT; without query allowlisting/limits, an LLM could request large or sensitive data. No MCP-level authentication, scope controls, or redaction behavior is described in the README.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"Tools include metadata discovery and SQL SELECT. SELECT is generally idempotent, but the MCP server behavior for retries and side effects is not documented; README also mentions write/update/delete in marketing language (for other product) so the exact behavior here should be confirmed in implementation.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Uses stdio for MCP; server must run on the same machine as the MCP client (e.g., Claude Desktop).","If the underlying data source uses OAuth, initial JDBC driver authentication may require browser-based login.","Large result sets may be inefficient because the README describes CSV output without pagination controls.","The README describes tools that execute SQL SELECT; agents may generate heavy/expensive queries unless constrained."]}}