What is the benefit of using this skill with Claude Code?

It equips Claude with specialized database engineering expertise, ensuring your data models are normalized, scalable, and follow production-ready standards like 3NF.

How does it handle database migrations?

It follows industry best practices by generating reversible, backward-compatible migration scripts that separate schema changes from data transformations to ensure safe deployments.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive design patterns for relational SQL databases like PostgreSQL and MySQL, as well as document-based NoSQL stores.

Can it help with slow database queries?

Absolutely. The skill includes specific strategies for identifying missing indexes and implementing composite indexes based on query selectivity and column order.

Database Schema Designer

Name: Database Schema Designer
Author: yonatangross

byyonatangross

•

Database Management

Designs and optimizes SQL and NoSQL database schemas with professional-grade normalization, indexing, and migration patterns.

This skill provides Claude with the specialized knowledge required to architect scalable, high-performance database schemas. It guides users through the entire lifecycle of data modeling—from initial entity-relationship design and 3rd Normal Form (3NF) normalization to the creation of robust indexing strategies and safe, reversible migration scripts. Whether building a new application from scratch or refactoring a legacy system for scale, this skill ensures data integrity and performance are baked into the architecture from day one.

Key Features

01Production-ready migration patterns featuring reversible and backward-compatible scripts

02Advanced normalization strategies (1NF, 2NF, 3NF) for data integrity

0369 GitHub stars

04Comprehensive SQL and NoSQL schema modeling and entity-relationship design

05Implementation of database-level constraints, validations, and soft-delete patterns

06Strategic indexing recommendations to optimize query performance and read/write speeds

Use Cases

01Planning and executing complex database migrations without breaking backward compatibility for live services

02Designing a scalable relational schema for a new multi-tenant SaaS application

03Optimizing slow database queries by implementing strategic composite indexes and execution plans

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yonatangross/orchestkit database-schema-designer

For use in Claude.ai and ChatGPT

Download Skill