← ClaudeAtlas

dbcli-db-ddllisted

Execute DDL (Data Definition Language) statements - CREATE, ALTER, DROP tables, indexes, views on 30+ databases using DbCli. CRITICAL - requires mandatory backup before DROP/ALTER operations. Use when user needs to create schema, modify structure, or drop database objects.
DrOlu/agent-skills · ★ 0 · AI & Automation · score 66
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