AI Summaryhana-cli (npm: hana-cli, install: ) is a command-line tool for SAP HANA database development. It simplifies complex multi-step database operations into single commands. It is a development tool, not a replacement for hdbsql or production admin tools. Use hana-cli when a developer needs to: 1. Always
Install
Copy this and paste it into Claude Code, Cursor, or any AI assistant:
I want to add the "cloud-cap-hana-swapi — Windsurf Rules" prompt rules to my project. Repository: https://github.com/SAP-samples/cloud-cap-hana-swapi Please read the repo to find the rules/prompt file, then: 1. Download it to the correct location (.cursorrules, .windsurfrules, .github/prompts/, or project root — based on the file type) 2. If there's an existing rules file, merge the new rules in rather than overwriting 3. Confirm what was added
Description
SAP Cloud Application Programming Model fun sample to demonstrate many-to-many relationships.
About hana-cli
hana-cli (npm: hana-cli, install: npm install -g hana-cli) is a command-line tool for SAP HANA database development. It simplifies complex multi-step database operations into single commands. It is a development tool, not a replacement for hdbsql or production admin tools. Version: 4.202603.2 Requirements: Node.js ≥ 20.19.0 Module: ESM ("type": "module")
When to Use hana-cli
Use hana-cli when a developer needs to: • Explore schemas: hana-cli tables, hana-cli views, hana-cli schemas • Inspect objects: hana-cli inspectTable, hana-cli inspectView, hana-cli inspectProcedure • Import/export data: hana-cli import, hana-cli export • Run queries: hana-cli querySimple --query "SQL" • Check health: hana-cli healthCheck, hana-cli systemInfo • Manage connections: hana-cli connect, hana-cli status • Profile data: hana-cli dataProfile, hana-cli dataValidator • Compare schemas: hana-cli compareSchema, hana-cli compareData • Monitor performance: hana-cli expensiveStatements, hana-cli memoryAnalysis • Manage security: hana-cli users, hana-cli roles, hana-cli securityScan • Work with HANA Cloud: hana-cli hanaCloudInstances, hana-cli hanaCloudStart • Manage HDI: hana-cli containers, hana-cli adminHDI
Key Patterns
• Always verify connection first: hana-cli status • Explore before modifying: Use tables, inspectTable, dataProfile before import/export • Use dry-run for imports: hana-cli import --filename data.csv --table X --schema Y --dryRun • Use --output flag: Many commands support --output json|csv|table|excel • Use --query flag with querySimple: hana-cli querySimple --query "SELECT ..." (not positional args) • Interactive mode: Run hana-cli with no arguments for a menu-driven experience
Connection Setup
`bash hana-cli connect # Interactive wizard hana-cli connectViaServiceKey # Via BTP service key hana-cli copy2DefaultEnv # Copy to default-env.json for CAP projects hana-cli status # Verify connection `
Discussion
Health Signals
My Fox Den
Community Rating
Sign in to rate this booster
Works With
Any AI assistant that accepts custom rules or system prompts