skills.rest
coinvest518
coinvest518COMMUNITY
Explore all skills by this author →
WebsiteGitHub

schema-exploration

List tables, columns, data types, and foreign-key relationships in database schemas.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when you need to understand or document a database schema, know what tables exist, their keys, and how entities relate.

Core Features & Use Cases

  • Table discovery: enumerate all tables in a database.
  • Column details: describe column names, data types, and sample values.
  • Relationship mapping: identify foreign keys and illustrate ERD-like relationships.
  • Answer schema questions: provide concise explanations of table roles and connections.

Quick Start

Describe the schema of a target database by listing tables, columns, data types, and relationships.

Frequently Asked Questions about schema-exploration

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

FAQPage Schema
How do I map database schema relationships and list foreign keys?▼

To map database schema relationships, you query schema metadata to enumerate tables, describe column data types, and identify foreign key constraints to illustrate entity relationships like an ERD.

What is the best way to document table columns and data types in a relational database?▼

The best way to document table columns and data types is to query schema metadata, which enumerates all tables, describes column names, identifies foreign keys, and maps entity relationships.

Can I use this to explore a database schema and understand what tables exist?▼

Yes, you can explore a database schema to discover all existing tables, detail their column names and data types, identify foreign key relationships, and provide concise explanations of table roles.

How do I generate an ERD from existing foreign-key constraints?▼

You generate an ERD by querying schema metadata to infer relationships from foreign-key constraints, listing tables, detailing column data types, and mapping the connections between entities.

What do I need to query schema metadata and evaluate a data model?▼

To query schema metadata and evaluate a data model, you need a relational database environment that allows querying table structures, column data types, and foreign-key constraints to map entity relationships.

Related Skills

Explore More Data & Analytics Skills→
HainrixzHainrixz
18

db-referential-integrity

Audit foreign key constraints in relational databases for integrity issues.

Community
Advanced
clovernguyen1010-ship-itclovernguyen1010-ship-it

BA ERD Generation

Generate Mermaid ERD diagrams and data dictionaries from elicitation notes.

Community
Advanced
D26FORWARDD26FORWARD

schema-exploration

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

Community
Intermediate
fcakyonfcakyon
1.0k

supabase-usage

Query Supabase databases to list tables, inspect schemas, and explore relationships.

Community
Advanced