skills.rest
AP3X-Dev
AP3X-DevCOMMUNITY
Explore all skills by this author →
GitHub

schema-exploration

List tables, inspect schemas, and map foreign keys across database structures.

Updated Aug 23, 2026
Search Tags:#SQL#database#schema#metadata#exploration#relationships#tables
One-click install
npx skills add https://github.com/AP3X-Dev/AGENT --skill schema-exploration-ap3x-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-exploration
Source: https://github.com/AP3X-Dev/AGENT/tree/main/vendor/deepagents/examples/text-to-sql-agent/skills/schema-exploration
Command: npx skills add https://github.com/AP3X-Dev/AGENT --skill schema-exploration-ap3x-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill discovers and documents database structure by listing tables, inspecting schemas, and identifying relationships.

Core Features & Use Cases

  • Inventory and map database schemas: list available tables, view column definitions, data types, and keys.
  • Understand relationships: identify foreign keys and how tables relate to each other to support data integration and query design.
  • Use Case: When redesigning a database or validating a data warehouse, run a schema exploration to generate a metadata blueprint.

Quick Start

Ask the agent to discover the database structure, list tables, and fetch the schema for a specific table.

Frequently Asked Questions about schema-exploration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I list all tables and column definitions in a SQL database?▼

Mapping database schema relationships involves identifying foreign keys across tables to reveal how data connects. This process uses schema inspection tools to extract relationship metadata and generate a structured overview of table links.

What is the best way to map database schema relationships and foreign keys?▼

Mapping database schema relationships involves identifying foreign keys across tables to reveal how data connects. This process uses schema inspection to extract relationship metadata and generate a structured overview of table links for query design.

How do I generate a metadata blueprint for a data warehouse?▼

Generating a metadata blueprint for a data warehouse requires running a schema exploration to document the database structure. This process inventories tables, inspects column definitions, and maps foreign key relationships into a structured overview.

Can I use schema exploration to document an existing database structure?▼

Yes, you can use schema exploration to document an existing database structure by listing available tables and inspecting schemas. It reveals column definitions, data types, and keys to produce a comprehensive structural metadata overview.

Does schema discovery work across multiple schemas in a database?▼

Schema discovery works across multiple schemas in a database to reveal foreign keys and table relationships. It applies discovery tools to inventory tables and inspect schemas, producing a unified metadata overview of the entire database structure.

Related Skills

Explore More Data & Analytics Skills→
leonj1leonj1

rds-postgres

Connect to Amazon RDS PostgreSQL databases and execute SQL queries.

Community
Intermediate
rbutinarrbutinar

databricks-query

Execute SQL queries on a Databricks SQL Warehouse.

Community
Intermediate
marlo9981marlo9981

schema-exploration

List tables, describe columns and data types, and identify foreign keys.

Community
Intermediate
yaresimeonthomasyaresimeonthomas

writing-migrations

Generate idempotent Supabase SQL migrations from session branch code diffs.

Community
Advanced