SA
SkillAvatars
Back to MCP Tools

hana-mcp-server

data-ai MCP Server

SAP HANA MCP server — Enterprise Model Context Protocol server for SAP HANA. Use with Claude Code, VS Code. npm: hana-mcp-server

byHatriGt
VerifiedInstall Ready
data-aidata-ai
5 views58 stars26 forksv0.3.1MIT
View on GitHubHomepageDocs

Why This Matters

Discovered via github-topic:mcp-server and last synced 3mo ago.

VerifiedInstall Ready
Source
github-topic:mcp-server
Stars
58
Last synced
3mo ago
Install
Instructions detected

Install

1. Install the package

npx hana-mcp-server

2. Add to claude_desktop_config.json

{
  "mcpServers": {
    "hana-mcp-server": {
      "command": "npx",
      "args": [
        "hana-mcp-server"
      ]
    }
  }
}

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)

46
Tools
0
Resources
0
Prompts
Standard I/O
Transport

Available Tools (46)

Audience

Transport

CORS

`MCP_HTTP_ALLOWED_ORIGINS` — [ENVIRONMENT.md §7](docs/ENVIRONMENT.md#7-http-transport-npm-run-starthttp)

HANA_HOST

Hostname or IP

HANA_DATABASE_NAME

—

HANA_QUERY_TIMEOUT_MS

`0`

HTTP

[Hosted & HTTP](#-hosted--http)

MCP_HTTP_JWT_ISSUER

Issuer / JWKS (omit on **SAP BTP** with bound XSUAA)

LOG_LEVEL

`info`

Document

Purpose

Tuning

`MCP_HTTP_HOST`, `MCP_HTTP_PORT`

Area

Tools

HANA_CONNECTION_TYPE

`auto`

HANA_RESOURCE_LIST_MAX_ITEMS

`500`

Method

Use when

Health

`GET /health` → `200`

Parameter

Default

HANA_INSTANCE_NUMBER

—

HANA_QUERY_LIMITS_ENABLED

`false`

HANA_QUERY_SNAPSHOT_TTL_MS

`300000`

HANA_SEMANTICS_URL

—

stdio

[IDEs & code agents](#-ides--code-agents)

Variable

Role

HANA_USER

Database user

true

TLS and cert validation flags for the driver

HANA_MAX_RESULT_ROWS

`50`

Symptom

Check

Topic

Detail

MCP_HTTP_JWT_AUDIENCE

Optional expected `aud`

HANA_PORT

`443`

ENABLE_FILE_LOGGING

`false`*

HANA_QUERY_DEFAULT_OFFSET

`0`

HANA_ALLOW_DELETE

`false`

Endpoint

`POST` JSON-RPC to `/mcp` (default base `http://127.0.0.1:3100`)

MCP_HTTP_JWT_SCOPES_REQUIRED

Optional scope list

HANA_SCHEMA

—

ENABLE_CONSOLE_LOGGING

`true`

HANA_LIST_DEFAULT_LIMIT

`200`

MCP_HTTP_AUTH_ENABLED

`true` → require `Authorization: Bearer <token>` on `POST /mcp`

HANA_PASSWORD

Database password

HANA_MAX_RESULT_COLS

`50`

HANA_ALLOW_INSERT

`false`

HANA_MAX_CELL_CHARS

`200`

HANA_ALLOW_UPDATE

`false`

HANA_CONNECTION_POOL_SIZE

`3`

HANA_SEMANTICS_TTL_MS

`60000`

HANA_SEMANTICS_PATH

—

Browse all MCP servers