skills.rest
nimrodfisher
nimrodfisherCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

schema-mapper

Map database schemas from connections or exports into ERDs and data dictionaries.

351|70|Updated Jan 11, 2026
Search Tags:#documentation#database#inference#erd#data-dictionary#schema-map#join-paths
One-click install
npx skills add https://github.com/nimrodfisher/data-analytics-skills --skill schema-mapper
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-mapper
Source: https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/schema-mapper
Command: npx skills add https://github.com/nimrodfisher/data-analytics-skills --skill schema-mapper

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automatically discover, document, and visualize database schemas including tables, columns, relationships, and join paths. Essential for understanding unfamiliar databases or creating documentation.

Core Features & Use Cases

  • Automatic schema discovery and documentation of tables, columns, relationships
  • ERD generation, data dictionary, and join-path analysis for quick insight
  • Use Case: onboarding a new database team by producing a complete schema map and recommended joins

Quick Start

Provide a database connection or schema export and I will map the schema, generate a data dictionary, and create an ERD.

Frequently Asked Questions about schema-mapper

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

FAQPage Schema
How do I map and document an unfamiliar database schema?▼

To map and document a database schema, provide a database connection or schema export to automatically discover tables, columns, and relationships, generating a complete schema map for quick understanding.

What is the best way to generate an ERD and data dictionary for a new database?▼

Generating an ERD and data dictionary requires analyzing your database connection or export to automatically extract foreign keys and infer relationships, producing visual diagrams and structured reference metadata.

Can I generate join-path analysis if my database lacks explicit foreign keys?▼

Yes, join-path analysis can be generated even without explicit foreign keys by inferring relationships from naming patterns, allowing you to identify recommended joins across unfamiliar data sources.

Does this schema mapping approach work with dbt projects?▼

Schema mapping works with dbt projects by analyzing the existing schema repository to document tables, columns, and relationships, producing visual ERDs and a comprehensive data dictionary.

How do I onboard a new team to an existing database schema?▼

Onboard a new database team by providing a schema export to map the schema, producing a complete data dictionary, visual ERDs, and join-path analyses to ensure quick insight into the data source.

Related Skills

Explore More Data & Analytics Skills→
DbxstudioDbxstudio
82

data-exploration-tool

Profile database tables by reading schemas and gathering statistical insights.

Official
Intermediate
jeremylongshorejeremylongshore
2.6k

generating-database-documentation

Generate ERD diagrams and data dictionaries from existing database schemas.

Community
Intermediate
armanzeroeightarmanzeroeight
29

model-builder

Generate dbt models with standardized layering, incremental strategies, and documentation.

Community
Intermediate
marlo9981marlo9981

schema-exploration

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

Community
Intermediate