Does this skill only work with PostgreSQL?

While the specific syntax and advanced features like GIN indexes and EXPLAIN BUFFERS are tailored for PostgreSQL, the fundamental normalization and indexing principles are applicable to most relational databases.

How does it handle large-scale data migrations?

The skill provides patterns for 'Safe Migrations,' including using concurrent index creation, batch updates to prevent table locking, and multi-step zero-downtime deployment strategies.

What scientific integrations are included?

The skill includes interleaving patterns for high-performance dataframes like Polars and follows the Cat# (Category Theory) equipment structure for compositional coherence in complex data systems.

Can it help me fix slow database queries?

Yes, it provides tools for EXPLAIN analysis to identify sequential scans, inefficient joins, and buffer usage, alongside specific SQL optimizations like keyset pagination and CTE usage.

Database Design & Optimization

Name: Database Design & Optimization
Author: plurigrid

byplurigrid

•

データベース管理

Architects robust PostgreSQL schemas using expert normalization, indexing strategies, and zero-downtime migration patterns.

概要

The Database Design skill equips Claude with specialized knowledge for building and maintaining high-performance PostgreSQL databases. It provides comprehensive guidance on schema normalization (1NF-3NF), strategic denormalization for read performance, and advanced indexing techniques including GIN, partial, and covering indexes. Beyond basic DDL, the skill offers templates for safe, zero-downtime migrations and deep query optimization using EXPLAIN ANALYZE. It also features unique integration with scientific data workflows and the Cat# equipment structure, making it suitable for both standard application development and complex data-intensive systems.

主な機能

Query performance analysis using EXPLAIN and cost metrics
Data integrity enforcement via complex constraints and triggers
2 GitHub stars
Zero-downtime migration templates and safe SQL patterns
Advanced index patterns (B-tree, GIN, Partial, Covering)
Schema normalization and ERD design principles

ユースケース

Executing complex schema refactors without interrupting service availability
Designing a scalable relational schema for a new production application
Optimizing slow SQL queries and identifying missing indexes in existing databases

概要

主な機能

Query performance analysis using EXPLAIN and cost metrics
Data integrity enforcement via complex constraints and triggers
2 GitHub stars
Zero-downtime migration templates and safe SQL patterns
Advanced index patterns (B-tree, GIN, Partial, Covering)
Schema normalization and ERD design principles

ユースケース

Executing complex schema refactors without interrupting service availability
Designing a scalable relational schema for a new production application
Optimizing slow SQL queries and identifying missing indexes in existing databases