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★ 198⑂ 13AI score 8/10Last updated: Aug 6, 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.
View source on GitHub ↗License: GPL-3.0