dbclilisted

# dbcli — Database CLI for AI Agents DbCli is a self-contained binary installed at `~/.local/bin/dbcli` (already on PATH). It speaks JSON/table/CSV output and follows the Agent Skills Specification. ## Quick connection (env vars — never pass `-c` with passwords) ```bash export DBCLI_CONNECTION="Host=...;Port=5432;Database=...;Username=...;Password=...;SSL Mode=Require;Trust Server Certificate=true" export DBCLI_DBTYPE="postgresql" # sqlite | mysql | sqlserver | postgresql | oracle | mongodb | clickhouse | duckdb | ... ``` ## Core commands | Command | Alias | Use | |---|---|---| | `dbcli tables` | `ls` | List tables | | `dbcli columns <table>` | `cols` | Show table structure | | `dbcli query "<sql>"` | `q` | SELECT (read-only) | | `dbcli exec "<sql>"` | `e` | INSERT/UPDATE/DELETE (backup first for UPDATE/DELETE) | | `dbcli ddl "<sql>"` | — | CREATE/ALTER/DROP (critical — backup first) | | `dbcli export <table>` | — | Export table data as INSERT SQL | | `dbcli export-schema <type>` | `schema` | Export procedures/functions/triggers/views/indexes | | `dbcli backup <table>` | — | Backup table (auto-selects fastest method) | | `dbcli restore <table> --from <backup>` | — | Restore table | | `dbcli compare` | — | Compare results of two SQL queries | | `dbcli interactive` | `i` | REPL | ## Output formats `-f json` (default for scripts), `-f table` (human), `-f csv`. ## Parameterized SQL ```bash dbcli query "SELECT * FROM invoice WHERE customer_id IN (@Ids)" -p '{"Ids":[1,2,