Commands Overview

All available commands organized by category. 186 total commands available - see the Complete Command Reference for the full list.

📚 Quick Links

• 📋 All Commands A-Z - Complete reference of all 186 commands
• 🔀 Command Reference Diagrams - Visual flowcharts with Mermaid diagrams
• 🔄 Command Execution Flows - System architecture diagrams

---

📊 Analysis Tools

Tools for data analysis, profiling, and quality checks.

• Data Lineage - Trace data flow and dependencies
• Data Profile - Analyze column statistics and distributions
• Data Diff - Compare data between tables or systems
• Duplicate Detection - Find duplicate records
• Referential Check - Validate foreign key relationships
• Calc View Analyzer - Analyze calculated views
• Data Validator - Validate data consistency

Plus 3 more: columnStats, fragmentationCheck - See All Commands

🗄️ Data Tools

Commands for data migration, synchronization, and transformation.

• Import - Load CSV/Excel data into tables
• Export - Export table data to files
• Compare Data - Compare data across different sources
• Data Sync - Synchronize data between systems
• Data Validator - Validate data consistency and integrity
• Kafka Connect - Stream data from Kafka

🏗️ Schema Tools

Tools for schema management and database structure operations.

• Compare Schema - Compare database schemas
• Schema Clone - Clone entire schemas with data
• Table Copy - Copy tables between schemas

⚙️ System Tools

Administrative and system-level commands.

• Replication Status - Monitor database replication
• SDI Tasks - Manage Smart Data Integration tasks
• XSA Services - Manage XSA services
• Timeseries Tools - Work with time series data

🔍 Quick Search

Looking for a specific command? Use the search bar above or check the full Command Reference in Features.

Pro Tips

• Use --help flag with any command for detailed options
• Most commands support --output for different formats (json, csv, table)
• Use --verbose flag for detailed execution information
• Commands support aliases for faster typing (e.g., imp for import)

Examples

# Get help for a command
hana-cli import --help

# Use verbose output
hana-cli dataProfile -s SCHEMA -t TABLE --verbose

# Export as JSON
hana-cli export -s SCHEMA -t TABLE --output json