skills.rest
ladinglogichq
ladinglogichqOFFICIAL
Explore all skills by this author →
GitHub

schema-exploration

Identify and describe database schema elements including tables, columns, data types, and foreign keys.

Updated Apr 23, 2026
Search Tags:#database#schema#sql#relationships#tables#erd#columns
One-click install
npx skills add https://github.com/ladinglogichq/lading-logic-hackathon --skill schema-exploration-ladinglogichq
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-exploration
Source: https://github.com/ladinglogichq/lading-logic-hackathon/tree/main/.agents/skills/schema-exploration
Command: npx skills add https://github.com/ladinglogichq/lading-logic-hackathon --skill schema-exploration-ladinglogichq

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps users understand and document database schemas by outlining tables, columns, data types, and key relationships.

Core Features & Use Cases

  • Table enumeration & descriptions: List all tables and provide a concise purpose for each.
  • Column definitions: Show column names, data types, and identify primary and foreign keys, with sample values when available.
  • Relationship mapping & ERD support: Detect foreign keys and parent-child links to illustrate how tables relate.
  • Use Case: Onboard new teammates, perform schema reviews, or answer questions about data models and relationships.

Quick Start

Run a schema overview to list tables, show column types, and map relationships for your database.

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 identify foreign keys?▼

To map database schema relationships, you can enumerate tables, define column data types, and detect foreign keys to illustrate parent-child links. This process produces structured metadata highlighting how tables relate within your relational database.

What is the best way to list all tables and columns in a SQL database?▼

Listing all tables and columns in a SQL database involves enumerating tables and extracting column definitions. This provides a concise purpose for each table alongside column names, data types, and primary key identification.

Does this schema discovery tool work across various database systems?▼

Schema discovery applies across various database systems to identify schema elements. It extracts table structures, column data types, and key relationships regardless of the specific relational database platform you are querying.

Can I generate ER diagram metadata from my existing database tables?▼

You can generate ER diagram support metadata by detecting foreign keys and mapping parent-child links between database tables. This produces precise structured metadata suitable for indexing and downstream diagramming tooling.

How do I onboard new teammates using a database schema overview?▼

Onboarding new teammates with a database schema overview involves listing tables and showing column types alongside relationship maps. This documents the data model and answers questions about table purposes and structural dependencies.

What sample values are included when documenting SQL column definitions?▼

Documenting SQL column definitions includes column names, data types, primary keys, and foreign keys. Sample values are provided when available to help contextualize the data stored within each specific column.

Related Skills

Explore More Data & Analytics Skills→
sahiixxsahiixx
2

schema_exploration

List database tables, detail columns, and map foreign-key relationships.

Community
Basic
neitui-coderneitui-coder

data-model-creation

Generate visual ER diagrams with automated foreign key management and field type mapping.

Community
Advanced
Zidane786Zidane786

schema-exploration

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

Community
Advanced
starlake-aistarlake-ai
209

yml2ddl

Convert Starlake YML definitions into SQL DDL statements.

Official
Intermediate