Hana MCP Server
SAP HANA MCP server — Enterprise Model Context Protocol server for SAP HANA. Use with Claude Code, VS Code. npm: hana-mcp-server
Hana MCP Server is an open-source mcp server by HatriGt, written mainly in JavaScript, with 74 GitHub stars and the MIT license. Its code was last updated Oct 7, 2026. The latest npm release is hana-mcp-server 0.3.4, published Jul 18, 2026, with 666 downloads last week.
Scan summary: scanned Nov 5, 2026 at commit bcdfe0b. Seen able to run shell commands, read environment and secrets, connect to databases. Scan policy
How to install Hana MCP Server
Built from the start command in the project's README: npx -y hana-mcp-server. Check the README for required keys or settings.
claude mcp add hana-mcp-server -- npx -y hana-mcp-server{
"mcpServers": {
"hana-mcp-server": {
"command": "npx",
"args": [
"-y",
"hana-mcp-server"
]
}
}
}{
"mcpServers": {
"hana-mcp-server": {
"command": "npx",
"args": [
"-y",
"hana-mcp-server"
]
}
}
}code --add-mcp '{"name":"hana-mcp-server","command":"npx","args":["-y","hana-mcp-server"]}'What Hana MCP Server can touch
- Seen in this scan, either in the code or while it ran.Run shell commandsFound in the code by our scan
- Our checks did not find this. The tool may still do it.Run dynamic codeNot seen in this scan
- Our checks did not find this. The tool may still do it.Read or write filesNot seen in this scan
- The server lists a tool that does this.Read environment and secretsListed as a tool: hana_show_env_vars
- Our checks did not find this. The tool may still do it.Control a web browserNot seen in this scan
- The server lists a tool that does this.Connect to databasesListed as a tool: hana_list_tables
- Our checks did not find this. The tool may still do it.Read or send messagesNot seen in this scan
- Our checks did not find this. The tool may still do it.Touch money or tradingNot seen in this scan
- Our checks did not find this. The tool may still do it.Connect to the internetNo connections seen while running
"Not seen" means our checks did not find it, and the tool may still do it. Covers commit bcdfe0b, Nov 5, 2026. See the scan policy.
Before you install Hana MCP Server
AgenticMart scanned Hana MCP Server on Nov 5, 2026 with automated checks for hidden code, known-malicious packages, leaked secrets and vulnerable dependencies. The result covers one commit under our scan policy, so review what access you give it and check any advisories shown here.
What it can access
- An MCP server is a program your AI app starts and talks to. A local one runs with your user's permissions: it can see the files, environment variables and network your account can.
- Based on its description and topics, it likely needs to act on cloud infrastructure.
Before you install
- Use a role with only the permissions it needs, never an admin key.
- Pin the version you reviewed instead of always installing the latest release.
- Read the tool list or scripts before the first run, and keep approval prompts on for actions that write, send or delete.
- Maintained by HatriGt on GitHub, 74 stars and 30 forks. Popularity is not proof of safety.
- Last code change: Oct 7, 2026.
- Open-source license: MIT.
Tools Hana MCP Server exposes (34)
Listed by the server itself during our scan of commit bcdfe0b.
hana_show_configShow the HANA database configuration
hana_test_connectionTest connection to HANA database
hana_list_schemasList schemas in the HANA database with optional prefix filter and pagination (HANA_LIST_DEFAULT_LIMIT / offset).
hana_show_env_varsShow all HANA-related environment variables (for debugging)
hana_list_tablesList tables in a schema with optional name prefix and pagination (HANA_LIST_DEFAULT_LIMIT / offset).
hana_describe_tableDescribe the structure of a specific table
hana_explain_tableReturn column metadata merged with optional business semantics from HANA_SEMANTICS_PATH or HANA_SEMANTICS_URL (JSON keys: SCHEMA.TABLE or DB.SCHEMA.TABLE when catalog_database is set). Optional catalog_database reads SYS.* from another MDC database (e.g. HSP).
hana_list_indexesList all indexes for a specific table
hana_describe_indexDescribe the structure of a specific index
hana_execute_queryExecute SQL against HANA. When HANA_QUERY_LIMITS_ENABLED=true, SELECT/WITH queries are wrapped with LIMIT/OFFSET (HANA_MAX_RESULT_ROWS) and row/column/cell caps apply; results are returned as-is otherwise. INSERT/UPDATE/DELETE are blocked by default; set HANA_ALLOW_INSERT, HANA_ALLOW_UPDATE, HANA_AL
hana_query_next_pageFetch the next page of a truncated SELECT using snapshotId from a previous hana_execute_query result (same SQL and parameters; TTL HANA_QUERY_SNAPSHOT_TTL_MS).
hana_list_constraintsList primary key, unique, check, and foreign key constraints for a table (SYS.CONSTRAINTS + SYS.REFERENTIAL_CONSTRAINTS).
hana_get_table_statsReturn row count, table type, column-store flag, primary key flag, and disk size (requires MONITORING privilege for disk size) from SYS.TABLES and SYS.M_TABLE_SIZES.
hana_list_viewsList views in a schema from SYS.VIEWS. Supports prefix filter and pagination.
hana_describe_viewReturn the view definition (SQL) and column metadata from SYS.VIEWS and SYS.VIEW_COLUMNS.
hana_list_synonymsList synonyms in a schema from SYS.SYNONYMS, showing target object schema, name, and type.
hana_list_proceduresList stored procedures and their parameter counts from SYS.PROCEDURES.
hana_describe_procedureReturn parameter names, types (IN/OUT/INOUT), data types, and positions from SYS.PROCEDURE_PARAMETERS.
hana_search_columnsFind all columns matching a LIKE pattern across all tables (or within a schema). Uses SYS.TABLE_COLUMNS. Results capped at 1000.
hana_get_sample_dataFetch the first N rows from a table using SELECT TOP. Result is shaped by the same row/column/cell caps as hana_execute_query.
hana_explain_planRun EXPLAIN PLAN for a SELECT/WITH query and return operator tree from EXPLAIN_PLAN_TABLE. Only SELECT/WITH are accepted.
hana_list_foreign_keysList referential constraints (foreign keys) showing column, referenced table/column, and delete rule from SYS.REFERENTIAL_CONSTRAINTS.
hana_list_privilegesList effective privileges for a user (or CURRENT_USER if omitted) from SYS.EFFECTIVE_PRIVILEGES. Requires CATALOG READ privilege or querying own privileges.
hana_get_ddlRetrieve the DDL (CREATE statement) for a TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER, or SEQUENCE from SYS.OBJECT_DEFINITION. Requires appropriate privileges.
hana_get_column_statsRetrieve column statistics (distinct count, null count, min/max) from SYS.COLUMN_STATISTICS (cached) or via live COUNT queries (live=true). With live=true a specific column_name is required.
hana_list_functionsList scalar and table functions from SYS.FUNCTIONS. Supports prefix filter and pagination.
hana_describe_functionReturn parameter names, types, data types, and positions for a function from SYS.FUNCTION_PARAMETERS.
hana_list_calculation_viewsList calculation views from the _SYS_BIC schema (SAP BW/S4 analytical views). Supports prefix filter and pagination.
hana_get_session_infoReturn CURRENT_USER, CURRENT_SCHEMA, connected database name, SYSTEM_ID, and HANA version from DUMMY and M_DATABASE.
hana_search_tablesFind all tables matching a LIKE pattern across all schemas (or within a specific schema). Uses SYS.TABLES. Results capped at 2000.
hana_get_expensive_queriesReturn the most expensive statements from M_EXPENSIVE_STATEMENTS ordered by duration. Requires MONITORING privilege.
hana_get_dependenciesShow what an object depends on or what depends on it, from SYS.OBJECT_DEPENDENCIES. Capped at 200 rows.
hana_get_partition_infoReturn partition metadata (type, level, record count, loaded state) from SYS.TABLE_PARTITIONS. Returns empty result for unpartitioned tables.
hana_list_sequencesList sequences from SYS.SEQUENCES, showing start, min, max, increment, cycle, and cache settings.
Hana MCP Server is an open-source mcp server by HatriGt, written mainly in JavaScript. SAP HANA MCP server — Enterprise Model Context Protocol server for SAP HANA. Use with Claude Code, VS Code. npm: hana-mcp-server
At a glance
- Stars
- 74
- Forks
- 30
- Language
- JavaScript
- License
- MIT
- Created
- Mar 2025
- Last update
- Oct 7, 2026
- Type
- MCP Server
- Price
- Free
Topics
Questions about Hana MCP Server
What is Hana MCP Server?
SAP HANA MCP server — Enterprise Model Context Protocol server for SAP HANA. Use with Claude Code, VS Code. npm: hana-mcp-server
Who maintains Hana MCP Server?
Hana MCP Server is maintained by HatriGt on GitHub (HatriGt/hana-mcp-server). AgenticMart lists it from public repository data.
Is Hana MCP Server safe to use?
AgenticMart scanned Hana MCP Server on Nov 5, 2026 with automated checks for hidden code, known-malicious packages, leaked secrets and vulnerable dependencies. The result covers one commit under our scan policy, so review what access you give it and check any advisories shown here.
What license does Hana MCP Server use?
It is published under the MIT license.
Hana MCP Server alternatives
View more →Similar mcp servers in Cloud Infrastructure, ranked by GitHub stars. Compare licence, recent activity and scan status before you choose.
| Name | Stars | Licence | Last updated | Scan |
|---|---|---|---|---|
| Hana MCP Server (this page) HatriGt | 74 | MIT | Oct 7, 2026 | Scanned, no flagged issues |
| TREK liketrek | 15k | AGPL-3.0 | Nov 1, 2026 | Scanned, no flagged issues |
| MCP awslabs | 9.9k | Apache-2.0 | Oct 31, 2026 | Scanned, no flagged issues |
| MCP Context Forge IBM | 4.7k | Apache-2.0 | Oct 30, 2026 | Scanned, no flagged issues |
| Mcpo open-webui | 4.4k | MIT | May 17, 2026 | Scanned, no flagged issues |
| Lean Ctx yvgude | 3.9k | Apache-2.0 | Oct 31, 2026 | Scanned, no flagged issues |