dbcli-db-ddllisted
Install: claude install-skill DrOlu/agent-skills
## 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`.
# DbCli Database DDL Skill
Execute Data Definition Language (DDL) operations - CREATE, ALTER, DROP tables, indexes, and views.
## ⚠️ CRITICAL SAFETY REQUIREMENT
**MANDATORY BACKUPS BEFORE DROP/ALTER OPERATIONS**
- DROP TABLE: Export table data + create table copy
- ALTER TABLE: Export table schema + data
- DROP INDEX/VIEW: Document structure before dropping
## When to Use This Skill
- User wants to create tables, indexes, or views
- User needs to modify table structure (add/drop columns, change types)
- User wants to drop tables, indexes, or views
- User mentions CREATE, ALTER, DROP, schema, structure, or database design
- **Never DROP/ALTER without backups**
## Command Syntax
```bash
DBCLI_CONNECTION="CONNECTION_STRING" DBCLI_DBTYPE="DATABASE_TYPE" dbcli ddl "DDL_STATEMENT"
```
### Global Options
- Environment variable `DBCLI_CONNECTION`: Database connection string (required)
- Environment variable `DBCLI_DBTYPE`: Database type (default: sqlite)
- `--config <path>`: Config file path (e.g. `appsettings.json`) (optional)
### Subcommand Options
- `-F, --file`: Execute DDL from file
Notes:
- SQL Server supports `GO` batch separators in DDL scripts (use `-F` and keep `GO` on its own line).
## CREATE Operations (Safe - No Backu