What level of normalization does this skill follow?

It defaults to 3rd Normal Form (3NF) to ensure data integrity, while providing guidance on when strategic denormalization might be appropriate for performance.

How does it handle common schema errors?

The skill identifies 12 critical errors, including missing primary keys, VARCHAR(MAX) overuse, and improper date storage, providing immediate code fixes for each.

Does this skill support both PostgreSQL and MySQL?

Yes, it provides specific data type recommendations and syntax patterns for both PostgreSQL and MySQL, including differences in UUID and timestamp handling.

Can it help with existing database performance issues?

Absolutely. It includes checks for missing foreign key indexes, which is one of the most common causes of slow JOIN performance.

Database Schema Design

Name: Database Schema Design
Author: secondsky

bysecondsky

•

数据库管理

Designs and optimizes production-ready PostgreSQL and MySQL database schemas using normalization and performance best practices.

关于

This skill provides comprehensive guidance for architecting robust relational databases, focusing on PostgreSQL and MySQL. It empowers Claude to implement strict normalization (up to 3NF), enforce referential integrity with explicit foreign keys, and avoid common anti-patterns like EAV or improper data types. Whether you are building a new system from scratch or reviewing an existing schema for performance bottlenecks, this skill ensures your database architecture is scalable, maintainable, and follows industry-standard naming conventions and audit patterns.

主要功能

Optimized index recommendations for foreign keys and frequent query paths.
Automated normalization up to 3NF to eliminate data redundancy and anomalies.
21 GitHub stars
Identification and correction of common anti-patterns like EAV and polymorphic associations.
Standardized audit patterns including automatic created_at and updated_at columns.
Implementation of referential integrity with explicit foreign keys and cascade rules.

使用场景

Generating migration scripts with proper PostgreSQL/MySQL data types and check constraints.
Designing a new relational database for a multi-tenant SaaS application.
Refactoring a legacy schema to fix missing constraints and improve join performance.

关于

主要功能

Optimized index recommendations for foreign keys and frequent query paths.
Automated normalization up to 3NF to eliminate data redundancy and anomalies.
21 GitHub stars
Identification and correction of common anti-patterns like EAV and polymorphic associations.
Standardized audit patterns including automatic created_at and updated_at columns.
Implementation of referential integrity with explicit foreign keys and cascade rules.

使用场景

Generating migration scripts with proper PostgreSQL/MySQL data types and check constraints.
Designing a new relational database for a multi-tenant SaaS application.
Refactoring a legacy schema to fix missing constraints and improve join performance.