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

•

Database Management

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.

Key Features

01Query performance analysis using EXPLAIN and cost metrics

02Data integrity enforcement via complex constraints and triggers

032 GitHub stars

04Zero-downtime migration templates and safe SQL patterns

05Advanced index patterns (B-tree, GIN, Partial, Covering)

06Schema normalization and ERD design principles

Use Cases

01Executing complex schema refactors without interrupting service availability

02Designing a scalable relational schema for a new production application

03Optimizing slow SQL queries and identifying missing indexes in existing databases

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add plurigrid/asi database-design

For use in Claude.ai and ChatGPT

Download Skill