All servers / Database / SAP HANA MCP server
SAP HANA MCP server
SAP HANA MCP server — Model Context Protocol server for SAP HANA and HANA Cloud. Use with Claude Code, VS Code, and other AI agents.
Tested by ConnectATDScore 78 out of 100. Tested 2026-11-19 on package version 0.3.4. Package: hana-mcp-server · source
Score breakdown
| Runs | 18 / 20 | |
|---|---|---|
| Tool descriptions | 18 / 20 | |
| Package safety | 20 / 20 | |
| Maintenance | 14 / 20 | |
| Adoption | 8 / 20 |
What we saw
- Starts and answers the MCP handshake: yes (3.1 seconds including download)
- Tools offered: 34
- Last published: 2026-07-18
- Weekly downloads (npm): 532
- License: MIT · Direct dependencies: 3
Want this server set up for your team?
ConnectATD builds AI automation and wires up MCP servers like this one. Tell us what you are trying to do.
Talk to ConnectATDTools and how they are described
Agents choose tools from these descriptions. Under each name you can see how many of its parameters are explained.
hana_show_configno parametersShow the HANA database configuration
hana_test_connectionno parametersTest connection to HANA database
hana_list_schemas3 of 3 parameters describedList schemas in the HANA database with optional prefix filter and pagination (HANA_LIST_DEFAULT_LIMIT / offset).
hana_show_env_varsno parametersShow all HANA-related environment variables (for debugging)
hana_list_tables5 of 5 parameters describedList tables in a schema with optional name prefix and pagination (HANA_LIST_DEFAULT_LIMIT / offset).
hana_describe_table3 of 3 parameters describedDescribe the structure of a specific table
hana_explain_table3 of 3 parameters describedReturn 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_indexes3 of 3 parameters describedList all indexes for a specific table
hana_describe_index4 of 4 parameters describedDescribe the structure of a specific index
hana_execute_query7 of 7 parameters describedExecute 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_ALLOW_DELETE=true individually to permit each. Use limit, offset, maxRows, includeTotal as needed. If truncated, snapshotId may be returned for hana_query_next_page.
hana_query_next_page3 of 3 parameters describedFetch 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_constraints3 of 3 parameters describedList primary key, unique, check, and foreign key constraints for a table (SYS.CONSTRAINTS + SYS.REFERENTIAL_CONSTRAINTS).
hana_get_table_stats2 of 2 parameters describedReturn 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_views4 of 4 parameters describedList views in a schema from SYS.VIEWS. Supports prefix filter and pagination.
hana_describe_view3 of 3 parameters describedReturn the view definition (SQL) and column metadata from SYS.VIEWS and SYS.VIEW_COLUMNS.
hana_list_synonyms2 of 4 parameters describedList synonyms in a schema from SYS.SYNONYMS, showing target object schema, name, and type.
hana_list_procedures2 of 4 parameters describedList stored procedures and their parameter counts from SYS.PROCEDURES.
hana_describe_procedure3 of 3 parameters describedReturn parameter names, types (IN/OUT/INOUT), data types, and positions from SYS.PROCEDURE_PARAMETERS.
hana_search_columns3 of 3 parameters describedFind all columns matching a LIKE pattern across all tables (or within a schema). Uses SYS.TABLE_COLUMNS. Results capped at 1000.
hana_get_sample_data3 of 3 parameters describedFetch 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_plan1 of 1 parameter describedRun EXPLAIN PLAN for a SELECT/WITH query and return operator tree from EXPLAIN_PLAN_TABLE. Only SELECT/WITH are accepted.
hana_list_foreign_keys3 of 3 parameters describedList referential constraints (foreign keys) showing column, referenced table/column, and delete rule from SYS.REFERENTIAL_CONSTRAINTS.
hana_list_privileges1 of 1 parameter describedList effective privileges for a user (or CURRENT_USER if omitted) from SYS.EFFECTIVE_PRIVILEGES. Requires CATALOG READ privilege or querying own privileges.
hana_get_ddl3 of 3 parameters describedRetrieve the DDL (CREATE statement) for a TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER, or SEQUENCE from SYS.OBJECT_DEFINITION. Requires appropriate privileges.
hana_get_column_stats4 of 4 parameters describedRetrieve 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_functions2 of 4 parameters describedList scalar and table functions from SYS.FUNCTIONS. Supports prefix filter and pagination.
hana_describe_function3 of 3 parameters describedReturn parameter names, types, data types, and positions for a function from SYS.FUNCTION_PARAMETERS.
hana_list_calculation_views1 of 3 parameters describedList calculation views from the _SYS_BIC schema (SAP BW/S4 analytical views). Supports prefix filter and pagination.
hana_get_session_infono parametersReturn CURRENT_USER, CURRENT_SCHEMA, connected database name, SYSTEM_ID, and HANA version from DUMMY and M_DATABASE.
hana_search_tables3 of 3 parameters describedFind all tables matching a LIKE pattern across all schemas (or within a specific schema). Uses SYS.TABLES. Results capped at 2000.
hana_get_expensive_queries1 of 1 parameter describedReturn the most expensive statements from M_EXPENSIVE_STATEMENTS ordered by duration. Requires MONITORING privilege.
hana_get_dependencies3 of 3 parameters describedShow what an object depends on or what depends on it, from SYS.OBJECT_DEPENDENCIES. Capped at 200 rows.
hana_get_partition_info2 of 2 parameters describedReturn partition metadata (type, level, record count, loaded state) from SYS.TABLE_PARTITIONS. Returns empty result for unpartitioned tables.
hana_list_sequences2 of 4 parameters describedList sequences from SYS.SEQUENCES, showing start, min, max, increment, cycle, and cache settings.
Tested in a sandbox with an empty environment: no API keys, a throwaway folder, nothing from a real account. A passing test shows the server runs and responds. It is not a security audit.