What kind of indexing patterns are included?

It covers B-tree, composite, partial, GIN (for JSONB/arrays), and covering indexes, along with methods to analyze index usage and find missing indexes.

Which databases are supported by this skill?

The skill provides patterns and best practices for PostgreSQL, MySQL, and NoSQL databases, with a heavy emphasis on SQL standards and performance.

How does it handle production database migrations?

It includes zero-downtime migration patterns such as adding nullable columns, concurrent index creation, and batch data backfilling to ensure safety in production.

Does it provide guidance on data normalization?

Yes, it covers 1NF, 2NF, and 3NF normalization guidelines, while also providing scenarios where denormalization is preferred for read-heavy performance.

Can this skill help me fix slow database queries?

Yes, it provides detailed guidance on using EXPLAIN ANALYZE to identify bottlenecks and recommends specific indexing or query refactoring strategies to improve speed.

Database Design & Optimization

Name: Database Design & Optimization
Author: januarfonti

byjanuarfonti

Database Management

Designs high-performance database schemas and manages migrations for PostgreSQL, MySQL, and NoSQL systems.

About

This Claude Code Skill provides comprehensive guidance for architecting robust database systems, from initial schema normalization to advanced query optimization. It empowers developers to implement strict data integrity constraints, design efficient indexing strategies, and execute complex zero-downtime migrations with confidence. Whether you are building a new application from scratch or refactoring an existing legacy database, this skill offers production-ready patterns for maximizing read/write performance and ensuring long-term data consistency across multiple database paradigms.

Key Features

Data integrity enforcement through complex constraints and exclusion patterns
Query performance analysis using EXPLAIN and advanced optimization techniques
Comprehensive index design including B-tree, GIN, and covering indexes
0 GitHub stars
Advanced schema normalization and performance-driven denormalization patterns
Zero-downtime migration strategies for high-availability production environments

Use Cases

Optimizing slow SQL queries by analyzing execution plans and implementing targeted indexing
Architecting a new PostgreSQL schema with normalized tables and foreign key relationships
Executing safe, batch-processed data migrations without impacting live application performance

About

Key Features

Data integrity enforcement through complex constraints and exclusion patterns
Query performance analysis using EXPLAIN and advanced optimization techniques
Comprehensive index design including B-tree, GIN, and covering indexes
0 GitHub stars
Advanced schema normalization and performance-driven denormalization patterns
Zero-downtime migration strategies for high-availability production environments

Use Cases

Optimizing slow SQL queries by analyzing execution plans and implementing targeted indexing
Architecting a new PostgreSQL schema with normalized tables and foreign key relationships
Executing safe, batch-processed data migrations without impacting live application performance