Which databases are supported by this skill?

This skill provides specific patterns and best practices for PostgreSQL, MySQL, and general NoSQL database structures.

Can this skill help with existing slow queries?

Yes, it includes guidance for EXPLAIN analysis and specific optimization patterns like keyset pagination, CTEs, and index tuning.

Does it support zero-downtime migrations?

Absolutely. It provides a five-step strategy for adding columns, backfilling data, and switching read/write logic without service interruptions.

How does it handle data integrity?

The skill provides templates for primary keys, foreign keys with cascades, check constraints, and exclusion constraints to ensure high data consistency.

Database Design & Optimization

Name: Database Design & Optimization
Author: julianromli

byjulianromli

•

101

•

数据库管理

Designs, optimizes, and migrates database schemas for relational and NoSQL systems using expert industry patterns.

This Claude Code Skill provides specialized guidance for architecting robust database systems, ranging from initial schema normalization to advanced query optimization. It assists developers in implementing safe migration patterns, designing efficient indexing strategies (including GIN and partial indexes), and enforcing data integrity through complex constraints. Whether you are building a new application from scratch or scaling an existing production environment, this skill helps ensure your database layer is performant, maintainable, and reliable across PostgreSQL, MySQL, and NoSQL platforms.

主要功能

01Query performance analysis using EXPLAIN and optimization techniques

02Zero-downtime migration patterns and safe SQL transaction templates

03Advanced indexing strategies including composite, partial, and GIN indexes

04Data integrity enforcement via relational constraints and exclusion rules

05Comprehensive normalization and denormalization guidelines (1NF to 3NF)

06101 GitHub stars

使用场景

01Architecting a new multi-tenant SaaS database schema from scratch

02Optimizing slow-running production queries and identifying missing indexes

03Planning and executing complex schema migrations without application downtime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add julianromli/opencode-template database-design

For use in Claude.ai and ChatGPT

Download Skill