sap-hana-mcp

A Model Context Protocol (MCP) server for SAP HANA, built with FastMCP and the official SAP HANA Python driver (hdbcli).

This server exposes SAP HANA database capabilities (listing tables, columns, running queries) as MCP tools that AI assistants can use.

• Python 3.10+
• Access to a SAP HANA instance (on-premise or SAP HANA Cloud)
• SAP HANA client libraries (installed automatically with hdbcli)

# Clone and enter the directory
cd sap-hana-mcp-server-python

# Install dependencies
pip install -r requirements.txt

Copy the example environment file and fill in your SAP HANA credentials:

cp .env.example .env

Edit .env with your connection details:

| Variable | Description | Default | |---|---|---| | HANA_HOST | SAP HANA server hostname | *(required)* | | HANA_PORT | SAP HANA server port | 443 | | HANA_USER | Database username | *(required)* | | HANA_PASSWORD | Database password | *(required)* | | HANA_SCHEMA | Default schema to filter tables | *(optional)* | | SERVER_PORT | MCP server HTTP port | 8000 |

python main.py

The server starts on http://localhost:8000/sse using SSE transport.

docker build -t sap-hana-mcp .
docker run -p 8000:8000 --env-file .env sap-hana-mcp

Lists tables available in the SAP HANA instance. Returns CSV with columns: Schema, Table, Description.

| Parameter | Type | Required | Description | |---|---|---|---| | catalog | string | No | Catalog name filter | | schema | string | No | Schema name filter (defaults to HANA_SCHEMA) |

Lists columns for a specific table. Returns CSV with columns: Schema, Table, Column, DataType, Remarks.

| Parameter | Type | Required | Description | |---|---|---|---| | table |