What is schema-exploration?

A guide for examining a database's tables, columns, relationships, and business meaning.

It helps answer questions about what a database tracks, how tables connect, and what rules or common mistakes apply to its data.

It turns a technical database structure into an explanation of what the stored information represents, including relationships that may not be explicitly declared.

schema-exploration — Skill for Claude Code and Codex by DeepSQLAI

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add DeepSQLAI/deepsql --skill schema-exploration

Clone the repo

git clone --depth 1 https://github.com/DeepSQLAI/deepsql

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/deepsqlai/deepsql/schema-exploration/github.svg)](https://agentmods.dev/skills/deepsqlai/deepsql/schema-exploration)

Your own site

<a href="https://agentmods.dev/skills/deepsqlai/deepsql/schema-exploration"><img src="https://agentmods.dev/badge/skills/deepsqlai/deepsql/schema-exploration/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/deepsqlai/deepsql/schema-exploration"><img src="https://agentmods.dev/badge/skills/deepsqlai/deepsql/schema-exploration.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 33 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 470 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits

NVIDIA SkillSpector pass 7 Sept 2026

How audits are shown

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00033	$0.00470
Opus 5.5	$0.00013	$0.00188
Sonnet 5.5	$0.00007	$0.00094
Haiku 4.5	$0.00003	$0.00047

Measured 1mo ago against content hash ff3b62a5f073, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

schema-exploration scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

agent/skills/schema-exploration/SKILL.md · 33 lines

What it actually says

Schema Exploration

Use when the user wants to understand the database itself ("what does this DB track?", "what tables exist?", "how are orders and customers related?", "describe the bookings table").

Procedure

Resolve the connection (list_connections → UUID) if you don't have it.
Get the shape. get_schema(connectionId) for tables, columns, types, declared FKs. get_database_objects(connectionId) when you also need views/functions/procedures, not just columns. The schema is cached and authoritative — trust it over the codebase.
Get the meaning. get_brain_context(connectionId, "<what the user is asking about>") for the domain layer: what the tables mean, business terms, documentation. This is what turns "a list of tables" into "what the database tracks."
Fill relationship gaps. Many real databases lack declared foreign keys. get_relationships(connectionId) returns inferred + validated FKs with a confidence score and validationStatus. Report the confidence — a 0.95 inferred FK is reliable; a 0.4 one is a guess.
Surface the rules and traps. list_business_rules(connectionId) and get_anti_patterns(connectionId, kind="table") so the user learns the conventions and known schema smells, not just the structure.

Reporting

Lead with what the database is for, then the largest/most central tables, then notable relationships.
For "largest tables," use the row counts from get_schema (don't run COUNT(*) across every table).
Flag anti-patterns and low-confidence inferred FKs explicitly — they're the things a user most needs to know and least expects.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

1mo ago First seen · 33 lines · 33 tokens per session scan A ff3b62a5f073

Subscribe to this mod's changes

schema-exploration is a skill published in the GitHub repository DeepSQLAI/deepsql (39 stars, last pushed 5d ago), licensed Apache-2.0. It adds 33 tokens to every session and 470 once invoked, about $0.0001 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Databases LLM ai database-performance mcp-server mysql

sql-expert

Expert-level SQL database design, querying, optimization, and administration across PostgreSQL, MySQL, and SQL Server. Use when the user mentions database, PostgreSQL, MySQL, or query optimization, or when the task involves Database Design, Advanced Queries, Indexes and Performance, or Transactions and Concurrency.

personamanagmentlayer/pcl · 66 tokens

docsite-link-sweep

Sweep the googleapis/mcp-toolbox docs for broken and non-canonical links, report each finding with its cause, and apply the safe class of internal link fixes. CI does not check links on this repo, so this skill is the only link check that runs. Use when a maintainer asks for a link sweep or a docs health check, before…

googleapis/mcp-toolbox · 148 tokens

graphjin-eval

Create, extend, run, baseline, and diagnose GraphJin agent evaluations through the graphjin eval CLI.

dosco/graphjin · 27 tokens

openloomi-api

OpenLoomi ships a local-first HTTP API served from the desktop app (port 3414, fallback 3515). All auth, Memory, AI, RAG, Loop, and Audit data live in a local SQLite database — your data stays on your machine and the OpenLoomi app is the source of truth. The only externally-routed auth path is the Composio OAuth…

melandlabs/openloomi · 106 tokens

output-dev-credentials

Store and reference encrypted secrets in Output SDK workflows using @outputai/core/credentials. Use when integrating API keys, database passwords, or third-party tokens.

growthxai/output · 36 tokens

change

Track and inspect graph changes, diffs, temporal updates, and the impact of new data on VeritasReason knowledge graphs.

bibinprathap/VeritasGraph · 27 tokens