agentsclimarketplace

Dbcli

Skill DrOlu/agent-skills/skills/dbcli

Open agent skills for the skills.sh ecosystem — browser, docs, mail, media, security, networking, orchestration, and more.

Install
npx -y skills add DrOlu/agent-skills --skill dbcli

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

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.

SKILL.md

3.1 KB, 698 tokens by cl100k_base, as published. Nobody here has run it

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

CommandAliasUse
dbcli tableslsList tables
dbcli columns <table>colsShow table structure
dbcli query "<sql>"qSELECT (read-only)
dbcli exec "<sql>"eINSERT/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>schemaExport 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 interactiveiREPL

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).

What ships with it: 4 files

95.5 KB alongside SKILL.md

skills/

Keep looking

Skills are one crate of 326,984. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.