OfficialVerified

Hana Developer CLI Tool Example MCP Server

SAP HANA database operations for local development environments and IDEs.

Data last scanned today · Reviewed today

36 2 dangerous tools46 tools★ 111JavaScriptApache-2.0

Overview

This tool provides a command-line interface and MCP implementation for developers working with SAP HANA databases in non-SAP environments like VSCode. It simplifies complex database tasks by grouping common commands, utilizing standard default-env.json files for remote or local HANA connectivity. Version 4.x features significant architectural updates, including an Express 5 migration and refactored database connection handling. It offers over 20 specific commands and maintains extensive test coverage, with documentation generated via VitePress.

Our verdict

This repository carries a high-risk profile with a security score of 43/100, primarily because the authentication methods and read-only mode capabilities remain unreviewed. As a community-maintained sample rather than an official vendor-supported product, users should exercise caution in production environments. Developers should strictly adhere to the provided documentation and report environment-specific issues directly via the GitHub tracker.

Supports over 20 distinct database management commands
Maintains 85 percent or higher test coverage
Optimized for 60-77 percent faster CLI startup performance
Licensed under the permissive Apache-2.0 open source license

Authentication methods have not undergone security review
Read-only mode status is currently unverified
Not maintained by official vendor organization
Recent major architectural changes may introduce environment-specific instability

Setup

Claude Desktop

{
  "mcpServers": {
    "hana-developer-cli-tool-example": {
      "args": [
        "-y",
        "hana-cli"
      ],
      "command": "npx"
    }
  }
}

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows), then restart Claude Desktop. Some servers require API keys or tokens as environment variables — check the project's README and add an "env" object if needed.

No read-only mode — running this grants full read/write access.
No built-in authentication — anyone with access to this config can invoke every tool it exposes.

Tools

Tool	Description	Risk
views	Get a list of all views in the current schema or container.	low
view	Inspect a view to see the columns and their data types.	low
btp	Display the current BTP target information including global account, directory, and subaccount if configured.	low
hana_execute	Router tool that dispatches any of the 183+ available hana-cli commands by name.	high
massGrant	Batch grant permissions on database objects.	medium
massUpdate	Batch update database object records.	medium
massDelete	Batch delete database object records.	high
massExport	Batch export database objects.	low
tables	List all tables in the specified schema.	low
schemas	List all schemas in the database.	low

Compatibility

Client	Local	Docker	Remote	Read-only
ChatGPT
Claude Desktop
Cursor
VS Code
Windsurf

Frequently asked questions

›What are the system requirements to run the HANA Developer CLI?

You must have Node.js installed. Version 22 or later is required, though Node.js 24 (LTS) is highly recommended.

›Where can I run this CLI tool?

The tool can run anywhere with a Node.js runtime, including local machines like VSCode, or cloud environments such as SAP Business Application Studio, Google Cloud Shell, and AWS Cloud9.

›How do I roll back if I encounter issues with the latest version?

If you experience problems with the 4.x release, you can revert to the stable version 3.202601.0 by running 'npm install -g hana-cli@3.202601.0'.

›How is database connectivity managed in this tool?

The tool utilizes a default-env.json file, which is standard for local development, to manage connections to both remote SAP HANA databases and local SAP HANA express edition instances.

›Does this tool replace the standard hdbsql console?

No, it is not intended to replace the hdbsql tool as a generic SQL console. It focuses on simplifying and grouping common, complex tasks instead.