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

•

Database Management

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.

Key Features

01Multi-paradigm support for both SQL (PostgreSQL, MySQL) and NoSQL (MongoDB, DynamoDB) architectures

02Guided normalization workflows ensuring 1st, 2nd, and 3rd Normal Form (3NF) compliance

03Advanced indexing strategies including composite index ordering and selective indexing

04Production-ready migration patterns focusing on reversibility and zero-downtime changes

05Comprehensive integrity enforcement using constraints, foreign keys, and validation logic

0629 GitHub stars

Use Cases

01Refactoring existing monolithic databases into optimized, microservices-ready data structures

02Designing a scalable relational database schema for a new high-traffic SaaS application

03Planning and writing safe database migrations to add features without breaking production environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yonatangross/skillforge-claude-plugin database-schema-designer

For use in Claude.ai and ChatGPT

Download Skill