Which databases does this skill support?

It supports major relational and non-relational systems including PostgreSQL, MySQL, MongoDB, and Amazon DynamoDB.

Can it detect normalization issues?

Absolutely. It analyzes schemas for 1NF, 2NF, 3NF, and BCNF compliance to prevent data anomalies and ensure structural integrity.

Can it help with slow query performance?

Yes, it performs index gap analysis and recommends composite, covering, or partial indexes to optimize specific query execution paths.

Does it generate visual diagrams?

Yes, it can automatically generate Entity Relationship Diagrams (ERDs) using Mermaid syntax to help you visualize and document your database structure.

How does it handle production migrations?

It implements the expand-contract pattern, allowing you to add columns, backfill data, and remove old structures in phases to ensure zero-downtime deployments.

Database Designer

Name: Database Designer
Author: borghei

byborghei

•

Database Management

Architects, optimizes, and migrates professional database schemas for SQL and NoSQL systems using expert-level design patterns.

Database Designer is a comprehensive engineering skill for Claude Code that streamlines the complex process of architecting scalable data layers. It provides automated normalization analysis, intelligent indexing strategies, and zero-downtime migration planning for PostgreSQL, MySQL, MongoDB, and DynamoDB. Whether you are building a new application from scratch or refactoring a legacy system for performance, this skill ensures your database follows industry best practices like BCNF compliance and efficient query execution patterns.

Key Features

01Intelligent Index Strategy (B-Tree, Hash, Composite, and Partial)

02Automated Normalization Analysis (1NF through BCNF)

0350 GitHub stars

04Automatic ERD Generation using Mermaid diagram syntax

05Support for SQL and NoSQL (PostgreSQL, MySQL, MongoDB, DynamoDB)

06Zero-Downtime Migration Generation via Expand-Contract patterns

Use Cases

01Architecting a new relational schema for a complex multi-tenant SaaS application.

02Planning a safe data migration to refactor legacy table structures without application downtime.

03Optimizing slow-running production queries by identifying missing or redundant indexes.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add borghei/claude-skills database-designer

For use in Claude.ai and ChatGPT

Download Skill