Sap Hana CLI

What it does

When your agent uses it

• : installing hana-cli
• Connecting to SAP HANA databases
• Inspecting database objects (tables
• Managing HDI containers

Example prompts

• “Use the sap-hana-cli skill to assist with SAP HANA Developer CLI (hana-cli) for database development and administration”
• “/sap-hana-cli”

Requirements

• Node.js

Workflow steps

2 steps, taken from the step headings in SKILL.md.

1. 1Environment Variables
2. 2Connection Types

What it can do on your machine

Read from SKILL.md and the folder at commit 652a861. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • npm

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  Links to these hosts (documentation or services it may open):

  • github.com
  • youtu.be
  • npmjs.com
  • help.sap.com
  • cap.cloud.sap

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names these keys or tokens, usually read from environment variables:

  • HANA_PASSWORD

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Sap Hana CLI loads about 3.1k tokens when it runs, and up to ~22k if it reads all its reference files. Until then it costs about 132 tokens; SKILL.md has 929 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~132

When it runs · the whole SKILL.md, loaded when a task matches

~3.1k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~22k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

• NoteMentions a .env fileSKILL.md:83

  (add to ~/.zshrc, ~/.bashrc, or project .env):

• NoteMentions a .env fileSKILL.md:239

  3. `.env` file with VCAP_SERVICES

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from secondsky/sap-skills at commit 652a861, republished under its GPL-3.0 licence (© secondsky). 929 words, ~3,091 tokens.

name

sap-hana-cli

description

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.

license

GPL-3.0

metadata.maintainer

Eduard Jiglau

metadata.maintainer_email

hello@sap-ai-skills.com

metadata.website

https://sap-ai-skills.com

metadata.version

2.4.1

metadata.last_verified

2025-11-26

# Install globally via npm (recommended)
npm install -g hana-cli

# Verify installation
hana-cli version

# Interactive connection setup
hana-cli connect

# Or specify connection directly
hana-cli connect -n "hostname:port" -u DBUSER -p PASSWORD --save

# Using service key (HANA Cloud)
hana-cli connectViaServiceKey

export HANA_HOST="your-hana-host.hanacloud.ondemand.com"
export HANA_PORT="443"
export HANA_USER="DBADMIN"
export HANA_PASSWORD="your-password"
export HANA_ENCRYPT="true"  # Optional, defaults to true
export HANA_DATABASE=""     # Optional, for MDC tenant
export HANA_CONNECTION_TYPE="single-container"  # Optional

# 1. Use MCP to explore (natural language)
"Show me all tables in the PRODUCTS schema"

# 2. Use MCP to understand structure
"Describe the PRODUCTS.INVENTORY table"

# 3. Use CLI for format conversion (precise output)
hana-cli inspectTable -t INVENTORY -s PRODUCTS -o cds

# 4. Use CLI for HDI operations
hana-cli createContainer -c MY_CONTAINER

# Inspect table structure
hana-cli inspectTable -s MYSCHEMA -t MYTABLE

# Convert to CDS format
hana-cli inspectTable -s MYSCHEMA -t MYTABLE -o cds

# Convert all objects in schema to CDS
hana-cli massConvert -s MYSCHEMA

# Run query and export to JSON
hana-cli querySimple -q "SELECT * FROM MYTABLE" -o json

# Export to Excel file
hana-cli querySimple -q "SELECT * FROM MYTABLE" -o excel -f ./output -n report

# List all containers
hana-cli containers

# Create new container
hana-cli createContainer -c MY_CONTAINER -g MY_GROUP

# Create container users
hana-cli createContainerUsers -c MY_CONTAINER

# Check current connection status
hana-cli status

# Test with explicit credentials
hana-cli connect -n "host:443" -u USER -p PASS --encrypt true

# Use SSL trust store
hana-cli connect --trustStore /path/to/certificate.pem

# Diagnose privilege errors
hana-cli privilegeError

# View current user info
hana-cli inspectUser

© secondsky, GPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 16 other files (references) in plugins/sap-hana-cli/skills/sap-hana-cli of secondsky/sap-skills.

• SKILL.md
• README.md
• agents/openai.yaml
• references/abap-programming.md
• references/cloud-operations.md
• references/command-reference.md
• references/connection-security.md
• references/db-inspection.md
• references/development-environment.md
• references/hdi-management.md
• references/mass-operations.md
• references/output-formats.md
• references/system-admin.md
• references/troubleshooting.md
• references/web-ui.md
• templates/cdsrc-private.json
• templates/default-env.json

Open the folder on GitHubat commit 652a861