HANA Cloud MCP
Enables integration between SAP HANA Cloud Database and Cursor IDE through the Model Context Protocol, providing standardized interfaces for managing ML models and execution contexts.
What is HANA Cloud MCP?
HANA Cloud MCP is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to enables integration between sap hana cloud database and cursor ide through the model context protocol, providing standardized interfaces for managing ml models and execution contexts.
Enables integration between SAP HANA Cloud Database and Cursor IDE through the Model Context Protocol, providing standardized interfaces for managing ML models and execution contexts.
This server falls under the Databases and Cloud Services categories on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Enables integration between SAP HANA Cloud Database and Curs
Use Cases
Maintainer
Works with
Installation
NPM
npx -y hana-mcp-serverManual Installation
npx -y hana-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use HANA Cloud MCP
The HANA Cloud MCP Server provides a comprehensive Model Context Protocol interface to SAP HANA Cloud databases, exposing 34 tools across six functional areas: connection management, schema browsing, SQL execution, structural analysis, code object discovery, and data/performance analysis. It allows AI assistants like Claude and Cursor to explore database schemas, describe tables and columns, run parameterized queries, inspect stored procedures and calculation views, and analyze query execution plans — all with DML operations blocked by default and opt-in via individual environment variables. Database administrators, SAP BTP developers, and data engineers can use this server to perform deep HANA introspection and troubleshooting through natural language.
Prerequisites
- Node.js 18 or later installed
- A running SAP HANA Cloud instance with network access from your machine
- A HANA database user with SELECT privileges on the schemas you want to query
- Your HANA host URL, username, and password
- An MCP client such as Claude Desktop or Cursor
Verify HANA Cloud connectivity
Confirm you can connect to your SAP HANA Cloud instance using your credentials before configuring the MCP server. Note your host URL (e.g., abc123.hanacloud.ondemand.com), port (default 443), username, and password.
Test the server with npx
Run the server directly via npx to verify it launches without errors. Pass required credentials as environment variables.
HANA_HOST=your-hana-host.hanacloud.ondemand.com \
HANA_USER=your_username \
HANA_PASSWORD=your_password \
npx -y hana-mcp-serverConfigure Claude Desktop
Add the HANA MCP server to your Claude Desktop configuration at ~/Library/Application Support/Claude/claude_desktop_config.json with all required and optional environment variables.
{
"mcpServers": {
"hana": {
"command": "npx",
"args": ["-y", "hana-mcp-server"],
"env": {
"HANA_HOST": "your-hana-host.hanacloud.ondemand.com",
"HANA_PORT": "443",
"HANA_USER": "your_username",
"HANA_PASSWORD": "your_password",
"HANA_SCHEMA": "your_default_schema",
"HANA_SSL": "true",
"HANA_ENCRYPT": "true",
"HANA_VALIDATE_CERT": "true"
}
}
}
}Optionally enable DML operations
By default, INSERT, UPDATE, DELETE, and TRUNCATE are blocked. To opt in to specific DML operations, add the corresponding environment variables. Only enable what you truly need.
# Add to the env block to allow specific DML operations:
# "HANA_ALLOW_INSERT": "true"
# "HANA_ALLOW_UPDATE": "true"
# "HANA_ALLOW_DELETE": "true"Restart your MCP client and explore your database
Restart Claude Desktop or Cursor to load the HANA server. Begin exploring schemas, tables, and running queries through natural language prompts.
HANA Cloud MCP Examples
Client configuration
Complete claude_desktop_config.json entry for the HANA Cloud MCP server with the required connection parameters.
{
"mcpServers": {
"hana": {
"command": "npx",
"args": ["-y", "hana-mcp-server"],
"env": {
"HANA_HOST": "your-hana-host.hanacloud.ondemand.com",
"HANA_PORT": "443",
"HANA_USER": "your_username",
"HANA_PASSWORD": "your_password",
"HANA_SCHEMA": "your_default_schema",
"HANA_SSL": "true",
"HANA_ENCRYPT": "true",
"HANA_VALIDATE_CERT": "true"
}
}
}
}Prompts to try
Use these prompts to explore your SAP HANA Cloud database through Claude. The server supports schema browsing, SQL execution, and performance analysis.
- "List all schemas in my HANA Cloud database"
- "Describe the columns and data types in the SALES_ORDERS table"
- "Show me the top 10 rows from CUSTOMER_DATA with their ORDER_COUNT"
- "Find all stored procedures in the REPORTING schema"
- "What are the most expensive queries currently running on HANA?"
- "Show the execution plan for this SQL query: SELECT * FROM ORDERS WHERE STATUS = 'PENDING'"Troubleshooting HANA Cloud MCP
Connection refused or TLS handshake error
Confirm HANA_HOST and HANA_PORT are correct. HANA Cloud typically uses port 443 with SSL. Ensure HANA_SSL, HANA_ENCRYPT, and HANA_VALIDATE_CERT are all set to true. If using a self-signed certificate, set HANA_VALIDATE_CERT to false for testing only.
Authentication failed for HANA user
Verify HANA_USER and HANA_PASSWORD match your HANA Cloud credentials exactly. SAP HANA usernames are case-sensitive and are typically uppercase. Confirm the user account is not locked in the HANA cockpit.
DML operation blocked with permission error
INSERT, UPDATE, DELETE, and TRUNCATE are blocked by default as a safety measure. To enable them, add HANA_ALLOW_INSERT, HANA_ALLOW_UPDATE, or HANA_ALLOW_DELETE set to true in the env block. Only enable the specific operations you need.
Frequently Asked Questions about HANA Cloud MCP
What is HANA Cloud MCP?
HANA Cloud MCP is a Model Context Protocol (MCP) server that enables integration between sap hana cloud database and cursor ide through the model context protocol, providing standardized interfaces for managing ml models and execution contexts. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install HANA Cloud MCP?
Install via npm with the command: npx -y hana-mcp-server. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).
Which AI clients work with HANA Cloud MCP?
HANA Cloud MCP works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is HANA Cloud MCP free to use?
Yes, HANA Cloud MCP is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
HANA Cloud MCP Alternatives — Similar Databases Servers
Looking for alternatives to HANA Cloud MCP? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up HANA Cloud MCP in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use HANA Cloud MCP?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.