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.

referencesdb-inspection.md

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

SAP HANA CLI - Database Inspection Functions

Source: https://github.com/SAP-samples/hana-developer-cli-tool-example/blob/main/utils/dbInspect.js

Detailed documentation of the database inspection functions used by hana-cli.

Version & Metadata Functions

getHANAVersion(db)

Returns HANA version information.

// Returns: { version: "2.00.045", versionMajor: 2 }

System Table: M_DATABASE

isCalculationView(db, schema, viewId)

Checks if a view is a Calculation View.

System Table: _SYS_BI.BIMC_REPORTABLE_VIEWS

Note: HANA 2.0+ only

Table Inspection Functions

getTable(db, schema, tableId)

Returns table metadata.

Returns:

Field Description
TABLE_NAME Table name
TABLE_OID Object ID
TABLE_TYPE Table type
HAS_PRIMARY_KEY Primary key exists
UNLOAD_PRIORITY Memory priority
IS_PRELOAD Preload enabled

System Table: TABLES

getTableFields(db, tableOid)

Returns column metadata for a table.

Returns:

Field Description
COLUMN_NAME Column name
DATA_TYPE_NAME Data type
LENGTH Field length
SCALE Decimal scale
IS_NULLABLE Nullable flag
DEFAULT_VALUE Default value
POSITION Column position

System Table: TABLE_COLUMNS

getConstraints(db, object)

Returns PRIMARY KEY constraints.

View Inspection Functions

getView(db, schema, viewId)

Returns view metadata.

Returns:

Field Description
VIEW_NAME View name
VIEW_OID Object ID
COMMENTS Documentation
VIEW_TYPE View type

Note: Version-aware queries (HANA 1.0 vs 2.0+)

getViewFields(db, viewOid)

Returns view column metadata.

System Table: VIEW_COLUMNS

getViewParameters(db, viewOid)

Returns view input parameters.

System Table: VIEW_PARAMETERS

getCalcViewFields(db, schema, viewId, viewOid)

Returns Calculation View field metadata.

System Table: _SYS_BI.BIMC_DIMENSION_VIEW

Returns:

Field Description
POSITION Field position
DATA_TYPE_NAME Data type
SCALE Decimal scale
KEY_COLUMN_NAME Key indicator

getCalcViewParameters(db, schema, viewId, viewOid)

Returns Calculation View parameters.

System Table: _SYS_BI.BIMC_VARIABLE_VIEW

Returns:

Field Description
PARAMETER_NAME Parameter name
DATA_TYPE_NAME Data type
MANDATORY Required flag
DEFAULT_VALUE Default value

Procedure & Function Functions

getProcedure(db, schema, procedure)

Returns procedure metadata.

Returns:

Field Description
PROCEDURE_OID Object ID
SQL_SECURITY Security mode
INPUT_PARAMETER_COUNT Input params
OUTPUT_PARAMETER_COUNT Output params
READ_ONLY Read-only flag
IS_VALID Validity status

System Table: PROCEDURES

getProcedurePrams(db, procOid)

Returns procedure parameters.

System Table: PROCEDURE_PARAMETERS

getProcedurePramCols(db, procOid)

Returns procedure parameter columns (for table-type params).

System Table: PROCEDURE_PARAMETER_COLUMNS

getFunction(db, schema, functionName)

Returns function metadata.

Returns:

Field Description
FUNCTION_OID Object ID
SQL_SECURITY Security mode
INPUT_PARAMETER_COUNT Input params
RETURN_VALUE_COUNT Return values

System Table: FUNCTIONS

getFunctionPrams(db, funcOid)

Returns function parameters.

Returns:

Field Description
PARAMETER_NAME Parameter name
DATA_TYPE_NAME Data type
PARAMETER_TYPE IN/OUT/INOUT

System Table: FUNCTION_PARAMETERS

getFunctionPramCols(db, funcOid)

Returns function parameter columns.

Utility Functions

getDef(db, schema, Id)

Returns object creation statement.

System Procedure: GET_OBJECT_DEFINITION

getGeoColumns(db, object, field, type)

Returns SRS_ID for spatial geometry columns.

formatCDS(db, object, fields, constraints, type, schema, parent, parameters)

Formats database object as CDS entity.

Features:

  • Type mapping (HANA to CDS)
  • Name normalization
  • Constraint handling
  • Parameter support

parseSQLOptions(output, cdsSource)

Extracts extended SQL syntax via regex:

  • PARTITION clauses
  • UNLOAD PRIORITY
  • AUTO MERGE settings

System Tables Summary

Table Purpose
M_DATABASE Version info
TABLES Table metadata
TABLE_COLUMNS Column definitions
VIEWS View metadata
VIEW_COLUMNS View columns
VIEW_PARAMETERS View input params
PROCEDURES Procedure metadata
PROCEDURE_PARAMETERS Procedure params
PROCEDURE_PARAMETER_COLUMNS Table-type columns
FUNCTIONS Function metadata
FUNCTION_PARAMETERS Function params
_SYS_BI.BIMC_REPORTABLE_VIEWS Calc view detection
_SYS_BI.BIMC_DIMENSION_VIEW Calc view fields
_SYS_BI.BIMC_VARIABLE_VIEW Calc view variables

*Reference: https://github.com/SAP-samples/hana-developer-cli-tool-example/blob/main/utils/dbInspect.js*

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