sap-hana-cli — Claude Code skill for SAP HANA work
This skill teaches your agent to drive hana-cli: inspect tables and views, run SQL, manage HDI containers, and export metadata to CDS, EDMX or OpenAPI.
npx skills add secondsky/sap-skills --skill sap-hana-cli -a claude-codeWhat sap-hana-cli does
The skill maps out SAP HANA Developer CLI (hana-cli), a command-line tool for HANA database development and administration. Your agent learns the command surface: inspecting tables, views, procedures and functions, running SQL, managing HDI containers, handling SAP HANA Cloud instances, and working with BTP CLI integration. The description covers 91 commands and more than 17 output formats.
There is an MCP section too. The bundled config pins [email protected], and connection details come from environment variables such as HANA_HOST, HANA_PORT, HANA_USER and HANA_PASSWORD. That server gets access to a HANA tenant, so the author advises running the sap-dependency-security skill before you change the pin. hana-cli itself needs Node.js 20.19.0 or newer.
The skill points at neighbours: sap-cap-capire for CAP and HDI work, sap-btp-cloud-platform for cloud instances, sap-abap-cds for CDS syntax comparisons. No HANA database and no plans for one? Then there is nothing here for you.
What it helps with
- inspect a table's columns and data types
- run a SQL query against a HANA database
- create or drop an HDI container
- export table metadata to CDS format
- connect to a HANA Cloud instance via service key
Example prompts for the agent
- Show me all tables in the MY_APP schema
- Describe the structure of the ORDERS table
- Run
hana-cli inspectTable -t INVENTORY -s PRODUCTS -o cds
How to install sap-hana-cli
1Skills CLI (Vercel)
npx skills add secondsky/sap-skills --skill sap-hana-cli -a claude-code2Manually: put the files in place
~/.claude/skills/sap-hana-cli/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/sap-hana-cli/
1Skills CLI (Vercel)
npx skills add secondsky/sap-skills --skill sap-hana-cli -a codex2Manually: put the files in place
.agents/skills/sap-hana-cli/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add secondsky/sap-skills --skill sap-hana-cli -a cursor2Manually: put the files in place
.cursor/skills/sap-hana-cli/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install secondsky/sap-skills sap-hana-cli2Manually: put the files in place
.github/skills/sap-hana-cli/SKILL.md1Skills CLI (Vercel)
npx skills add secondsky/sap-skills --skill sap-hana-cli -a gemini-cli2Platform CLI
gemini skills install https://github.com/secondsky/sap-skills --path plugins/sap-hana-cli/skills/sap-hana-cliManually: put the files in place
.devin/skills/sap-hana-cli/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add secondsky/sap-skills --skill sap-hana-cli -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about sap-hana-cli
How do I install sap-hana-cli in Claude?
Run npx skills add secondsky/sap-skills --skill sap-hana-cli -a claude-code. The skill lands at ~/.claude/skills/sap-hana-cli/SKILL.md.
What does sap-hana-cli do?
It gives your agent a working map of hana-cli: inspecting database objects, executing queries, managing HDI containers, and converting metadata to CDS, EDMX or OpenAPI.
What do I need before using it?
Node.js 20.19.0 or newer for hana-cli itself. The MCP path also needs environment variables for your HANA host, port, user and password.