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

0•

データベース管理

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

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.

主な機能

01Data integrity enforcement through complex constraints and exclusion patterns

02Query performance analysis using EXPLAIN and advanced optimization techniques

03Comprehensive index design including B-tree, GIN, and covering indexes

040 GitHub stars

05Advanced schema normalization and performance-driven denormalization patterns

06Zero-downtime migration strategies for high-availability production environments

ユースケース

01Optimizing slow SQL queries by analyzing execution plans and implementing targeted indexing

02Architecting a new PostgreSQL schema with normalized tables and foreign key relationships

03Executing safe, batch-processed data migrations without impacting live application performance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add januarfonti/opencode-template-configured database-design

For use in Claude.ai and ChatGPT

Download Skill