logali-mcp-hana
Read-only SQL on SAP HANA Cloud
- HANA / Data
- TypeScript
- stdio
- MIT
- 5 tools
- Read and write
Overview
Gives your assistant safe access to SAP HANA and HANA Cloud: run read-only SELECT queries, list schemas and tables, and describe columns. Mutating statements are disabled unless write access is explicitly enabled.
Clean-room implementation by Logali Tech (original code, MIT license), inspired by the open-source ecosystem of SAP MCP servers.
Tools
What your assistant can call. Writes stay disabled unless you enable them.
-
run_queryRun a single SELECT/WITH with parameters and a row limit. Read -
list_schemasList schemas (optional owner filter). Read -
list_tablesList tables and views of a schema. Read -
describe_tableDescribe a table columns and its key. Read -
execute_statementExecute arbitrary DML/DDL (requires LOGALI_MCP_ALLOW_WRITE). Write
Installation
Clone and build, then point your MCP client at the binary. Pick your client:
Paste into claude_desktop_config.json
{
"mcpServers": {
"hana": {
"command": "node",
"args": [
"/path/to/logali-mcp-hana/dist/index.js"
],
"env": {
"HANA_HOST": "<hana_host>",
"HANA_USER": "<hana_user>",
"HANA_PASSWORD": "<hana_password>"
}
}
}
} Paste into ~/.cursor/mcp.json
{
"mcpServers": {
"hana": {
"command": "node",
"args": [
"/path/to/logali-mcp-hana/dist/index.js"
],
"env": {
"HANA_HOST": "<hana_host>",
"HANA_USER": "<hana_user>",
"HANA_PASSWORD": "<hana_password>"
}
}
}
} Paste into .vscode/mcp.json
{
"servers": {
"hana": {
"type": "stdio",
"command": "node",
"args": [
"/path/to/logali-mcp-hana/dist/index.js"
],
"env": {
"HANA_HOST": "<hana_host>",
"HANA_USER": "<hana_user>",
"HANA_PASSWORD": "<hana_password>"
}
}
}
} In your terminal
git clone https://github.com/logalitech/logali-mcp-hana
cd logali-mcp-hana
npm install && npm run buildConfiguration
Server environment variables.
| Variable | Required | Description |
|---|---|---|
| HANA_HOST | Yes | HANA Cloud host. |
| HANA_PORT | No | Port (default 443 on HANA Cloud). |
| HANA_USER | Yes | Database user. |
| HANA_PASSWORD | Yes | User password. |
| HANA_SCHEMA | No | Default schema. |
| LOGALI_MCP_ALLOW_WRITE | No | Enables execute_statement (default false). |
Related servers