Show the HANA database configuration

Test connection to HANA database

List schemas in the HANA database with optional prefix filter and pagination (HANA_LIST_DEFAULT_LIMIT / offset).

Show all HANA-related environment variables (for debugging)

List tables in a schema with optional name prefix and pagination (HANA_LIST_DEFAULT_LIMIT / offset).

Describe the structure of a specific table

Return 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).

List all indexes for a specific table

Describe the structure of a specific index

Execute 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.

Fetch 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).

List primary key, unique, check, and foreign key constraints for a table (SYS.CONSTRAINTS + SYS.REFERENTIAL_CONSTRAINTS).

Return 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.

List views in a schema from SYS.VIEWS. Supports prefix filter and pagination.

Return the view definition (SQL) and column metadata from SYS.VIEWS and SYS.VIEW_COLUMNS.

List synonyms in a schema from SYS.SYNONYMS, showing target object schema, name, and type.

List stored procedures and their parameter counts from SYS.PROCEDURES.

Return parameter names, types (IN/OUT/INOUT), data types, and positions from SYS.PROCEDURE_PARAMETERS.

Find all columns matching a LIKE pattern across all tables (or within a schema). Uses SYS.TABLE_COLUMNS. Results capped at 1000.

Fetch the first N rows from a table using SELECT TOP. Result is shaped by the same row/column/cell caps as hana_execute_query.

Run EXPLAIN PLAN for a SELECT/WITH query and return operator tree from EXPLAIN_PLAN_TABLE. Only SELECT/WITH are accepted.

List referential constraints (foreign keys) showing column, referenced table/column, and delete rule from SYS.REFERENTIAL_CONSTRAINTS.

List effective privileges for a user (or CURRENT_USER if omitted) from SYS.EFFECTIVE_PRIVILEGES. Requires CATALOG READ privilege or querying own privileges.

Retrieve the DDL (CREATE statement) for a TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER, or SEQUENCE from SYS.OBJECT_DEFINITION. Requires appropriate privileges.

Retrieve 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.

List scalar and table functions from SYS.FUNCTIONS. Supports prefix filter and pagination.

Return parameter names, types, data types, and positions for a function from SYS.FUNCTION_PARAMETERS.

List calculation views from the _SYS_BIC schema (SAP BW/S4 analytical views). Supports prefix filter and pagination.

Return CURRENT_USER, CURRENT_SCHEMA, connected database name, SYSTEM_ID, and HANA version from DUMMY and M_DATABASE.

Find all tables matching a LIKE pattern across all schemas (or within a specific schema). Uses SYS.TABLES. Results capped at 2000.

Return the most expensive statements from M_EXPENSIVE_STATEMENTS ordered by duration. Requires MONITORING privilege.

Show what an object depends on or what depends on it, from SYS.OBJECT_DEPENDENCIES. Capped at 200 rows.

Return partition metadata (type, level, record count, loaded state) from SYS.TABLE_PARTITIONS. Returns empty result for unpartitioned tables.

List sequences from SYS.SEQUENCES, showing start, min, max, increment, cycle, and cache settings.

Save a resolved incident or finding to the local Markdown knowledge base (requires active knowledge-base license feature).

Read the full Markdown content of a local or remote knowledge base case by filename. Available even in offline mode when the license is expired.

Search the local Markdown knowledge base for previous cases (requires knowledge-base license feature).

Regenerate the docs/kb/index.md file from the saved cases (requires knowledge-base license feature).

Show current license status, hardware ID, plan and expiration.

Check if a newer version of the HANA MCP client is available from the vendor license server.

Download and install the latest HANA MCP client update. Preserves local KB cases and configuration.

Run a read-only diagnostic snapshot against the HANA database: database info, services, memory metrics, top tables by size and blocked-transaction count.

Take a memory snapshot of the HANA indexserver and compare usage against allocation limits. Optionally append the result to a CSV history file.

Live performance indicators: open transactions, top SQL plan cache queries by total time and frequency, long connections, column-store delta sizes and blocked transactions.