dbcli-execlisted

## 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 Exec Skill Execute INSERT, UPDATE, DELETE (DML) operations on databases with mandatory backup procedures. ## Supported Databases (DML) `exec` is intended for **SQL / relational databases** supported by DbCli (SqlSugar providers). Examples include: - SQL Server - MySQL-family (MySQL, MariaDB, TiDB, OceanBase, etc.) - PostgreSQL-family (PostgreSQL, GaussDB, Kingbase, etc.) - SQLite - Oracle - IBM DB2 - DaMeng For connection string examples and the full list, see `skills/CONNECTION_STRINGS.md`. ## ⚠️ CRITICAL SAFETY REQUIREMENT **ALWAYS CREATE BACKUPS BEFORE EXECUTING UPDATE/DELETE OPERATIONS** Backup naming convention: - Table copy: `tablename_copy_YYYYMMDD_HHMMSS` - SQL export: `tablename_backup_YYYYMMDD_HHMMSS.sql` ## When to Use This Skill - User wants to insert new records into a table - User needs to update existing data - User wants to delete records - User mentions INSERT, UPDATE, DELETE, modify, change, or remove data - **Never use without creating backups first for UPDATE/DELETE** ## Command Syntax ```bash export DBCLI_CONNECTION="CONNECTION_STRING" export DBCLI_DBTYPE="DATABASE_TYPE" # Optional, default: sqlite dbcli exec "DML_STATEMENT" [-p JSON] [-P params.json] ``` ### Global Options - Environment va