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.

referencessystem-admin.md

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

SAP HANA CLI - System Administration Reference

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

Commands for system monitoring, configuration, and administration.

System Information Commands

systemInfo

Display comprehensive system details.

Aliases: si, sysinfo

hana-cli systemInfo

UI Alternative: systemInfoUI

Queries:

  • SELECT * FROM M_SYSTEM_OVERVIEW
  • SELECT * FROM M_SERVICES

Output Modes:

Mode Description
Basic DB user, HANA version, overview, services
Environment Connection options, HDI credentials
DBX DB type, credentials for Database Explorer

hostInformation

Display host details.

hana-cli hostInformation

version

Display hana-cli version.

hana-cli version

Database Features

features

List SAP HANA database features.

Aliases: fe, Features

hana-cli features

Query: SELECT * FROM M_FEATURES

UI Alternative: featuresUI

featureUsage

Display feature usage metrics.

hana-cli featureUsage

UI Alternative: featureUsageUI

Storage & Resources

dataVolumes

Display data volume information.

hana-cli dataVolumes

disks

Display disk information.

hana-cli disks

ports

List database port assignments.

hana-cli ports

reclaim

Reclaim database resources.

Aliases: re

hana-cli reclaim

Operations Executed:

  1. ALTER SYSTEM RECLAIM LOB SPACE - Recover LOB storage
  2. ALTER SYSTEM RECLAIM LOG - Free transaction log space
  3. ALTER SYSTEM RECLAIM DATAVOLUME 105 DEFRAGMENT - Defragment storage

Configuration Files

iniFiles

List INI configuration files.

Aliases: if, ini

hana-cli iniFiles

Query: SELECT * FROM M_INIFILES

iniContents

Display INI file contents.

hana-cli iniContents [file]

Query: SELECT * FROM M_INIFILE_CONTENTS

Tracing & Debugging

traces

List trace files.

Aliases: tf, Traces

hana-cli traces

Query: SELECT * FROM M_TRACEFILES

traceContents

Display trace file contents.

hana-cli traceContents [trace]

Data Types

dataTypes

Display HANA data type specifications.

hana-cli dataTypes

Query: SELECT TYPE_NAME, COLUMN_SIZE, CREATE_PARAMS FROM DATA_TYPES

UI Alternative: dataTypesUI

System Tables Reference

Table Purpose Command
M_SYSTEM_OVERVIEW System overview systemInfo
M_SERVICES Running services systemInfo
M_FEATURES Available features features
M_TRACEFILES Trace file list traces
M_INIFILES INI file list iniFiles
M_INIFILE_CONTENTS INI content iniContents
DATA_TYPES Type definitions dataTypes

Common Workflows

Health Check

# System overview
hana-cli systemInfo

# Check features
hana-cli features

# Review configuration
hana-cli iniFiles

Performance Investigation

# View trace files
hana-cli traces

# Check specific trace
hana-cli traceContents [tracefile]

# Review feature usage
hana-cli featureUsage

Storage Management

# Check volumes
hana-cli dataVolumes

# Check disks
hana-cli disks

# Reclaim space
hana-cli reclaim

Output Examples

systemInfo Output

Database User: DBADMIN
HANA Version: 2.00.059.00

System Overview:
┌────────────────────┬─────────────────────────┐
│ NAME               │ VALUE                   │
├────────────────────┼─────────────────────────┤
│ Database Name      │ HXE                     │
│ Database Version   │ 2.00.059.00             │
│ Start Time         │ 2025-11-22 08:00:00     │
└────────────────────┴─────────────────────────┘

features Output

┌───────────────────────────┬─────────┐
│ FEATURE_NAME              │ ENABLED │
├───────────────────────────┼─────────┤
│ Calculation Views         │ TRUE    │
│ Graph Engine              │ TRUE    │
│ Document Store            │ TRUE    │
│ Script Server             │ TRUE    │
└───────────────────────────┴─────────┘

*Reference: https://github.com/SAP-samples/hana-developer-cli-tool-example*

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