dbcli-export-schemalisted
Install: claude install-skill DrOlu/agent-skills
# DbCli Schema Export 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
Export database schema objects (stored procedures, functions, triggers, views, indexes) as SQL DDL scripts for backup and recovery. This skill is essential for protecting database objects before DROP or ALTER operations.
**Safety Level**: Safe (read-only operation)
**Requires Backup**: No (this tool creates backups)
## Quick Start
```bash
# Export all schema objects
export DBCLI_CONNECTION="Server=.;Database=mydb"
export DBCLI_DBTYPE="sqlserver"
dbcli export-schema all -o backup_schema.sql
# Export all schema objects as separate files (per object)
dbcli export-schema all --output-dir ./schema_export
# Export only stored procedures
dbcli export-schema procedure -o backup_procedures.sql
# Export only indexes
export DBCLI_CONNECTION="Data Source=app.db"
dbcli export-schema index -o backup_indexes.sql
# Export only triggers
dbcli export-schema trigger -o backup_triggers.sql
# Filter by name pattern
export DBCLI_CONNECTION="Server=.;Database=mydb"
export DBCLI_DBTYPE="sqlserver"
dbcli export-schema procedure --name "sp_User*"
```
---
## Command Syntax
### Basic Usage
```bash
# Set environment variables first:
# export DBCLI_CONNECTION="connection-string"
# export DBCLI_DBTYPE="database-type