dbcli-procedurelisted
Install: claude install-skill DrOlu/agent-skills
# DbCli Procedure 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 stored procedures, functions, and triggers using DbCli's DDL and EXEC commands. This skill covers creating, altering, executing, and dropping database programmability objects across multiple database systems.
**Safety Level**: Critical
**Requires Backup**: Mandatory before DROP operations
## Quick Start
```bash
# ⚠️ CRITICAL: Always backup before DROP operations!
# Backup all procedures/functions/triggers
export DBCLI_CONNECTION="Server=.;Database=mydb"
export DBCLI_DBTYPE="sqlserver"
dbcli export-schema all -o backup_schema.sql
# Or backup specific type
dbcli export-schema procedure -o backup_procedures.sql
# Create a stored procedure (SQL Server)
dbcli ddl "
CREATE PROCEDURE GetUserById @UserId INT
AS
BEGIN
SELECT * FROM Users WHERE id = @UserId
END"
# Execute stored procedure (parameterized)
dbcli procedure "GetUserById" -p '{"UserId":1}'
# Drop procedure (with backup)
dbcli ddl "DROP PROCEDURE IF EXISTS GetUserById"
# Restore from backup if needed
# Extract and execute the CREATE statement from backup_procedures.sql
# List all procedures
dbcli query "
SELECT name, create_date, modify_date
FROM sys.procedures
ORDER BY name" -f table
```
---
## Command Syntax