HANA CLI

Appearance

SAP HANA Developer Command Line Interface

Welcome to the official documentation for the SAP HANA Developer Command Line Interface. A developer-centric tool for working with SAP HANA databases from your terminal, IDE, or cloud shell environment

⚠️ Important Notice - Major Updates (Feb/March 2026)

Version 4.x introduces significant changes including Express 5 migration, refactored database connection handling, and major performance improvements. While we've tested extensively, please be aware of potential issues in your specific environment.

If you encounter problems:

  • Report Issues: Please open an issue on our GitHub Issues page
  • Rollback: Install the last stable version: npm install -g hana-cli@3.202601.0

See the Changelog for complete details on all changes.

⚡ Getting Started ​

New to hana-cli? Start here with installation and first steps. Get Started →

📚 Commands ​

Explore 155 commands organized by category. Browse Commands →

✨ Features ​

Learn about advanced features and integrations. Features →

🔌 API Reference ​

Integration guides and API documentation. API Docs →

🧪 Testing & QA ​

Run E2E CLI tests and WDI5 UI automation. Testing Guide →

What is HANA CLI? ​

HANA CLI (pronounced "HAN-uh C-L-I") is a powerful command-line tool designed for SAP HANA developers. Whether you're working locally with SAP HANA Express, in the cloud with SAP BTP, or with SAP HANA Cloud, this tool simplifies complex database operations.

Key Features ​

  • Data Analysis - Profile, compare, and validate data with precision
  • Schema Management - Clone, compare, and sync database schemas
  • Data Import/Export - Seamless CSV and Excel file handling
  • API Server - REST API for programmatic access
  • Model Context Protocol - Integration with AI coding assistants
  • Multi-Environment - Works anywhere Node.js runs (tested on Windows, macOS, and Linux)

🎥 Videos ​

💡 Use Cases ​

Local Development ​

Cloud Development ​

  • SAP Business Application Studio integration
  • Cloud shell environments (Google Cloud, AWS)
  • SAP BTP HANA service management

Data Operations ​

  • ETL and data migration
  • Data quality validation
  • Schema synchronization across environments

🔗 Resources ​

📝 Need Help? ​

INFO

Just getting started? Head over to the Getting Started guide to install and configure HANA CLI in just a few minutes.