The SAP HANA MCP Server provides comprehensive, read-oriented SQL and metadata management, performance monitoring, and self-maintenance capabilities for SAP HANA and SAP Business One Service Layer environments — all through the Model Context Protocol.
Connection & Configuration
Test HANA connections, view server configuration and environment variables, and retrieve session info (user, schema, database, version).
Schema & Object Discovery
List schemas, tables, views, synonyms, procedures, functions, sequences, constraints, indexes, and calculation views with prefix filtering and pagination.
Search tables and columns by LIKE pattern across all schemas.
Describe/explain tables (including business semantics from semantic mapping files), views, procedures, and functions.
Retrieve DDL definitions for tables, views, procedures, functions, triggers, and sequences.
SQL Execution & Query Tooling
Execute arbitrary SQL (SELECT/WITH, plus optionally INSERT/UPDATE/DELETE if enabled) with paged reading, row/column caps, timeouts, and prepared-statement parameters.
Continue truncated queries via snapshots (hana_query_next_page).
Fetch sample rows, run EXPLAIN PLAN, and analyze execution plans.
Metadata & Statistics
Get object dependencies (base/dependent/both), partition info, effective privileges, table stats (row count, type, column store, size), and column stats (distinct/null/min/max).
Performance Monitoring & Diagnostics
Run health checks (DB info, services, memory, top tables, blocked transactions).
Monitor indexserver memory with optional CSV history logging.
Get real-time performance snapshots (open transactions, SQL plan cache, long connections, column-store deltas).
Retrieve the most expensive queries from monitoring views.
Knowledge Base Management
Search, read, save, and index knowledge cases (Markdown-based, local + bundled + remote/cloud-synced). Full KB read/search works even in offline (expired-license) mode.
Licensing & Self-Update
View license status, hardware ID, plan, features, and expiration; enter/validate JWT license tokens.
Check for and apply server updates while preserving user KB cases and configuration. Never auto-updates.
Offline Mode
When the license expires, the server continues in read-only offline mode, with KB search/read/index and license info still available.
Provides integration with SAP HANA and SAP HANA Cloud databases, enabling schema discovery, SQL query execution with guardrails, structural analysis, code object inspection, performance monitoring, and health checks.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@SAP HANA MCP Server List all tables in the SAPABAP1 schema"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Paquete ejecutable del Model Context Protocol (MCP) server para SAP HANA y SAP Business One Service Layer.
Descargá la última versión desde Releases:
hana-mcp-server-v0.3.1-win-x64.zip
Descomprimí el ZIP en una carpeta permanente, por ejemplo:
C:\hana-mcp-client\Related MCP server: SAP Datasphere MCP Server
Windows 10/11 o Windows Server 2019+ (x64)
Acceso de red al servidor SAP HANA
Token de licencia JWT proporcionado por el vendor (si aplica)
No necesitás instalar Node.js: el ejecutable incluye su propio runtime.
Descomprimí el ZIP en la carpeta destino.
Copiá .env.example como .env y completá al menos:
HANA_HOST
HANA_PORT
HANA_USER
HANA_PASSWORD
HANA_SCHEMA
Si recibiste el token JWT como archivo, guardalo como .hana-license en la misma carpeta.
Ejecutá start.bat (doble clic) o configurá tu cliente MCP para que apunte a hana-mcp-server.exe.
.envEjemplo mínimo:
HANA_HOST=tu-servidor-hana
HANA_PORT=30015
HANA_USER=TU_USUARIO
HANA_PASSWORD=TU_PASSWORD
HANA_SCHEMA=TU_SCHEMA
HANA_SSL=false
HANA_VALIDATE_CERT=falseVer .env.example para todas las opciones disponibles.
Obtené tu hardware ID ejecutando el servidor y consultando la tool hana_show_license_info. Enviale ese HWID al vendor para que genere tu token.
{
"name": "hana_show_license_info",
"arguments": {}
}Una vez instalado el token, la misma tool debe reportar:
status: VALID
plan: enterprise
features: ["hana", "knowledge-base"]Ejemplo de mcp.json:
{
"mcpServers": {
"hana": {
"type": "stdio",
"command": "C:\\hana-mcp-client\\hana-mcp-server.exe"
}
}
}El servidor nunca se actualiza solo. Cuando haya una nueva versión, el vendor la publicará en Releases. Podés consultarla con la tool hana_check_for_updates y aplicarla con hana_apply_update:
{
"name": "hana_apply_update",
"arguments": {
"confirm": true
}
}El proceso preserva tus casos propios (docs/kb/user/), los casos sincronizados desde la nube (docs/kb/remote/) y tu configuración (.env, .hana-license, mcp.json). Los casos incluidos con el producto (docs/kb/bundled/) sí se actualizan.
hana-mcp-server.exe — MCP empaquetado con Node.js.
start.bat — lanzador para Windows.
docs/kb/bundled/ — base de conocimiento incluida con el producto.
docs/kb/user/ — casos que crees vos (vacío al inicio).
docs/kb/remote/ — casos sincronizados desde el servidor remoto.
node_modules/@sap/hana-client/ — driver nativo de SAP HANA.
public-key.pem — clave pública para validar licencias.
.env.example — plantilla de configuración.
mcp.json.example — plantilla de configuración MCP.
scripts/update-client.ps1 / update-client.sh — helpers de actualización.
Si la licencia expira, el MCP no se cierra: entra en modo offline y mantiene disponible la base de conocimiento local en modo de solo lectura.
Funcionan:
hana_search_knowledge_base
hana_read_kb_case
hana_generate_kb_index
hana_show_license_info
No funcionan hasta renovar la licencia:
Todas las tools de consulta y administración de HANA.
Guardar nuevos casos (hana_save_knowledge_case).
Sincronización remota de KB.
Para renovar la licencia, agregar hardware IDs adicionales o reportar problemas, contactá al vendor con el hardware ID mostrado por hana_show_license_info.
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
MCP server for AI agents to plan, verify, and deploy Cloudflare-native apps.
Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.
Official Microsoft MCP Server to query Microsoft Entra data using natural language
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/josecarlos3390/sap-hana-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server