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.

referencesweb-ui.md

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

SAP HANA CLI - Web UI Reference

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

The hana-cli includes a browser-based Fiori LaunchPad interface for visual operations.

Launching the Web UI

Main UI Command

hana-cli UI

Opens a browser-based LaunchPad with all available applications.

Command-Specific UIs

Many commands have UI alternatives:

Command UI Command Purpose
tables tablesUI Browse tables visually
containers containersUI Manage HDI containers
massConvert massConvertUI Visual mass conversion
querySimple querySimpleUI Query builder interface
systemInfo systemInfoUI System dashboard
schemas schemasUI Schema browser
functions functionsUI Function browser
indexes indexesUI Index browser
dataTypes dataTypesUI Type reference
features featuresUI Feature dashboard
featureUsage featureUsageUI Usage metrics
inspectTable inspectTableUI Table inspector
changeLog changeLogUI Version history
readMe readMeUI Documentation
hanaCloudInstances hanaCloudHDIInstancesUI Cloud instances

Architecture

Technology Stack

  • Framework: SAPUI5 1.142.0
  • Shell: SAP Universal Shell (ushell)
  • Libraries:
    • sap.m - Mobile controls
    • sap.ushell - Shell container
    • sap.ui.layout - Layout components
    • sap.ui.rta - Runtime adaptation
    • sap.uxap - Object page components

Theme Support

Automatic theme detection:

  • Light mode: sap_horizon
  • Dark mode: sap_horizon_dark
// Theme detection
if (window.matchMedia('(prefers-color-scheme: dark)').matches) {
  sap.ui.getCore().applyTheme('sap_horizon_dark');
}

API Endpoints

GET /

Retrieves current prompts configuration.

// Returns JSON with current settings
{ schema: "MYSCHEMA", limit: 200, ... }

PUT /

Updates prompts configuration.

// Request body
{ schema: "NEWSCHEMA", table: "MYTABLE" }

Web Server Configuration

Default Port

Commands launch on port 3010 by default.

hana-cli cds -p 3010
hana-cli UI -p 4000  # Custom port

Port Configuration

# Specify custom port
hana-cli <command>UI -p <port>

Port range: 1-65535

Route Structure

Route Handler Purpose
/ index.js Main prompts API
/dfa dfa.js Digital Assistant routes
/docs docs.js Documentation routes
/excel excel.js Excel export
/inspect hanaInspect.js Object inspection
/list hanaList.js Object listings
/static static.js Static file serving
/ws webSocket.js WebSocket connections

Application Structure

app/
├── README.md
├── ui5.yaml
├── ui5-local.yaml
├── appconfig/
│   └── fioriSandboxConfig.json
├── dfa/
│   ├── library.js
│   ├── library-preload.js
│   └── help/
├── resources/
│   ├── index.html
│   ├── init.js
│   ├── favicon.ico
│   ├── WebAssistant.js
│   ├── common/
│   ├── inspect/
│   ├── massConvert/
│   ├── systemInfo/
│   └── tables/

Features

Interactive Prompts

The UI provides visual input for all command parameters:

  • Schema selection dropdowns
  • Table/view pickers
  • Output format selectors
  • Limit/offset controls

Real-Time Results

Results display in formatted tables with:

  • Sorting
  • Filtering
  • Pagination
  • Export options

Swagger/OpenAPI Documentation

OData and REST endpoints include Swagger UI:

# Access API documentation
http://localhost:3010/api-docs

GraphQL Endpoint

GraphQL support available at:

http://localhost:3010/graphql

Integration with External Tools

Open Database Explorer

hana-cli openDBExplorer

Opens HANA Database Explorer with current credentials.

Cloud Region Routing:

  • us10, us20: US cloud cockpit URLs
  • eu10, eu20: EU cloud cockpit URLs
  • ap10, ap11, ap21: APAC cloud cockpit URLs

On-Premise: Queries M_INIFILE_CONTENTS for api_url.

Open Business Application Studio

hana-cli openBAS

Opens BAS with current BTP target.

Customization

Namespace Configuration

Custom UI5 namespace:

"sap.hanacli.common": "./common"

Flexibility Services

Runtime UI adaptation via SessionStorageConnector.

Security

  • Credentials passed via memory (not URL)
  • Same-origin requests only
  • Session-based authentication

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

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