Claude Skill MartBrowse skillsQuick linesLearn by videoTerminal guideWhat is a Skill?
← Back to list

Database Schema Exploration

A step-by-step skill for listing tables, describing columns and types, and mapping foreign-key relationships in a database.

Data & AnalyticsBeginner★ 203⑂ 13AI score 8/10Last updated: Sep 22, 2026

What it does

  • Calls sql_db_list_tables to enumerate every table in the connected database.
  • Calls sql_db_schema per table to report column names, data types, 3 sample rows, primary keys and foreign keys.
  • Traces *Id columns to build parent-child relationship maps and JOIN paths.
  • Supplies answer-quality checklists for three question types: list tables, describe a table, and "how do I query X".

Who it's for

  • Analysts and engineers onboarding onto an unfamiliar database.
  • Builders of Text-to-SQL agents who want schema discovery as a separate skill.
  • Anyone reverse-engineering a legacy database without an ERD.

Examples

  1. "What tables are available?" → returns the full table list with a one-line purpose for each.
  2. "What columns does the Customer table have?" → columns with types, sample rows, and the SupportRepId foreign key to Employee.
  3. "How do I find revenue by artist?" → maps Artist → Album → Track → InvoiceLine and outlines the aggregation steps.

· · · Install guide · · ·

Try it now, no install

Paste this into Claude to use the skill without installing anything.

Read the instructions in this file and follow them to help me:
https://raw.githubusercontent.com/Idun-Group/idun-agent-platform/HEAD/examples/tutorials/text-to-sql-deep-agent/skills/schema-exploration/SKILL.md

What I want: (describe your task here)

If Claude can't open the link, open it yourself and paste the contents instead.

↓ If it works for you, download the ZIP below and install it. Then it runs on its own — no pasting each time.

Install in the Claude app (no terminal)
  1. Download the ZIP with the button below.
  2. In Claude, open Settings → Capabilities and turn on 'Code execution and file creation'. (one time)
  3. Go to Customize → Skills → + → 'Upload a skill' and upload the ZIP.
↓ Download ZIP
Install in Claude Code

Let Claude do it — paste this into Claude Code

Install the skill I found on Claude Skill Mart.
Copy the examples/tutorials/text-to-sql-deep-agent/skills/schema-exploration folder from the GitHub repo Idun-Group/idun-agent-platform into my ~/.claude/skills/schema-exploration/.
When it's done, tell me in one line what this skill can do.

Install with a command instead

git clone https://github.com/Idun-Group/idun-agent-platform.git && mkdir -p ~/.claude/skills && cp -r idun-agent-platform/examples/tutorials/text-to-sql-deep-agent/skills/schema-exploration ~/.claude/skills/

⚠ This is a third-party skill. Check the source repository before installing.

  1. Open a terminal and clone the repo: git clone https://github.com/Idun-Group/idun-agent-platform.git
  2. Create the skills directory if needed: mkdir -p ~/.claude/skills
  3. Copy the skill: cp -r idun-agent-platform/examples/tutorials/text-to-sql-deep-agent/skills/schema-exploration ~/.claude/skills/
  4. Make sure your agent exposes SQL inspection tools (sql_db_list_tables, sql_db_schema from the LangChain SQL toolkit, or an equivalent MCP database server).
  5. Restart Claude Code and ask something like "What tables exist in this database?" to trigger the skill.