← ClaudeAtlas

dbcli-tableslisted

List all tables in a database and show table structure (columns, types, constraints) for 30+ databases using DbCli. Use when user wants to explore database schema, see what tables exist, check table structure, or understand column definitions.
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 Tables Skill List all tables and view table structures in databases. ## When to Use This Skill - User wants to see all tables in a database - User needs to check table structure or schema - User asks "what tables exist" or "show me the database schema" - User wants to see column names, types, or constraints - User needs to explore an unfamiliar database ## Command Syntax ### List All Tables ```bash # Set environment variables first: # export DBCLI_CONNECTION="connection-string" # export DBCLI_DBTYPE="database-type" dbcli [-f FORMAT] tables ``` ### Show Table Structure ```bash dbcli [-f FORMAT] columns TABLE_NAME ``` ## Global Options - Environment variables: - `DBCLI_CONNECTION`: Database connection string - `DBCLI_DBTYPE`: Database type (alternative to -t) - `-t, --db-type`: Database type (default: sqlite) - `-f, --format`: Output format: `json` (default), `table`, `csv` ## List All Tables ### Basic Usage ```bash # SQLite - JSON format (default) export DBCLI_CONNECTION="Data Source=app.db" dbcli tables # Output: [{"TableName":"Users"},{"TableName":"Orders"},{"TableName":"Products"}] # Table format (human-readable) dbcli -f table tables # Output: # +-----------+ # | TableName | # +-----------+