How do I install the Dbcli skill?

Run npx skillmds@latest add drolu/dbcli in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Dbcli safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Dbcli?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Dbcli free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

DrOlu (@drolu) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Dbcli by drolu — Agent Skill

Name: Dbcli
Author: DrOlu

Dbcli

Universal database CLI supporting 30+ databases (SQLite, PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, ClickHouse, DuckDB and more). Execute SELECT/DDL/DML, list tables, export schema, backup/restore tables, and run parameterized SQL. Use when the user asks to query, inspect, or modify a database, run SQL, list tables/columns, export data, or compare query results. Sub-skills: dbcli-query, dbcli-tables, dbcli-exec, dbcli-db-ddl, dbcli-export, dbcli-export-schema, dbcli-compare, dbcli-view, dbcli-index, dbcli-procedure, dbcli-interactive.

DrOlu b13f15a 5 files · 98.5 KB Updated Sep 17, 2026

File contents

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)

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

dbcli query "SELECT * FROM invoice WHERE customer_id IN (@Ids)" -p '{"Ids":[1,2,3]}'

Sub-skills

Each sub-skill lives in skills/<name>/SKILL.md under this directory:

dbcli-query — safe read-only SELECT
dbcli-tables — list tables / view structure (read-only)
dbcli-exec — INSERT/UPDATE/DELETE (backup required for UPDATE/DELETE)
dbcli-db-ddl — CREATE/ALTER/DROP (critical, mandatory backup)
dbcli-export — export table data as SQL (backup)
dbcli-export-schema — export schema objects
dbcli-compare — compare two query result sets (read-only)
dbcli-view — manage views (moderate)
dbcli-index — manage indexes (moderate)
dbcli-procedure — manage stored procedures/functions/triggers (critical)
dbcli-interactive — interactive SQL REPL

See skills/README.md, skills/INTEGRATION.md, and skills/CONNECTION_STRINGS.md for full details.

Safety

Always back up (dbcli backup <table> or dbcli export-schema) before DDL or destructive DML.
Use env vars for connection strings, never -c (keeps passwords out of logs/history).

---name: dbclidescription: Universal database CLI supporting 30+ databases (SQLite, PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, ClickHouse, DuckDB and more). Execute SELECT/DDL/DML, list tables, export schema, backup/restore tables, and run parameterized SQL. Use when the user asks to query, inspect, or modify a database, run SQL, list tables/columns, export data, or compare query results. Sub-skills: dbcli-query, dbcli-tables, dbcli-exec, dbcli-db-ddl, dbcli-export, dbcli-export-schema, dbcli-compare, dbcli-view, dbcli-index, dbcli-procedure, dbcli-interactive.---# dbcli — Database CLI for AI AgentsDbCli 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)```bashexport 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```bashdbcli query "SELECT * FROM invoice WHERE customer_id IN (@Ids)" -p '{"Ids":[1,2,3]}'```## Sub-skillsEach sub-skill lives in `skills/<name>/SKILL.md` under this directory:- `dbcli-query` — safe read-only SELECT- `dbcli-tables` — list tables / view structure (read-only)- `dbcli-exec` — INSERT/UPDATE/DELETE (backup required for UPDATE/DELETE)- `dbcli-db-ddl` — CREATE/ALTER/DROP (critical, mandatory backup)- `dbcli-export` — export table data as SQL (backup)- `dbcli-export-schema` — export schema objects- `dbcli-compare` — compare two query result sets (read-only)- `dbcli-view` — manage views (moderate)- `dbcli-index` — manage indexes (moderate)- `dbcli-procedure` — manage stored procedures/functions/triggers (critical)- `dbcli-interactive` — interactive SQL REPLSee `skills/README.md`, `skills/INTEGRATION.md`, and `skills/CONNECTION_STRINGS.md` for full details.## Safety- Always back up (`dbcli backup <table>` or `dbcli export-schema`) before DDL or destructive DML.- Use env vars for connection strings, never `-c` (keeps passwords out of logs/history).

Frequently asked questions