SAP HANA MCP Server (Python)

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.

Prerequisites

• Python 3.12+

• Access to a SAP HANA instance (on-premise or SAP HANA Cloud)

• SAP HANA client libraries (installed automatically with hdbcli)

Related MCP server: odata-mcp-proxy

Installation

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

# Install dependencies
pip install -r requirements.txt

Configuration

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

cp .env.example .env

Edit .env with your server settings:

Authentication

SAP HANA credentials are provided by each MCP client via HTTP Basic Auth. The server does not store database credentials — each request must include an Authorization header with the user's SAP HANA username and password.

Authorization: Basic <base64(username:password)>

If the header is missing or invalid, the server returns an error. This allows different users to connect with their own SAP HANA accounts.

Running the Server

Locally

python main.py

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

With Docker

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

MCP Tools

sap_hana_get_tables

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

sap_hana_get_columns

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

sap_hana_run_query

Executes a SQL SELECT statement. Returns results in CSV format. The SQL dialect is based on SQL-92. Identifiers should be quoted with double quotes.

sap_hana_lookup_table_info

Looks up SAP table and field descriptions from leanx.eu. Useful when the SAP HANA system catalog has no comments or descriptions for tables and columns. Does not require database authentication.

Returns CSV with columns: Field, Description, DataElement, Datatype, Length, Decimals.

MCP Resources

sap_hana://tables/{schema}/{table}

Returns column metadata for a given schema and table in CSV format.

Connecting to AI Clients

Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "sap-hana": {
      "url": "http://localhost:8000/sse",
      "headers": {
        "Authorization": "Basic <base64(username:password)>"
      }
    }
  }
}

Cursor / Other MCP Clients

Use the SSE endpoint http://localhost:8000/sse and configure the Authorization: Basic header with your SAP HANA credentials.

Project Structure

sap-hana-mcp-server-python/
  main.py            # MCP server with tools and resources
  requirements.txt   # Python dependencies
  .env.example       # Environment variable template
  Dockerfile         # Docker container build
  pyproject.toml     # Project metadata
  README.md          # This file

License

MIT