dbcli-viewlisted

# DbCli View 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 views using DbCli's DDL command. This skill covers creating, altering, and dropping views across 30+ database systems. **Safety Level**: Moderate **Requires Backup**: Recommended before DROP operations ## Quick Start ```bash export DBCLI_CONNECTION="Data Source=app.db" # Create a new view dbcli ddl "CREATE VIEW ActiveUsers AS SELECT * FROM Users WHERE status='active'" # Drop a view dbcli ddl "DROP VIEW OldReport" # List all views (database-specific queries) dbcli query "SELECT name FROM sqlite_master WHERE type='view'" ``` --- ## Command Syntax ```bash # Set environment variables first: # export DBCLI_CONNECTION="connection-string" # export DBCLI_DBTYPE="database-type" dbcli ddl "<VIEW_DDL_STATEMENT>" ``` ### Options | Option | Alias | Description | Example | |--------|-------|-------------|---------|| | Environment | | Database connection string | `export DBCLI_CONNECTION="Server=localhost;Database=mydb"` | | Environment | | Database type | `export DBCLI_DBTYPE="sqlserver"` | | `--db-type` | `-t` | Database type | `-t sqlserver`, `-t mysql` | | `--format` | `-f` | Output format | `-f json`, `-f table` | | `--file` | `-F` | Read SQL from file | `-F create_view.sql` |