sap-hana-mcp-server-by-cdata
Provides a local MCP (Model Context Protocol) server for SAP HANA using CData JDBC Drivers. It is intended to expose SAP HANA data as callable MCP tools (table/column discovery and SQL SELECT execution) for local clients such as Claude Desktop, over stdio.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
Local stdio reduces network exposure, but SQL execution is still possible via run_query. The README does not describe TLS (not applicable for stdio) or MCP-level authentication/authorization, scope-based permissions, query sanitization, sandboxing, logging/redaction, or rate limiting. Connection details are stored in a local .prp file; proper secret handling is not documented here.
⚡ Reliability
Best When
You run the MCP server locally on the same machine as the MCP-capable client, and you have an existing CData JDBC Driver setup and valid connection configuration for SAP HANA.
Avoid When
You need strict safety controls for SQL execution, you require remote/hosted accessibility over a network, or you need robust API features like pagination/limits and standardized structured error codes surfaced at the MCP layer.
Use Cases
- • Enable an AI desktop client to query live SAP HANA data without writing SQL
- • Schema discovery for available HANA tables/columns via MCP tools
- • Interactive analytics/Q&A over SAP HANA datasets
- • Lightweight automation/scripting via MCP JSON-RPC tool calls (tools/call)
Not For
- • Internet-exposed remote MCP access (it is explicitly described as local/stdio)
- • Public multi-tenant deployments without additional hardening
- • Use as a generic SQL proxy for arbitrary untrusted prompts without query safety controls
- • Systems that require documented pagination, result limits, or structured query constraints
Interface
Authentication
The README describes using a CData JDBC Driver and configuring a connection string via a .prp file; if OAuth is required by the underlying data source/driver, authentication may occur in a browser. The MCP server itself runs locally over stdio and relies on the driver configuration.
Pricing
Pricing for the MCP server is not described in the provided README content. CData JDBC driver licensing is required and may involve trial/license terms outside this repository.
Agent Metadata
Known Gotchas
- ⚠ The server uses stdio, so it can only be used with clients running on the same machine.
- ⚠ Tooling includes run_query (SQL SELECT) which may still be expensive; the README does not document result-size limits or safe query patterns.
- ⚠ The README claims read-only MCP in the project description, but later usage text mentions write/update/delete; verify actual tool permissions/behavior in the implementation before enabling unrestricted querying.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for sap-hana-mcp-server-by-cdata.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-04-04.