What can you do with this server?

The SAP HANA MCP Server enables AI agents and development tools to securely interact with SAP HANA databases through the Model Context Protocol (MCP). **Database Operations:** * Execute custom SQL queries, including parameterized queries for prepared statements * Retrieve sample data and count rows in tables * Test database connectivity and view configuration settings **Schema Management:** * List all schemas, tables within schemas, and describe table structures * List and describe indexes for tables * Explore database schema through natural language commands **System Administration:** * Monitor memory usage statistics and system information * Get current database user information * Debug environment variables **Integration & Security:** * Seamlessly integrates with Claude Desktop, VSCode extensions, and custom AI applications * Features enterprise-grade security with SSL/TLS support and secure credential management * Provides both command-line interface and React-based web UI * Uses JSON-RPC 2.0 with modular architecture for easy extension

Which integrations are available for this server?

Uses [.env](/mcp/servers/integrations/dotenv) files for configuration management of server settings and connection parameters Uses [Flask](/mcp/servers/integrations/flask) to implement the REST API layer of the MCP server architecture Utilizes [pandas](/mcp/servers/integrations/pandas) as a prerequisite library, likely for data manipulation and analysis within the model execution context Built on [Python](/mcp/servers/integrations/python) 3.8+ as the core programming language for the server implementation Provides integration with [SAP](/mcp/servers/integrations/sap) HANA Cloud Database, allowing for machine learning operations and model management directly with the SAP HANA Cloud environment

HANA MCP Server

npm version npm downloads Node.js License MCP

Model Context Protocol (MCP) server for seamless SAP HANA database integration with AI agents and development tools.

🚀 Quick Start

1. Install

npm install -g hana-mcp-server

2. Configure Claude Desktop

Update your Claude Desktop config file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\claude\claude_desktop_config.json
Linux: ~/.config/claude/claude_desktop_config.json

{ "mcpServers": { "HANA Database": { "command": "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" } } } }

3. Restart Claude Desktop

Close and reopen Claude Desktop to load the configuration.

4. Test It!

Ask Claude: "Show me the available schemas in my HANA database"

Related MCP server: Cursor DB MCP Server

🎯 What You Get

Database Operations

Schema Exploration: List schemas, tables, and table structures
Query Execution: Run SQL queries with natural language
Data Sampling: Get sample data from tables
System Information: Monitor database status and performance

AI Integration

Natural Language Queries: "Show me all tables in the SYSTEM schema"
Query Building: "Create a query to find customers with orders > $1000"
Data Analysis: "Get sample data from the ORDERS table"
Schema Navigation: "Describe the structure of table CUSTOMERS"

🖥️ Visual Configuration (Recommended)

For easier setup and management, use the HANA MCP UI:

npx hana-mcp-ui

This opens a web interface where you can:

Configure multiple database environments
Deploy configurations to Claude Desktop with one click
Manage active connections
Test database connectivity

HANA MCP UI

🛠️ Configuration Options

Required Parameters

Parameter	Description	Example
`HANA_HOST`	Database hostname or IP address	`hana.company.com`
`HANA_USER`	Database username	`DBADMIN`
`HANA_PASSWORD`	Database password	`your-secure-password`

Optional Parameters

Parameter	Description	Default	Options
`HANA_PORT`	Database port	`443`	Any valid port number
`HANA_SCHEMA`	Default schema name	-	Schema name
`HANA_CONNECTION_TYPE`	Connection type	`auto`	`auto` , `single_container` , `mdc_system` , `mdc_tenant`
`HANA_INSTANCE_NUMBER`	Instance number (MDC)	-	Instance number (e.g., `10` )
`HANA_DATABASE_NAME`	Database name (MDC tenant)	-	Database name (e.g., `HQQ` )
`HANA_SSL`	Enable SSL connection	`true`	`true` , `false`
`HANA_ENCRYPT`	Enable encryption	`true`	`true` , `false`
`HANA_VALIDATE_CERT`	Validate SSL certificates	`true`	`true` , `false`
`LOG_LEVEL`	Logging level	`info`	`error` , `warn` , `info` , `debug`
`ENABLE_FILE_LOGGING`	Enable file logging	`true`	`true` , `false`
`ENABLE_CONSOLE_LOGGING`	Enable console logging	`false`	`true` , `false`

Database Connection Types

1. Single-Container Database

Standard HANA database with single tenant.

Required: HANA_HOST, HANA_USER, HANA_PASSWORD
Optional: HANA_PORT, HANA_SCHEMA

