Can it generate visual representations of the database?

Yes, it can generate ER diagrams in Mermaid format, which can be easily rendered in Markdown viewers or documentation tools.

What migration tools does this skill support?

The skill supports popular Go-based tools including golang-migrate, goose, sql-migrate, and Atlas, as well as standard SQL schema files.

Do I need a live database connection to use this?

No, this skill performs static analysis of the migration and schema files located within your project repository.

How does it help with project onboarding?

It identifies all tables, columns, and relationships, providing a high-level overview and a detailed catalog of the data model so new developers understand the architecture instantly.

Can it identify complex table relationships?

Yes, it specifically looks for foreign keys and join patterns to map one-to-many, many-to-many, and self-referencing relationships.

Database Schema Architect

Name: Database Schema Architect
Author: runxgalee

byrunxgalee

データベース管理

Analyzes database schemas and migration files to visualize data models, map table relationships, and accelerate developer onboarding.

概要

The Database Schema Architect skill empowers developers to quickly master a project's data layer by scanning migration files and schema definitions. It automatically detects popular migration tools like golang-migrate, Goose, and Atlas, identifies complex foreign key relationships, and generates comprehensive reports including Mermaid-formatted ER diagrams. Whether you're joining a new project or auditing an existing one, this skill provides a clear roadmap of table structures, indexes, and schema evolution without requiring a live database connection.

主な機能

Comprehensive mapping of foreign key relationships and table dependencies
Chronological migration history analysis to understand schema evolution
Detailed table cataloging including column types, constraints, and indexes
Generation of visual ER diagrams using Mermaid syntax for documentation
Automated detection of Go-based migration tools like golang-migrate, Goose, and Atlas
0 GitHub stars

ユースケース

Onboarding to a new codebase by quickly mapping out the underlying data model
Auditing database performance and optimization through index and constraint review
Generating up-to-date database documentation and ER diagrams for architectural reviews

概要

主な機能

Comprehensive mapping of foreign key relationships and table dependencies
Chronological migration history analysis to understand schema evolution
Detailed table cataloging including column types, constraints, and indexes
Generation of visual ER diagrams using Mermaid syntax for documentation
Automated detection of Go-based migration tools like golang-migrate, Goose, and Atlas
0 GitHub stars

ユースケース

Onboarding to a new codebase by quickly mapping out the underlying data model
Auditing database performance and optimization through index and constraint review
Generating up-to-date database documentation and ER diagrams for architectural reviews