Can this skill generate Mermaid diagrams?

Yes, it provides structured templates for creating Entity Relationship Diagrams (ERDs) using Mermaid syntax which can be rendered in many Markdown viewers.

Does it support specific database engines like PostgreSQL or MySQL?

While the default templates are optimized for PostgreSQL 14+, the documentation patterns and schema definitions can be easily adapted for any relational database including MySQL, SQL Server, and SQLite.

Is it useful for tracking database migrations?

Absolutely. The skill includes specific templates for documenting schema migrations, version history, and individual migration scripts to keep your documentation in sync with your codebase.

Can it document non-relational or JSON data?

Yes, it specifically includes sections for documenting JSONB structures and complex metadata patterns often used in modern hybrid database designs.

Database Schema Documentation

Name: Database Schema Documentation
Author: aj-geddes

byaj-geddes

•

Database Management

Generates comprehensive database schema documentation, ERD diagrams, and technical data dictionaries for clear data modeling.

About

This skill empowers developers to maintain high-quality database documentation by providing structured templates for entity-relationship diagrams (ERDs), table definitions, and index strategies. It is particularly useful during the design phase of a project, during major migrations, or when onboarding new developers to a complex data model. By automating the creation of detailed table relationships, constraints, and SQL views, it ensures that your system architecture is well-documented and easily reproducible for any team member.

Key Features

Detailed table definitions including data types, defaults, and constraints
18 GitHub stars
Templates for documenting database views, stored procedures, and migration history
Entity Relationship Diagram (ERD) generation using Mermaid syntax
Documentation for SQL indexes, triggers, and performance optimizations
Data dictionary creation for complex JSONB structures and Enum types

Use Cases

Designing and documenting new database features and tables before implementation
Onboarding new developers to projects with complex relational data models
Creating technical specifications for database migrations and schema versioning

About

Key Features

Detailed table definitions including data types, defaults, and constraints
18 GitHub stars
Templates for documenting database views, stored procedures, and migration history
Entity Relationship Diagram (ERD) generation using Mermaid syntax
Documentation for SQL indexes, triggers, and performance optimizations
Data dictionary creation for complex JSONB structures and Enum types

Use Cases

Designing and documenting new database features and tables before implementation
Onboarding new developers to projects with complex relational data models
Creating technical specifications for database migrations and schema versioning