Does this skill support both SQL and NoSQL databases?

Yes, it provides specialized guidance for both relational SQL databases like PostgreSQL and MySQL, as well as NoSQL systems like MongoDB and DynamoDB.

Can it help with zero-downtime migrations?

Absolutely. The skill includes best practices for creating backward-compatible and reversible migrations to ensure schema changes don't interrupt your service.

How does it improve database performance?

It provides strategies for strategic indexing, read/write optimization, and partitioning to ensure your database can scale with your application's growth.

Does it provide templates for table creation?

Yes, it includes standardized patterns for creating tables with primary keys, foreign keys, constraints, and audit columns like created_at and updated_at.

What is the normalization philosophy used?

The skill defaults to 3rd Normal Form (3NF) for transactional (OLTP) systems to reduce data redundancy and maintain high integrity, while offering denormalization strategies for analytical (OLAP) workloads.

Database Schema Designer

Name: Database Schema Designer
Author: yonatangross

byyonatangross

•

データベース管理

Designs and optimizes scalable SQL and NoSQL database schemas with a focus on normalization, performance, and robust migration patterns.

概要

The Database Schema Designer skill transforms Claude into a specialized database engineer capable of architecting production-ready data models. It provides a comprehensive framework for designing schemas from scratch, refactoring legacy structures, and planning complex migrations while maintaining data integrity. By enforcing core principles like 3NF normalization, strategic indexing, and backward-compatible changes, this skill ensures your database layer is performant, scalable, and maintainable across both relational and non-relational environments.

主な機能

Multi-paradigm support for both SQL (PostgreSQL, MySQL) and NoSQL (MongoDB, DynamoDB) architectures
Guided normalization workflows ensuring 1st, 2nd, and 3rd Normal Form (3NF) compliance
Advanced indexing strategies including composite index ordering and selective indexing
Production-ready migration patterns focusing on reversibility and zero-downtime changes
Comprehensive integrity enforcement using constraints, foreign keys, and validation logic
29 GitHub stars

ユースケース

Refactoring existing monolithic databases into optimized, microservices-ready data structures
Designing a scalable relational database schema for a new high-traffic SaaS application
Planning and writing safe database migrations to add features without breaking production environments

概要

主な機能

Multi-paradigm support for both SQL (PostgreSQL, MySQL) and NoSQL (MongoDB, DynamoDB) architectures
Guided normalization workflows ensuring 1st, 2nd, and 3rd Normal Form (3NF) compliance
Advanced indexing strategies including composite index ordering and selective indexing
Production-ready migration patterns focusing on reversibility and zero-downtime changes
Comprehensive integrity enforcement using constraints, foreign keys, and validation logic
29 GitHub stars

ユースケース

Refactoring existing monolithic databases into optimized, microservices-ready data structures
Designing a scalable relational database schema for a new high-traffic SaaS application
Planning and writing safe database migrations to add features without breaking production environments