skilld
All skills
secondsky avatar

/sap-hana-cli

@620a19a
by Eddiesecondsky/sap-skills456 stars
120

Assists with SAP HANA Developer CLI (hana-cli) for database development and administration. Use when: installing hana-cli, connecting to SAP HANA databases, inspecting database objects (tables, views, procedures, functions), managing HDI containers, executing SQL queries, converting metadata to CDS/EDMX/OpenAPI formats, managing SAP HANA Cloud instances, working with BTP CLI integration, or troubleshooting hana-cli commands. Covers: 91 commands, 17+ output formats, HDI container management, cloud operations.

Ask your Agent

Use this Skill: https://skilld.dev/gh/secondsky/sap-skills/sap-hana-cli

This session only. Nothing lands on disk.

README.md

≈1.5k tokens on demand. Your agent reads this file only when SKILL.md points to it.

SAP HANA CLI Skill

A comprehensive Claude Code skill for the SAP HANA Developer Command Line Interface (hana-cli).

Overview

This skill provides guidance for using the hana-cli npm package - a developer-centric CLI tool for SAP HANA database development. It covers all 91 commands, 17+ output formats, HDI container management, and cloud operations.

Source Repository: https://github.com/SAP-samples/hana-developer-cli-tool-example

Capability Index

Capability Status
Commands 2: /hana-connect-check, /hana-inspect-object
Agents 1: hana-database-advisor
Hooks No
MCP Yes: .mcp.json
LSP No
Source Freshness last_verified: 2025-11-26; hana-cli and hana-client package evidence tracked in audit report.
Verification npm run validate; live database checks pending unless a safe connection is provided.

Keywords

Tool & Package Names

  • hana-cli
  • sap-hana-cli
  • hana developer cli
  • hana command line
  • hana developer command line interface
  • npm hana-cli
  • hana-cli install
  • hana-cli commands

Installation & Setup

  • npm install hana-cli
  • hana-cli install
  • hana-cli setup
  • hana-cli connect
  • hana-cli connection
  • hana-cli default-env
  • hana-cli default-env.json
  • hana-cli credentials
  • hana-cli service key
  • connectViaServiceKey

Database Operations

  • hana-cli tables
  • hana-cli views
  • hana-cli procedures
  • hana-cli functions
  • hana-cli indexes
  • hana-cli schemas
  • hana-cli sequences
  • hana-cli synonyms
  • hana-cli triggers
  • hana-cli objects
  • hana-cli dataTypes

Inspection Commands

  • hana-cli inspectTable
  • hana-cli inspectView
  • hana-cli inspectProcedure
  • hana-cli inspectFunction
  • hana-cli inspectIndex
  • hana-cli inspectTrigger
  • hana-cli inspectUser
  • hana inspect table
  • table metadata hana
  • view definition hana

Query Execution

  • hana-cli querySimple
  • hana-cli callProcedure
  • hana-cli hdbsql
  • hana sql query
  • execute sql hana
  • call procedure hana
  • hana stored procedure

HDI Container Management

  • hana-cli containers
  • hana-cli createContainer
  • hana-cli dropContainer
  • hana-cli activateHDI
  • hana-cli adminHDI
  • hana-cli createContainerUsers
  • hdi container
  • hdi container management
  • hana deployment infrastructure
  • hdi activation
  • hdi admin

Format Conversion

  • hana to cds
  • hana to json
  • hana to yaml
  • hana to edmx
  • hana to openapi
  • hana to graphql
  • hana to sql
  • hana to hdbtable
  • hana-cli massConvert
  • convert table to cds
  • table to openapi
  • database to cds

Output Formats

  • hana-cli output json
  • hana-cli output cds
  • hana-cli output edmx
  • hana-cli output yaml
  • hana-cli output csv
  • hana-cli output excel
  • hana-cli output graphql
  • hana-cli output openapi

Cloud & BTP

  • hana cloud cli
  • sap hana cloud
  • hana-cli hanaCloudInstances
  • hana-cli hanaCloudStart
  • hana-cli hanaCloudStop
  • hana-cli btp
  • btp cli hana
  • hana cloud start stop
  • hana cloud instance management

Security & Connection

  • hana-cli ssl
  • hana-cli encrypt
  • hana-cli trustStore
  • hana connection security
  • hana ssl connection
  • cds bind hana
  • .cdsrc-private.json
  • hana service key

System Information

  • hana-cli systemInfo
  • hana-cli hostInformation
  • hana-cli version
  • hana-cli status
  • hana system information
  • hana database version

Troubleshooting

  • hana-cli error
  • hana-cli privilege error
  • hana-cli connection failed
  • hana cli not working
  • hana-cli troubleshoot
  • hana permission error

Development Tools

  • hana-cli cds
  • hana-cli openDBExplorer
  • hana-cli openBAS
  • hana database explorer
  • business application studio hana

Mass Operations

  • hana-cli massConvert
  • hana-cli massRename
  • hana-cli massUsers
  • batch convert hana
  • mass convert cds

Technologies

  • SAP HANA
  • SAP HANA Cloud
  • SAP BTP
  • SAP CAP
  • Cloud Foundry
  • HDI
  • HANA Deployment Infrastructure
  • OData
  • GraphQL
  • CDS
  • Cloud Application Programming Model

Skill Structure

sap-hana-cli/
├── SKILL.md                           # Main skill instructions
├── README.md                          # This file (keywords)
├── references/
│   ├── command-reference.md           # All 91 commands
│   ├── connection-security.md         # Connection & security
│   ├── hdi-management.md              # HDI container ops
│   ├── output-formats.md              # 17+ formats
│   └── cloud-operations.md            # BTP & cloud commands
└── templates/
    ├── default-env.json               # Connection template
    └── cdsrc-private.json             # CDS bind template

When to Use This Skill

This skill activates when users:

  • Ask about hana-cli installation or setup
  • Need to connect to SAP HANA databases
  • Want to inspect database objects (tables, views, procedures)
  • Need to convert metadata to CDS, EDMX, OpenAPI formats
  • Work with HDI containers
  • Manage SAP HANA Cloud instances
  • Execute SQL queries via CLI
  • Troubleshoot hana-cli issues
  • Need output format options

Version Information

Component Version
hana-cli 3.202405.1
Node.js Required ≥20.19.0
@sap/cds 9.4.4
Skill Version 1.1.0

Resources

License

GPL-3.0 License

Last Updated: 2025-11-26

Source: SKILL.md on GitHub

Third-party checks

1 warning16d5 checks · Risk SAFE
  • Gen Agent Trust Hub16d

    The skill provides comprehensive documentation and MCP integration for the SAP HANA Developer CLI. It follow security best practices for credential management by advising the use of environment variables and gitignore for configuration files. All external downloads and package installations refer to official SAP tools and standard development utilities.

  • Socket16d

    No alerts

  • Snyk16d

    Risk: LOW · No issues

  • Runlayer6mo

    4/17 files flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Provenance

Signed by skilld at 620a19a. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 weeks ago.

Activeupdated 2 months ago

Capability

Other metadata
metadata
{
  "maintainer": "Eduard Jiglau",
  "maintainer_email": "hello@sap-ai-skills.com",
  "website": "https://sap-ai-skills.com",
  "version": "2.4.1",
  "last_verified": "2025-11-26"
}

README badge

README badge for secondsky/sap-skills/sap-hana-cli