SAP HANA CLI: MCP for working with SAP HANA
SAP HANA CLI
A SAP HANA developer CLI with an MCP server: an agent works with the database and HDI containers through core tools
- 115 ★ on the repository
- Last commit
Broad access
Why this level
- The agent runs any of 186 commands against the HANA database, including data and schema changes, with the connected user's rights
- The database connection string is kept in the project environment
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add mcp/sap-hana-cliDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewBroad accessThe tool can change data, run commands or handle secrets.
- The agent runs any of 186 commands against the HANA database, including data and schema changes, with the connected user's rights
- The database connection string is kept in the project environment
This is third-party code. Review the repository files before installing.
What it does
hana-cli is a sample developer command-line tool for SAP HANA that SAP-samples ships as an npm package. It is for people who develop for HANA outside SAP tools, for example in VS Code, with a local HANA Express, a remote database or in the cloud: BTP, HANA Cloud, Business Application Studio, Google Cloud Shell. It has 20+ command groups, a web interface on port 3010 and a REST API. The package includes the MCP server `hana-cli-mcp`. It uses progressive discovery: at the start the agent gets about 22 core tools and the rest are promoted on demand. The `hana_execute` router calls any of 183+ commands by name, 186 in total. There are command hints, ready multi-step workflows, examples and access to 279 documentation pages. The `--full` mode exposes every tool at once. You can connect the server without installing: `npx -y -p hana-cli hana-cli-mcp`. If hana-cli is already installed, `hana-cli mcp` configures Claude Desktop, Claude Code and Cursor by itself and `hana-cli mcp-status` shows the state. VS Code has the SAP HANA CLI MCP Server extension and Claude Code has a separate plugin.
Who it is for. SAP HANA developers who work in VS Code or cloud shells and want to drive the database, schemas and HDI containers through Claude, Cursor or Copilot.
Good fit when
- You need to explore a HANA schema and find tables and views without writing queries by hand
- The agent must check HDI container and BTP service state from chat
- You develop for HANA in VS Code and want database commands invoked in plain words
- You want to set up MCP once for Claude Desktop, Claude Code and Cursor
- You want to see first what the installation would change with `hana-cli mcp --dry-run`
Not a fit when
- You have no SAP HANA database or access to one: the server manages only it and SAP services
- You need a production tool: the project is a sample from SAP-samples and is not a supported SAP product
- The agent cannot be trusted with database changes unattended: restrict the database user's rights up front
Example request
Show the schemas in my HANA database, find tables named orders and list their columns.MCP
- Transport
- stdio
- Authentication
- not required
Limitations
The project is published as a sample in the SAP-samples organization and is not a supported SAP product. Version 4.x brought big changes: a move to Express 5 and new database connection handling. If problems appear the author advises rolling back to 3.202601.0 with `npm install -g hana-cli@3.202601.0`.
The server can run any of the 186 commands, including those that change data, so the rights of the connected database user decide what the agent can do. It needs Node.js, access to HANA and connection parameters.
The documentation is large and lives in `docs/`; MCP installation details are in `docs/03-features/mcp-integration.md` and `mcp-server/README.md`.
How to disable. Run `hana-cli mcp-status` to see where the server is registered and delete the `hana-cli` entry from the client configuration. A global package is removed with `npm uninstall -g hana-cli`.
FAQ
What is the fastest way to connect?
If hana-cli is installed, run `hana-cli mcp` and it finds the clients and configures them. Without installing, use `npx -y -p hana-cli hana-cli-mcp`.
What does hana-cli mcp --dry-run show?
It shows what would be written to client configs and changes nothing. A specific client is chosen with `--client`, for example `--client cursor`.
How many tools does the server have?
About 22 core tools at start and 186 in total. The `hana_execute` router calls any command by name, and `--full` exposes every tool at once.
Is there a VS Code extension and a Claude Code plugin?
Yes. The extension is called SAP HANA CLI MCP Server and installs with `code --install-extension SAPOSS.hana-cli-mcp`. The plugin installs with `/plugin install https://github.com/SAP-samples/hana-cli-claude-plugin`.
Where is the server published?
The server is listed in the official MCP registry as `io.github.SAP-samples/hana-cli`, the npm package is hana-cli and the server executable is hana-cli-mcp.
Discussion
No questions or reviews yet.
Related
MCP serversMCP server for SAP HANA and HANA Cloud: schema browsing, SQL with row caps and 34 tools, with writes blocked by default
MCP server for SAP BW/4HANA and BW 7.5 on HANA: an agent reads and changes modeling objects, runs queries and watches data loads.
One MCP server for SQLite, SQL Server, PostgreSQL and MySQL: read and change data, edit schemas and export to CSV and JSON
The Byaan MCP server lets Claude Code and Cursor put questions to your databases and returns queries with read-only results.
An MCP server and shs CLI for Apache Spark History Server: an agent investigates Spark jobs, stages and failures in plain words
A Python MCP server for MySQL: listing tables, reading data, running SQL and inspecting schema through a controlled interface
README in short
The README presents hana-cli as a sample command-line tool for SAP HANA with VitePress documentation and diagrams of environments and install routes. The MCP section explains progressive tool discovery, the router and integration with Claude Desktop, VS Code and Cursor.