sap-hana-cli

Guide developers through SAP HANA CLI installation, connection, and command usage.

Updated Jan 27, 2026

Search Tags:#automation #cloud #database-management #hana-cli #SAP HANA #HDI #BTP

Ready to run

npx skills add https://github.com/dherbe-digital/nova-skills-collection --skill sap-hana-cli

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sap-hana-cli
Source: https://github.com/dherbe-digital/nova-skills-collection/tree/main/plugins/sap/analytics-data/sap-hana-cli/skills/sap-hana-cli
Command: npx skills add https://github.com/dherbe-digital/nova-skills-collection --skill sap-hana-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps developers master and deploy the SAP HANA CLI (hana-cli) for database development and administration.

Core Features & Use Cases

Comprehensive command coverage: Provides guidance for using hana-cli across all 91 commands with diverse output formats.
Operational workflows: Supports installation, connection setup, object inspection (tables, views, procedures, functions), HDI container management, SQL execution, and metadata conversions (CDS/EDMX/OpenAPI).
Cloud & integration scenarios: Includes workflows for SAP HANA Cloud, BTP integration, and CAP/XS environments; enables troubleshooting and optimization in real-world projects.

Quick Start

Install SAP HANA CLI globally: npm install -g hana-cli
Verify installation: hana-cli version
Connect to a SAP HANA instance: hana-cli connect
Explore available commands: hana-cli help

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 an SAP HANA instance and inspect database objects?▼

To connect to an SAP HANA instance, use the hana-cli connect command, then inspect database objects like tables, views, procedures, and functions using targeted hana-cli commands for object inspection.

What is the best way to manage HDI containers in SAP HANA Cloud?▼

Managing HDI containers in SAP HANA Cloud is handled through specific hana-cli commands designed for HDI container management, supporting deployment, administration, and troubleshooting workflows.

Does the SAP HANA CLI support metadata conversion for CDS, EDMX, and OpenAPI formats?▼

Yes, the SAP HANA CLI supports metadata conversions, allowing developers to transform schemas between CDS, EDMX, and OpenAPI formats directly through dedicated conversion commands.

How do I install and set up the SAP HANA CLI for BTP integration?▼

Install the SAP HANA CLI globally using npm install -g hana-cli, verify with hana-cli version, and use the 91 available commands to execute cloud operations and BTP integration workflows.

Can I execute raw SQL and format the output using hana-cli?▼

Yes, you can execute raw SQL using the hana-cli SQL execution commands, which support over 17 different output formats to display query results for database administration and development.

What are the limitations of using hana-cli for SAP HANA administration?▼

The hana-cli supports 91 commands across SAP HANA Cloud, BTP, and CAP/XS environments for database development and administration, though complex troubleshooting may require deeper platform integration.