Does this skill support both SQL and NoSQL databases?

Yes, while it has deep expertise in PostgreSQL and MySQL, it also provides design patterns and optimization strategies for NoSQL databases.

Can it help me fix slow database queries?

Absolutely. It uses EXPLAIN ANALYZE metrics to identify sequential scans and suggests specific indexing or query rewrites to improve execution time.

Does it provide guidance on data integrity?

Yes, it includes patterns for primary/foreign keys, check constraints, and exclusion constraints to prevent data corruption at the database level.

What is its approach to database migrations?

It follows a safety-first approach using transactions, concurrent index creation, and batching to ensure zero-downtime deployments.

Database Design & Optimization

Name: Database Design & Optimization
Author: julianromli

byjulianromli

•

101

データベース管理

Architects, optimizes, and migrates SQL and NoSQL database schemas using industry-standard best practices for performance and integrity.

概要

The Database Design skill provides Claude with specialized knowledge to handle complex data modeling tasks, ranging from initial schema normalization to advanced query optimization. It offers production-ready patterns for PostgreSQL, MySQL, and NoSQL environments, including sophisticated indexing strategies like GIN and partial indexes. Whether you are building a new application from scratch or refactoring a legacy database for scale, this skill ensures your data layer is robust, performant, and capable of handling zero-downtime migrations.

主な機能

Advanced indexing strategies (Composite, GIN, Partial, and Covering)
Schema normalization and denormalization templates
Zero-downtime migration patterns for high-traffic tables
101 GitHub stars
Data integrity enforcement via complex constraints and exclusion rules
Query performance analysis using EXPLAIN ANALYZE and buffers

ユースケース

Optimizing slow-running SQL queries through index analysis and CTE refactoring
Designing a scalable multi-tenant relational schema for a new SaaS platform
Executing safe, multi-step migrations for adding columns to production databases

概要

主な機能

Advanced indexing strategies (Composite, GIN, Partial, and Covering)
Schema normalization and denormalization templates
Zero-downtime migration patterns for high-traffic tables
101 GitHub stars
Data integrity enforcement via complex constraints and exclusion rules
Query performance analysis using EXPLAIN ANALYZE and buffers

ユースケース

Optimizing slow-running SQL queries through index analysis and CTE refactoring
Designing a scalable multi-tenant relational schema for a new SaaS platform
Executing safe, multi-step migrations for adding columns to production databases