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

0•

Database Management

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.

Key Features

01Comprehensive mapping of foreign key relationships and table dependencies

02Chronological migration history analysis to understand schema evolution

03Detailed table cataloging including column types, constraints, and indexes

04Generation of visual ER diagrams using Mermaid syntax for documentation

05Automated detection of Go-based migration tools like golang-migrate, Goose, and Atlas

060 GitHub stars

Use Cases

01Onboarding to a new codebase by quickly mapping out the underlying data model

02Auditing database performance and optimization through index and constraint review

03Generating up-to-date database documentation and ER diagrams for architectural reviews

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add runxgalee/fullstack-dev database-schema

For use in Claude.ai and ChatGPT

Download Skill