← ClaudeAtlas

dbcli-exportlisted

Export table data as SQL INSERT statements from 30+ databases using DbCli. Essential for creating backups before dangerous modifications (UPDATE/DELETE/DROP). Use when user needs to backup data, migrate tables, or create portable SQL dumps.
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 Export Skill Export table data as SQL INSERT statements - essential for backup before dangerous operations. ## When to Use This Skill - **MANDATORY before UPDATE/DELETE/DROP operations** - Create backups first - User wants to backup table data - User needs to migrate data between databases - User wants portable SQL dump for version control - User needs to copy table data to another environment - Creating disaster recovery backups ## ⚠️ Safety-Critical Use Cases This skill is **REQUIRED** before: 1. **UPDATE operations** - Backup data before modifying 2. **DELETE operations** - Backup data before removing 3. **DROP TABLE** - Backup before destroying table 4. **ALTER TABLE** - Backup before structure changes 5. **Bulk modifications** - Backup before mass updates ## Command Syntax ```bash export DBCLI_CONNECTION="CONNECTION_STRING" export DBCLI_DBTYPE="DATABASE_TYPE" # Optional, default: sqlite dbcli export TABLE_NAME > output.sql ``` ## Global Options - Environment variable `DBCLI_CONNECTION`: Database connection string (required) - Environment variable `DBCLI_DBTYPE`: Database type (default: sqlite) ## Basic Export ### Single Table Export ```bash # SQLite - Export Users table export DBCLI_CONNECTION="Data Source=app.