hana-mcp-server

Overview

The SAP HANA MCP Server implements the Model Context Protocol for SAP HANA and SAP HANA Cloud. It allows AI clients to discover database schema, execute SQL queries with guardrails, and optionally merge business/domain metadata to ensure consistent interpretation of codes and tables. The server supports both stdio and HTTP transports, making it compatible with Claude Desktop, Claude Code, VS Code, Cursor, and other MCP clients. It provides comprehensive configuration options including connection parameters, TLS settings, query limits, and optional business semantics overlays.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• hana_explain_table

  Provides explanation of table structure with optional business semantics overlay

  Try:Explain the structure of the CUSTOMERS tableTry:What columns are in the SALES table?
• hana_execute_query

  Executes SQL queries with guardrails and paged results

  Try:Run a query to find top 10 customers by revenueTry:List all orders from last month
• hana_query_next_page

  Retrieves the next page of results for a paged query

  Try:Get the next page of resultsTry:Continue retrieving the large query results
• hana_get_tables

  Lists tables in the database with paging support

  Try:Show all tables in the databaseTry:List tables in the SAP schema
• hana_get_columns

  Retrieves column metadata for a specific table

  Try:What columns are in the PRODUCTS table?Try:Show me the structure of the INVOICE table
• hana_check_connection

  Tests connectivity to the SAP HANA database

  Try:Check if the database connection is workingTry:Test the connection to HANA
• hana_list_resources

  Lists available resources via hana:/// URIs

  Try:What resources are available?Try:List all accessible HANA resources
• hana_read_resource

  Reads content from a resource using hana:/// URI

  Try:Read the data from hana:///tables/CUSTOMERSTry:Get the contents of resource hana:///views/SALES_SUMMARY
• hana_get_indexes

  Lists indexes on a specific table

  Try:Show indexes on the ORDERS tableTry:What indexes exist on the PRODUCTS table?
• hana_get_procedures

  Lists stored procedures in the database

  Try:What procedures are available in the database?Try:List all SAP procedures
• hana_get_views

  Lists database views

  Try:Show all database viewsTry:List views in the sales schema
• hana_ping

  Basic connectivity test to the HANA database

  Try:Ping the databaseTry:Test basic connectivity to HANA

Comparable tools

Installation

{
  "mcpServers": {
    "HANA Database": {
      "command": "npx",
      "args": ["-y", "hana-mcp-server"],
      "env": {
        "HANA_HOST": "your-hana-host.com",
        "HANA_PORT": "443",
        "HANA_USER": "your-username",
        "HANA_PASSWORD": "your-password",
        "HANA_SCHEMA": "your-schema",
        "HANA_SSL": "true",
        "HANA_ENCRYPT": "true",
        "HANA_VALIDATE_CERT": "true",
        "LOG_LEVEL": "info"
      }
    }
  }
}

npm install -g hana-mcp-server

git clone <repository-url>
cd hana-mcp-server
npm install
node hana-mcp-server.js

FAQ

How do I connect to SAP HANA Cloud?

Use the same configuration as on-prem HANA, but set HANA_SSL=true, HANA_ENCRYPT=true, and provide the appropriate host and port for your HANA Cloud instance.

Can I use this with multiple HANA tenants?

Yes, for MDC (Multitenant Database Container), specify HANA_INSTANCE_NUMBER and HANA_DATABASE_NAME in your environment variables to connect to specific tenants.

Compare hana-mcp-server with