Elkhn/sap-hana-mcp
Python implementation of an MCP server for SAP HANA, providing structured access and query handling.
Platform-specific configuration:
{
"mcpServers": {
"sap-hana-mcp": {
"command": "npx",
"args": [
"-y",
"sap-hana-mcp"
]
}
}
}Add the config above to .claude/settings.json under the mcpServers key.
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.
hdbcli)# Clone and enter the directory
cd sap-hana-mcp-server-python
# Install dependencies
pip install -r requirements.txtCopy the example environment file and fill in your SAP HANA credentials:
cp .env.example .envEdit .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.pyThe 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-mcpsap_hana_get_tablesLists 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) |
sap_hana_get_columnsLists columns for a specific table. Returns CSV with columns: Schema, Table, Column, DataType, Remarks.
| Parameter | Type | Required | Description | |---|---|---|---| | table |
Loading reviews...