dbcli-indexlisted

# DbCli Index Management Skill ## Command Style (Use PATH) All examples use the plain command name `dbcli` (no directory prefix). Ensure `dbcli` is on PATH instead of hardcoding paths like `.\.claude\skills\dbcli\dbcli.exe`. ## Overview Manage database indexes using DbCli's DDL command. This skill covers creating, analyzing, and dropping indexes to optimize query performance across 30+ database systems. **Safety Level**: Moderate **Requires Backup**: Recommended before dropping indexes on production ## Quick Start ```bash # ⚠️ IMPORTANT: Backup indexes before DROP operations # Backup all indexes export DBCLI_CONNECTION="Data Source=app.db" dbcli export-schema index -o backup_indexes.sql # Create an index dbcli ddl "CREATE INDEX idx_users_email ON Users(email)" # Create a unique index dbcli ddl "CREATE UNIQUE INDEX idx_users_username ON Users(username)" # Drop an index (with backup) dbcli ddl "DROP INDEX idx_old_index" # Restore from backup if needed # Execute the CREATE INDEX statement from backup_indexes.sql # List all indexes dbcli query "SELECT name FROM sqlite_master WHERE type='index'" -f table ``` --- ## Command Syntax ```bash dbcli [options] ddl "<INDEX_DDL_STATEMENT>" ``` ### Options | Option | Alias | Description | Example | |--------|-------|-------------|---------| | `--db-type` | `-t` | Database type | `-t sqlserver`, `-t mysql` | | `--format` | `-f` | Output format | `-f json`, `-f table` | | `--f