skills.rest
anthril
anthrilOFFICIAL
Explore all skills by this author →
WebsiteGitHub

data-dictionary-generator

Generate Markdown data dictionaries with Mermaid ER diagrams from PostgreSQL schemas.

3|Updated Apr 1, 2026
Search Tags:#postgresql#metadata#governance#data-dictionary#er-diagram#schema-documentation
One-click install
npx skills add https://github.com/anthril/official-claude-plugins --skill data-dictionary-generator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-dictionary-generator
Source: https://github.com/anthril/official-claude-plugins/tree/main/plugins/data-analysis/skills/data-dictionary-generator
Command: npx skills add https://github.com/anthril/official-claude-plugins --skill data-dictionary-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill produces comprehensive data dictionaries from database schemas, enabling clearer governance, faster onboarding, and audit readiness by documenting tables, columns, constraints, and relationships.

Core Features & Use Cases

  • Auto-discovers tables, columns, constraints, and relationships from SQL files and migrations
  • Generates a readable Markdown dictionary with column descriptions, patterns, and an embedded Mermaid ER diagram
  • Useful for data catalogs, data governance programs, and analytics-team onboarding

Quick Start

Run the data dictionary generator against your SQL schemas or migrations to produce a complete Markdown dictionary.

Frequently Asked Questions about data-dictionary-generator

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

FAQPage Schema
How do I generate a data dictionary from PostgreSQL schemas?▼

To generate a data dictionary from PostgreSQL schemas, apply the tool to your SQL schemas or migrations to auto-discover tables, columns, constraints, and relationships, producing a structured Markdown dictionary.

Can I create an ER diagram from SQL migration files?▼

Yes, you can create an ER diagram from SQL migration files by running the generator, which outputs a readable Markdown dictionary that includes an embedded Mermaid ER diagram of your database relationships.

What is the best way to document database schemas for data governance?▼

The best way to document database schemas for data governance is to automatically extract tables, columns, and constraints from your SQL files to produce a structured Markdown dictionary for audits and compliance.

Does the data dictionary generator work with existing SQL schema files?▼

Yes, the data dictionary generator works with existing SQL schema files and migrations, auto-discovering your database structure to output comprehensive documentation without needing a live database connection.

How do I document database columns and constraints for analytics onboarding?▼

Document database columns and constraints for analytics onboarding by running this tool against your PostgreSQL schemas to generate a readable Markdown dictionary with column descriptions and relationship patterns.

Related Skills

Explore More Data & Analytics Skills→
xloxn69xloxn69
7

sql-schema-generator

Generate SQL schemas, migrations, and table definitions with DDL constraints.

Community
Basic
wfukatsuwfukatsu
5

er-diagram-analysis

Generate Mermaid ER diagrams and entity catalogs from codebases or database models.

Community
Intermediate
mozilor-technologiesmozilor-technologies

postgres-patterns

Review PostgreSQL queries, security policies, and indexing strategies.

Official
Advanced
ladinglogichqladinglogichq

schema-exploration

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

Official
Intermediate