Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

database-scout · zebbern | DecimalAI

databy zebbern

database-scout

zebbern/database-scout

Source zebbern/claude-code-guide ↗License MIT

Explore SQLite and PostgreSQL databases: list tables, inspect schemas (columns/types/constraints), preview data, generate Mermaid ER diagrams, and run safe read-only queries. Triggered by requests to explore a database, view table structures, describe tables, generate diagrams, or query data, and by keywords like database exploration, schema, ER diagram, or SQL query.

SkillScore100Maintained

Automatic

Data Engineer pack

Last verified 8/10/2026

What it changes

Passed 22 of 22 test cases with the skill, and 9 of 22 without it.

Without skill41%

With skill100%

Checks it passed that the model alone missed

Includes --db-type postgres in the command
Includes the list-tables subcommand in the command
States that INSERT statements are blocked by the tool

and 14 more in the full report

13 fixed9 passed either way0 still failing0 broke

Pass-rate lift: +59 pp
Tokens: +17%
Agent turns: 0%
Response time: -59%

Model gemini-3.6-flashMeasured 8/10/2026v122 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/zebbern-database-scout/SKILL.md https://app.decimal.ai/s/zebbern-database-scout/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add zebbern-database-scout, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/zebbern-database-scout/ and pins it in .decimal/skills.lock

decimalai skills add zebbern-database-scout

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/zebbern-database-scout/SKILL.md https://app.decimal.ai/s/zebbern-database-scout/SKILL.md

Raw file: /s/zebbern-database-scout/SKILL.md ↗ · machine-readable summary at /s/zebbern-database-scout.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 13 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 13

Prompt

I want to preview sample records from the `products` table in my SQLite database `catalog.db` without specifying a row limit. What CLI command should I run?

What was checked, without and with the skill
Checked	Without skill	With skill
Recommends running python3 scripts/db_explorer.py --db-path catalog.db preview products	Missed	Passed

case-07 · gemini-3.6-flash · 8/10/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md126 lines2 filesincludes scripts

database-scout

Read-only exploration tool for SQLite / PostgreSQL databases — inspect table schemas, preview data, generate ER diagrams, and run safe queries.

Feature Overview

Feature	Description
List all tables	Show tables and views in the database, with row counts
Inspect table schema	Column names, types, constraints (PK/FK/NOT NULL), indexes, defaults
Data preview	View the first N rows of a table
ER diagram generation	Output Mermaid erDiagram syntax, ready to render
Safe read-only queries	Only SELECT/WITH/EXPLAIN allowed; write operations are blocked

Security Mechanisms

Connection-level read-only: SQLite opens with ?mode=ro URI; PostgreSQL uses SET SESSION READ ONLY
SQL whitelist: Only statements starting with SELECT / WITH / EXPLAIN / PRAGMA / SHOW are allowed
Dangerous keyword blocking: INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, and 30+ other keywords are blocked
Multi-statement blocking: Semicolon-separated multiple SQL statements are rejected (prevents injection)
Identifier escaping: Table names are double-quote escaped to prevent SQL injection

Quick Start

# List all tables in a SQLite database
python3 scripts/db_explorer.py --db-path data.db list-tables

# Inspect table schema
python3 scripts/db_explorer.py --db-path data.db describe users

# Preview data (default 20 rows)
python3 scripts/db_explorer.py --db-path data.db preview orders --limit 10

# Generate Mermaid ER diagram
python3 scripts/db_explorer.py --db-path data.db er-diagram

# Run a read-only query
python3 scripts/db_explorer.py --db-path data.db query "SELECT name, age FROM users WHERE age > 18 LIMIT 10"

Track record

Benchmark

22 / 22

test cases passed, vs 9 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

zebbern / claude-code-guide

skills/database-scout/SKILL.md

View on GitHub ↗

License MITImported 8/3/2026Version v1Bundled 1 file · scripts

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

database-scout

Feature Overview

Security Mechanisms

Quick Start

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills