Which database engines are supported by this skill?

The skill provides patterns and best practices applicable to most relational databases, with specific advanced optimizations for PostgreSQL and MySQL.

When should I use normalization vs denormalization according to this skill?

It recommends 3rd Normal Form (3NF) for transactional (OLTP) systems to ensure data integrity, while suggesting selective denormalization for read-heavy analytical (OLAP) workloads.

How does this skill help with performance tuning?

It provides guidance on interpreting EXPLAIN ANALYZE output, identifying table scans, and implementing the correct index types to reduce query latency.

Can it help me with Django or SQLAlchemy specifically?

Yes, it includes specialized patterns for popular Python ORMs, focusing on eager loading strategies and efficient model definitions.

Does it provide advice on zero-downtime migrations?

Absolutely. It covers best practices for adding columns to large tables without locking, backfilling data in batches, and managing reversible migrations.

Database Design & Optimization

Name: Database Design & Optimization
Author: akaszubski

byakaszubski

•

Database Management

Architects scalable database schemas, optimizes SQL queries, and manages complex data migrations using industry best practices.

The Database Design skill empowers Claude to act as a senior database architect, providing deep expertise in relational database modeling, performance tuning, and ORM integration. It offers comprehensive guidance on normalization strategies, sophisticated indexing patterns (including B-Tree, GIN, and Partial indexes), and techniques for resolving common bottlenecks like the N+1 query problem. Whether you are building a new system from scratch, refactoring legacy schemas, or executing high-stakes migrations with zero downtime, this skill ensures your data layer remains performant, consistent, and scalable.

Key Features

01Sophisticated indexing patterns for B-Tree, GIN, and Composite indexes

02Deep ORM implementation patterns for SQLAlchemy and Django

03Safe migration workflows and zero-downtime data transformations

04Query profiling and optimization using EXPLAIN ANALYZE

052 GitHub stars

06Advanced schema normalization and denormalization strategies

Use Cases

01Optimizing slow-running SQL queries in production environments

02Refactoring ORM code to eliminate performance-degrading N+1 query issues

03Designing a high-performance multi-tenant schema for SaaS applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add akaszubski/anyclaude-local database-design

For use in Claude.ai and ChatGPT

Download Skill