Hana MCP Server

SAP HANA MCP server — Model Context Protocol server for SAP HANA and HANA Cloud. Use with Claude Code, VS Code, and other AI agents.

Remote serverstreamable-http

What is the Hana MCP server?

Connect Hana to Claude, Cursor or any other MCP client and it stops being a tab you switch to. SAP HANA MCP server — Model Context Protocol server for SAP HANA and HANA Cloud. Use with Claude Code, VS Code, and other AI agents. The hana mcp server is what makes that connection.

What the server does

  1. Config file path: - macOS: ~/Library/Application Support/Claude/claude_desktop_config.json - Windows: %APPDATA%\claude\claude_desktop_config.json - Linux: ~/.config/claude/claude_desktop_config.json

Installation

Because this one is hosted, setup is mostly authentication — you point your client at the endpoint and approve access. Nothing runs on your machine, so there is no runtime to keep patched.

Available tools

The toolset is worth reading before you wire it up, because it tells you what the integration is really for:

  • macOS — ** ~/Library/Application Support/Claude/claude_desktop_config.json
  • Windows — ** %APPDATA%\claude\claude_desktop_config.json
  • Linux — ** ~/.config/claude/claude_desktop_config.json
  • Secrets — ** HANA_PASSWORD, JWT material, and URLs with embedded credentials belong in env or a secret manager — not in git
  • Issues — ** GitHub Issues
  • Document — Purpose
  • Method — Use when
  • Audience — Transport
  • Topic — Detail
  • Endpoint — POST JSON-RPC to /mcp (default base http://127.0.0.1:3100)
  • Tuning — MCP_HTTP_HOST, MCP_HTTP_PORT
  • Health — GET /health → 200

Credentials and setup notes

Configuration is passed through the environment: HANA_HOST, HANA_PORT, HANA_USER, HANA_PASSWORD, HANA_SCHEMA, HANA_SSL, HANA_ENCRYPT, HANA_VALIDATE_CERT. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.

Worth knowing first

  • Your data travels to the provider's service, so the usual questions apply about what you send and what they retain.
  • With 14 tools registered it takes up a noticeable share of the context window; turn it off in projects that never touch Hana.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Where it fits

Among the developer tooling options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Hana's toolset — macOS, Windows, Linux and 11 more — is a fair guide to whether it matches your workflow. It is maintained by hatrigt; worth a glance at recent repository activity before you build anything load-bearing on it.

SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.

Available tools

ToolWhat it does
macOS** ~/Library/Application Support/Claude/claude_desktop_config.json
Windows** %APPDATA%\claude\claude_desktop_config.json
Linux** ~/.config/claude/claude_desktop_config.json
Secrets** HANA_PASSWORD, JWT material, and URLs with embedded credentials belong in env or a secret manager — not in git.
Issues** [GitHub Issues](https://github.com/hatrigt/hana-mcp-server/issues)
DocumentPurpose
MethodUse when
AudienceTransport
TopicDetail
EndpointPOST JSON-RPC to /mcp (default base http://127.0.0.1:3100)
TuningMCP_HTTP_HOST, MCP_HTTP_PORT
HealthGET /health → 200
CORSMCP_HTTP_ALLOWED_ORIGINS — [ENVIRONMENT.md §7](docs/ENVIRONMENT.md#7-http-transport-npm-run-starthttp)
VariableRole

How to install the Hana MCP server

{
  "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",
        "HANA_CONNECTION_TYPE": "auto",
        "HANA_INSTANCE_NUMBER": "10",
        "HANA_DATABASE_NAME": "HQQ",
        "LOG_LEVEL": "info",
        "ENABLE_FILE_LOGGING": "true",
        "ENABLE_CONSOLE_LOGGING": "false"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

VariableDescriptionRequired
HANA_HOSTEndpoint or connection string the server talks to.Optional
HANA_PORTConfiguration value read at startup.Optional
HANA_USERConfiguration value read at startup.Optional
HANA_PASSWORDConfiguration value read at startup.Optional
HANA_SCHEMAConfiguration value read at startup.Optional
HANA_SSLConfiguration value read at startup.Optional
HANA_ENCRYPTConfiguration value read at startup.Optional
HANA_VALIDATE_CERTConfiguration value read at startup.Optional

Example prompts to try

  • Use Hana to macOS.
  • Use Hana to Windows.
  • Use Hana to Linux.

Frequently asked questions

It connects Hana to MCP-compatible AI assistants such as Claude and Cursor, exposing 14 tools (macOS, Windows, Linux, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Hana directly.