hana-mcp-server

概述

SAP HANA MCP Server 为 SAP HANA 和 SAP HANA Cloud 实现了模型上下文协议。它允许 AI 客户端发现数据库模式、使用防护措施执行 SQL 查询，并可选地合并业务/领域元数据，以确保对代码和表的解释一致。服务器支持 stdio 和 HTTP 传输，使其与 Claude Desktop、Claude Code、VS Code、Cursor 和其他 MCP 客户端兼容。它提供全面的配置选项，包括连接参数、TLS 设置、查询限制和可选的业务语义覆盖。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• hana_explain_table

  Provides explanation of table structure with optional business semantics overlay

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

  Executes SQL queries with guardrails and paged results

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

  Retrieves the next page of results for a paged query

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

  Lists tables in the database with paging support

  试试:Show all tables in the database试试:List tables in the SAP schema
• hana_get_columns

  Retrieves column metadata for a specific table

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

  Tests connectivity to the SAP HANA database

  试试:Check if the database connection is working试试:Test the connection to HANA
• hana_list_resources

  Lists available resources via hana:/// URIs

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

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

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

  Lists indexes on a specific table

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

  Lists stored procedures in the database

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

  Lists database views

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

  Basic connectivity test to the HANA database

  试试:Ping the database试试:Test basic connectivity to HANA

可对比工具

安装

{
  "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

如何连接到 SAP HANA Cloud？

使用与本地 HANA 相同的配置，但设置 HANA_SSL=true、HANA_ENCRYPT=true，并提供您的 HANA Cloud 实例的适当主机和端口。

我可以将此服务器用于多个 HANA 租户吗？

是的，对于 MDC（多数据库容器），请在环境变量中指定 HANA_INSTANCE_NUMBER 和 HANA_DATABASE_NAME 以连接到特定租户。

hana-mcp-server 对比