SAP MCP Server (Python)

A Python-based Model Context Protocol (MCP) Server for SAP HANA and SQL databases. This allows AI clients like Claude Desktop to query live data from SAP systems.

Features

• SAP HANA support via hdbcli (SAP's official Python client)
• Generic SQL support via ODBC for other databases
• Read-only access - Only SELECT queries are allowed
• CSV output - Results formatted for easy AI consumption
• Simple YAML configuration

Prerequisites

• Python 3.10 or higher
• SAP HANA client libraries (for HANA connections)
• ODBC drivers (for ODBC connections)

Installation

1. Clone or download this project

cd D:\_projects\sap-mcp-server-python

2. Install the package

For SAP HANA:

pip install -e ".[hana]"

For ODBC connections:

pip install -e ".[odbc]"

For both:

pip install -e ".[all]"

3. Install SAP HANA Client (for HANA connections)

The hdbcli package requires the SAP HANA Client to be installed:

1. Download from SAP Development Tools
2. Install the SAP HANA Client
3. The hdbcli package will be available

Alternatively, install directly via pip (if available):

pip install hdbcli

Configuration

1. Create a configuration file

Copy the example configuration:

cp config.example.yaml config.yaml

2. Edit the configuration

For SAP HANA:

server:
  name: sap-hana
  prefix: sap_hana
  version: "1.0"

connector:
  type: hana
  host: your-hana-server.example.com
  port: 30015
  user: SYSTEM
  password: your-password

tables: []

For SAP HANA Cloud:

server:
  name: hana-cloud
  prefix: hana_cloud
  version: "1.0"

connector:
  type: hana
  host: your-instance.hana.ondemand.com
  port: 443
  user: DBADMIN
  password: your-password
  encrypt: true
  sslValidateCertificate: true

tables: []

For ODBC (SQL Server, etc.):

server:
  name: sql-server
  prefix: sql
  version: "1.0"

connector:
  type: odbc
  connection_string: "Driver={ODBC Driver 17 for SQL Server};Server=localhost;Database=mydb;UID=user;PWD=password"

tables: []

Running the Server

Standalone test

python -m sap_mcp config.yaml

If the configuration is correct, the server will start and wait for MCP requests via stdin.

With Claude Desktop

1. Edit Claude Desktop's configuration file:

   Windows: %APPDATA%\Claude\claude_desktop_config.json

   Mac: ~/Library/Application Support/Claude/claude_desktop_config.json

2. Add the MCP server configuration:

{
  "mcpServers": {
    "sap-hana": {
      "command": "python",
      "args": [
        "-m",
        "sap_mcp",
        "D:\\_projects\\sap-mcp-server-python\\config.yaml"
      ]
    }
  }
}

3. Restart Claude Desktop (fully quit and reopen)

4. Look for the MCP tools icon (hammer) in Claude Desktop

Available Tools

Once configured, the AI client will have access to these tools:

Tool	Description
{prefix}_get_tables	List all tables/views in the database
{prefix}_get_columns	List columns for a specific table
{prefix}_run_query	Execute a SQL SELECT statement

Example Usage

Ask Claude:

• "What tables are available in SAP HANA?"
• "Show me the columns in the CUSTOMERS table"
• "Get the top 10 orders by value"

Configuration Reference

Field	Required	Description
server.name	Yes	Name of the MCP server
server.prefix	Yes	Prefix for tool names (e.g., sap_hana)
server.version	No	Server version (default: "1.0")
connector.type	Yes	Connector type: hana or odbc
connector.host	HANA	HANA server hostname
connector.port	HANA	HANA server port (default: 30015)
connector.user	HANA	Database username
connector.password	HANA	Database password
connector.encrypt	No	Enable SSL encryption (default: false)
connector.sslValidateCertificate	No	Validate SSL cert (default: true)
connector.connection_string	ODBC	ODBC connection string
tables	No	List of tables to expose (empty = all)
log_file	No	Path to debug log file

Troubleshooting

Server won't start

1. Check that Python 3.10+ is installed: python --version
2. Verify the package is installed: pip show sap-mcp-server
3. Check configuration file syntax: python -c "import yaml; yaml.safe_load(open('config.yaml'))"

Connection fails

1. Test connectivity to your SAP HANA server
2. Verify credentials are correct
3. For HANA Cloud, ensure encrypt: true is set
4. Check firewall rules allow the port

Tools not showing in Claude Desktop

1. Fully quit Claude Desktop (check Task Manager / Activity Monitor)
2. Verify the config path in claude_desktop_config.json
3. Check for typos in the JSON configuration
4. Look at Claude Desktop logs for errors

Debug logging

Enable logging in your config:

log_file: /path/to/debug.log

Then check the log file for detailed information.

Project Structure

sap-mcp-server-python/
├── pyproject.toml          # Package configuration
├── config.example.yaml     # Example configuration
├── README.md               # This file
└── src/sap_mcp/
    ├── __init__.py
    ├── __main__.py         # Entry point
    ├── server.py           # MCP server setup
    ├── config.py           # Configuration loader
    ├── csv_utils.py        # CSV formatting
    ├── connectors/
    │   ├── base.py         # Abstract connector
    │   ├── hana.py         # SAP HANA connector
    │   └── odbc.py         # ODBC connector
    └── tools/
        ├── get_tables.py   # List tables tool
        ├── get_columns.py  # List columns tool
        └── run_query.py    # SQL query tool

License

MIT License - See LICENSE file for details.

Credits

Based on the CData MCP Server for SAP Business One.