Design and optimize PostgreSQL queries, indexes, and migrations.
npx skills add https://github.com/kid-sid/claude-spellbook --skill postgresql-kid-sid
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/kid-sid/claude-spellbook/tree/main/skills/postgresql Command: npx skills add https://github.com/kid-sid/claude-spellbook --skill postgresql-kid-sid
Complex PostgreSQL workloads require efficient querying, robust indexing, and safe migrations to scale with data growth.
Run practical examples to optimize a PostgreSQL workload in your project.
High-intent search queries and answers about installing and using this skill.
Diagnose slow PostgreSQL queries by running EXPLAIN ANALYZE to reveal execution plans, identify sequential scans, and evaluate index usage. This Skill provides practical patterns to interpret query plans and apply index-driven optimizations for large datasets.
Safe PostgreSQL migrations for high-traffic apps require concurrency strategies that avoid table locks and data loss. This Skill provides patterns for schema changes and upserts to ensure reliability during deployment.
Optimize JSONB queries in PostgreSQL by designing partial and JSONB-based indexes to target specific keys. This Skill offers practical examples for indexing JSONB data structures and improving query performance.
CTEs and window functions handle complex analytical queries across large PostgreSQL datasets. This Skill demonstrates set-based operations and advanced querying patterns to compute aggregations and rankings efficiently.
Use PostgreSQL upsert patterns when inserting records that might conflict with existing data, requiring conditional updates. This Skill details upsert implementations for high-traffic apps to maintain data integrity without separate queries.
Yes, designing partial indexes is covered to optimize PostgreSQL performance by indexing only relevant rows. This Skill provides index design best practices to reduce storage overhead and accelerate filtered queries.
voidrotAnalyze and optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.
djankiesOptimize Prisma queries with indexes, batching, and cursor pagination.
EIS-ITSGenerate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.
williamzujkowskiAnalyze SQL and NoSQL queries, indexing, and schema design for PostgreSQL, MySQL, MongoDB, and Redis.
