sap-hana-cli

Inspect, query, and manage SAP HANA databases using the hana-cli command-line interface.

Updated May 18, 2026
One-click install
npx skills add https://github.com/Melik1986/axon-erp-api --skill sap-hana-cli-melik1986
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sap-hana-cli
Source: https://github.com/Melik1986/axon-erp-api/tree/main/cursor/skills/sap-hana-cli
Command: npx skills add https://github.com/Melik1986/axon-erp-api --skill sap-hana-cli-melik1986

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires hana-cli, hana-mcp-server, and includes references (resource) components.

What problem does it solve? Working with SAP HANA databases outside of SAP-native tooling requires memorizing dozens of CLI commands, connection file formats, and output options. This Skill provides structured guidance for the hana-cli npm package so you can connect, inspect, convert, and administer HANA databases without digging through documentation. ## Core Features & Use Cases - Database Object Inspection: Inspect tables, views, procedures, functions, indexes, and triggers, then convert metadata to 17+ formats including CDS, EDMX, OpenAPI, GraphQL, and SQL DDL. - HDI Container Management: Create, list, and drop HDI containers and groups, and generate container access users for development workflows. - Cloud & BTP Operations: List, start, and stop SAP HANA Cloud instances and integrate with the BTP CLI for cost management. - MCP Integration: Use natural language queries through the hana-mcp-server for exploratory analysis alongside scriptable CLI commands. - Use Case: You need to migrate an existing HANA schema into a CAP project. Use this Skill to inspect each table and run massConvert to generate CDS entity definitions for the entire schema in one step. ## Quick Start Ask the assistant to connect to your SAP HANA database with hana-cli and inspect a specific table, for example by requesting to show the structure of a table in your schema and export it as CDS.

Frequently Asked Questions about sap-hana-cli

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect to a SAP HANA database with hana-cli?▼

Run hana-cli connect with the host, port, user, and password, or use hana-cli connectViaServiceKey for HANA Cloud. Credentials are resolved from default-env.json, .cdsrc-private.json via cds bind, or a file passed with --conn.

How to convert a HANA table to CDS format?▼

Use hana-cli inspectTable with the -o cds flag to output a CAP CDS entity definition for a single table. For an entire schema, run hana-cli massConvert with the schema name to batch-generate CDS files.

What output formats does hana-cli support?▼

hana-cli supports 17+ output formats including json, yaml, csv, excel, cds, hdbcds, hdbtable, sql, sqlite, postgres, edmx, openapi, and graphql. Select a format with the --output or -o option on inspection and query commands.

Does hana-cli work with SAP HANA Cloud instances?▼

Yes, hana-cli supports HANA Cloud through service key connections and dedicated commands like hanaCloudInstances, hanaCloudStart, and hanaCloudStop. SSL encryption on port 443 is required for cloud connections.

Why does hana-cli fail with an insufficient privilege error?▼

Insufficient privilege errors occur when the database user lacks required roles for the requested object or operation. Run hana-cli privilegeError with the error GUID to diagnose the missing privilege, then grant the appropriate role.

What Node.js version is required for hana-cli?▼

hana-cli requires Node.js version 20.19.0 or higher. It uses @sap/cds 9.4.4 internally, and cds bind functionality requires @sap/cds-dk version 8.9 or later.