Can it help me fix slow-running queries?

Absolutely. It includes specific strategies for indexing, including composite indexes and B-Tree optimization, to significantly improve query execution times.

Does this skill support both SQL and NoSQL databases?

Yes, it provides comprehensive patterns for relational databases like PostgreSQL and MySQL, as well as document-based NoSQL systems, helping you choose the right approach for your use case.

Does it follow standard normalization rules?

Yes, it guides you through 1NF, 2NF, and 3NF to reduce data redundancy, while also identifying scenarios where denormalization might be beneficial for performance.

How does it handle database migrations?

It emphasizes reversible and backward-compatible migration patterns, ensuring that schema changes can be rolled back safely and don't break existing application code.

Database Schema Designer

Name: Database Schema Designer
Author: yonatangross

byyonatangross

•

Database Management

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

The Database Schema Designer skill transforms Claude into an expert database engineer capable of architecting scalable data models and optimizing complex query structures. It provides comprehensive guidance on choosing between SQL and NoSQL approaches, implementing normalization (1NF, 2NF, 3NF), and establishing strategic indexing to resolve performance bottlenecks. By following production-ready patterns for migrations and data integrity, this skill ensures that your application's data layer remains maintainable, performant, and resilient as your project evolves.

Key Features

01Comprehensive SQL and NoSQL schema design and entity modeling

02Data integrity enforcement via constraints, foreign keys, and validation

03Safe, reversible migration strategies for production environments

04Strategic indexing patterns for optimizing slow queries and composite searches

0569 GitHub stars

06Database normalization guidance for 1NF, 2NF, and 3rd Normal Form

Use Cases

01Refactoring legacy schemas to improve performance and remove data redundancy

02Designing a high-performance relational database for a new SaaS application

03Planning zero-downtime migrations for evolving production databases

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