Hana MCP Server

by HatriGt• 74•• Scanned•Claim this listing•Request removal
Cloud Infrastructureabap mcpclaudeclaude codeenterprisehana

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 Code · Terminal
claude mcp add hana-mcp-server -- npx -y hana-mcp-server
Claude Desktop · claude_desktop_config.json
{
  "mcpServers": {
    "hana-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "hana-mcp-server"
      ]
    }
  }
}
Cursor · .cursor/mcp.json
{
  "mcpServers": {
    "hana-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "hana-mcp-server"
      ]
    }
  }
}
VS Code · Terminal
code --add-mcp '{"name":"hana-mcp-server","command":"npx","args":["-y","hana-mcp-server"]}'

What Hana MCP Server can touch

  • Run shell commandsFound in the code by our scan
  • Run dynamic codeNot seen in this scan
  • Read or write filesNot seen in this scan
  • Read environment and secretsListed as a tool: hana_show_env_vars
  • Control a web browserNot seen in this scan
  • Connect to databasesListed as a tool: hana_list_tables
  • Read or send messagesNot seen in this scan
  • Touch money or tradingNot seen in this scan
  • 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

  1. Use a role with only the permissions it needs, never an admin key.
  2. Pin the version you reviewed instead of always installing the latest release.
  3. 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_config

    Show the HANA database configuration

  • hana_test_connection

    Test connection to HANA database

  • hana_list_schemas

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

  • hana_show_env_vars

    Show all HANA-related environment variables (for debugging)

  • hana_list_tables

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

  • hana_describe_table

    Describe the structure of a specific table

  • hana_explain_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).

  • hana_list_indexes

    List all indexes for a specific table

  • hana_describe_index

    Describe the structure of a specific index

  • hana_execute_query

    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_AL

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

  • hana_list_constraints

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

  • hana_get_table_stats

    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.

  • hana_list_views

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

  • hana_describe_view

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

  • hana_list_synonyms

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

  • hana_list_procedures

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

  • hana_describe_procedure

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

  • hana_search_columns

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

  • hana_get_sample_data

    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.

  • hana_explain_plan

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

  • hana_list_foreign_keys

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

  • hana_list_privileges

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

  • hana_get_ddl

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

  • hana_get_column_stats

    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.

  • hana_list_functions

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

  • hana_describe_function

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

  • hana_list_calculation_views

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

  • hana_get_session_info

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

  • hana_search_tables

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

  • hana_get_expensive_queries

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

  • hana_get_dependencies

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

  • hana_get_partition_info

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

  • hana_list_sequences

    List 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

abap-mcpclaudeclaude-codeenterprisehanahana-cloudhana-mcpmcpmcp-servermodel-context-protocolsapsap-hanasap-mcpserver

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.

NameStarsLicenceLast updatedScan
Hana MCP Server (this page)
HatriGt
74MITOct 7, 2026Scanned, no flagged issues
TREK
liketrek
15kAGPL-3.0Nov 1, 2026Scanned, no flagged issues
MCP
awslabs
9.9kApache-2.0Oct 31, 2026Scanned, no flagged issues
MCP Context Forge
IBM
4.7kApache-2.0Oct 30, 2026Scanned, no flagged issues
Mcpo
open-webui
4.4kMITMay 17, 2026Scanned, no flagged issues
Lean Ctx
yvgude
3.9kApache-2.0Oct 31, 2026Scanned, no flagged issues