skills.rest
dherbe-digital
dherbe-digitalCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/dherbe-digital/nova-skills-collection --skill sap-hana-cli
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
dherbe-digitaldherbe-digital

sap-hana-ml

Build machine learning solutions in SAP HANA using the hana-ml library.

Community
Advanced
dherbe-digitaldherbe-digital

sap-btp-developer-guide

Guide SAP BTP development patterns across CAP and ABAP Cloud.

Community
Basic
DayronDLRDayronDLR
3

sap-btp-developer-guide

Guide development, deployment, and operations of applications on SAP BTP.

Community
Advanced
DayronDLRDayronDLR
3

sap-sqlscript

Validate and optimize SQLScript code for SAP HANA development.

Community
Advanced