skills.rest
marlo9981
marlo9981COMMUNITY
Explore all skills by this author →
GitHub

schema-exploration

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

Updated Mar 17, 2026
Search Tags:#database#schema#sql#data-modeling#erd#foreign-keys
One-click install
npx skills add https://github.com/marlo9981/Movara --skill schema-exploration-marlo9981
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-exploration
Source: https://github.com/marlo9981/Movara/tree/main/examples/text-to-sql-agent/skills/schema-exploration
Command: npx skills add https://github.com/marlo9981/Movara --skill schema-exploration-marlo9981

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Quickly understand an unfamiliar relational database by listing available tables, describing each table's columns and data types, identifying primary and foreign keys, and illustrating how entities relate so you can design queries and visualize the data model.

Core Features & Use Cases

  • Discoverability: List all tables and provide concise descriptions of their purpose to orient users to the dataset.
  • Schema Inspection: Describe column names, data types, primary keys, and sample rows to clarify the structure and content of a table.
  • Relationship Mapping: Identify foreign keys and map join paths to support query planning and ERD creation; useful when preparing analytics queries or building data integrations.

Quick Start

Use the schema-exploration skill to list all tables and then describe the Customer table to understand its columns, types, keys, and sample rows.

Frequently Asked Questions about schema-exploration

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

FAQPage Schema
How do I explore an unfamiliar relational database schema?▼

To explore a database schema, you need to list available tables, describe column names and data types, and identify primary and foreign keys to understand how entities relate for query planning.

How do I map foreign key relationships for SQL query planning?▼

Mapping foreign key relationships requires inspecting database metadata to identify join paths between tables, which clarifies how entities connect and supports effective SQL query planning and ERD creation.

What is the best way to visualize table relationships for an ERD?▼

Visualizing table relationships for an ERD involves listing all tables, inspecting their columns and primary keys, and mapping foreign key constraints to document how entities join together.

Can I inspect column data types and sample rows in a SQL database?▼

Yes, you can inspect column data types and sample rows by using database metadata tools that describe table structures, report constraints, and return sample data to clarify table content.

Do I need database metadata access to document table structures?▼

Yes, documenting table structures requires access to database metadata and tools that list tables, inspect schemas, and report primary and foreign key constraints to map the data model accurately.

Why does understanding foreign keys help when building data integrations?▼

Understanding foreign keys helps when building data integrations because identifying join paths and table relationships ensures entities connect correctly, preventing data mismatches during integration workflows.

Related Skills

Explore More Data & Analytics Skills→
starlake-aistarlake-ai
209

bq-info

Retrieve BigQuery table schemas, metadata, and properties across datasets and projects.

Official
Intermediate
D26FORWARDD26FORWARD

schema-exploration

List database tables, inspect schemas, and map foreign key join paths.

Community
Intermediate
l395624064l395624064

data-model-creation

Generate Mermaid class diagrams for multi-entity data models with automatic foreign-key management.

Community
Advanced
Pabloprogramador23Pabloprogramador23

reversa-archaeologist

Analyze legacy codebases module by module to extract algorithms, control flows, and data structures.

Community
Advanced