{ "HANA_HOST": "hana.company.com", "HANA_PORT": "443", "HANA_USER": "DBADMIN", "HANA_PASSWORD": "password", "HANA_SCHEMA": "SYSTEM", "HANA_CONNECTION_TYPE": "single_container" }

2. MDC System Database

Multi-tenant system database (manages tenants).

Required: HANA_HOST, HANA_PORT, HANA_INSTANCE_NUMBER, HANA_USER, HANA_PASSWORD
Optional: HANA_SCHEMA

{ "HANA_HOST": "192.168.1.100", "HANA_PORT": "31013", "HANA_INSTANCE_NUMBER": "10", "HANA_USER": "SYSTEM", "HANA_PASSWORD": "password", "HANA_SCHEMA": "SYSTEM", "HANA_CONNECTION_TYPE": "mdc_system" }

3. MDC Tenant Database

Multi-tenant tenant database (specific tenant).

Required: HANA_HOST, HANA_PORT, HANA_INSTANCE_NUMBER, HANA_DATABASE_NAME, HANA_USER, HANA_PASSWORD
Optional: HANA_SCHEMA

{ "HANA_HOST": "192.168.1.100", "HANA_PORT": "31013", "HANA_INSTANCE_NUMBER": "10", "HANA_DATABASE_NAME": "HQQ", "HANA_USER": "DBADMIN", "HANA_PASSWORD": "password", "HANA_SCHEMA": "SYSTEM", "HANA_CONNECTION_TYPE": "mdc_tenant" }

Auto-Detection

When HANA_CONNECTION_TYPE is set to auto (default), the server automatically detects the type:

If HANA_INSTANCE_NUMBER + HANA_DATABASE_NAME → MDC Tenant
If only HANA_INSTANCE_NUMBER → MDC System
If neither → Single-Container

🏗️ Architecture

System Architecture

HANA MCP Server Architecture

Component Structure

hana-mcp-server/ ├── 📁 src/ │ ├── 🏗️ server/ # MCP Protocol & Server Management │ │ ├── index.js # Main server entry point │ │ ├── mcp-handler.js # JSON-RPC 2.0 implementation │ │ └── lifecycle-manager.js # Server lifecycle management │ ├── 🛠️ tools/ # Tool Implementations │ │ ├── index.js # Tool registry & discovery │ │ ├── config-tools.js # Configuration management │ │ ├── schema-tools.js # Schema exploration │ │ ├── table-tools.js # Table operations │ │ ├── index-tools.js # Index management │ │ └── query-tools.js # Query execution │ ├── 🗄️ database/ # Database Layer │ │ ├── hana-client.js # HANA client wrapper │ │ ├── connection-manager.js # Connection management │ │ └── query-executor.js # Query execution utilities │ ├── 🔧 utils/ # Shared Utilities │ │ ├── logger.js # Structured logging │ │ ├── config.js # Configuration management │ │ ├── validators.js # Input validation │ │ └── formatters.js # Response formatting │ └── 📋 constants/ # Constants & Definitions │ ├── mcp-constants.js # MCP protocol constants │ └── tool-definitions.js # Tool schemas ├── 🧪 tests/ # Testing Framework ├── 📚 docs/ # Documentation ├── 📦 package.json # Dependencies & Scripts └── 🚀 hana-mcp-server.js # Main entry point

📚 Available Commands

Once configured, you can ask Claude to:

"List all schemas in the database"
"Show me tables in the SYSTEM schema"
"Describe the CUSTOMERS table structure"
"Execute: SELECT * FROM SYSTEM.TABLES LIMIT 10"
"Get sample data from ORDERS table"
"Count rows in CUSTOMERS table"

🔧 Troubleshooting

Connection Issues

"Connection refused": Check HANA host and port
"Authentication failed": Verify username/password
"SSL certificate error": Set HANA_VALIDATE_CERT=false or install valid certificates

Debug Mode

export LOG_LEVEL="debug" export ENABLE_CONSOLE_LOGGING="true" hana-mcp-server

📦 Package Info

Size: 21.7 kB
Dependencies: @sap/hana-client, axios
Node.js: 18+ required
Platforms: macOS, Linux, Windows

🤝 Support

Issues: GitHub Issues
UI Tool: HANA MCP UI

📄 License

MIT License - see LICENSE file for details.

One-click Deploy

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

Resources

Need Help?

Report Issue

Reddit Discussion

Related Servers

Tools

View all tools

HANA Cloud MCP Server