Detect Postgres 16/17/18 anti-patterns in PR diffs for concurrency and indexing.
npx skills add https://github.com/mattnowdev/super-review --skill postgres-mattnowdev
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/mattnowdev/super-review/tree/main/skills/postgres Command: npx skills add https://github.com/mattnowdev/super-review --skill postgres-mattnowdev
This Skill helps you avoid production-grade Postgres anti-patterns that cause deadlocks, lock escalation, vacuum bloat, or ineffective indexes.
FOR UPDATE usage, inconsistent lock ordering, and long-lived transactions caused by external I/O inside transactions.SERIALIZABLE and highlights retry/behavior concerns around isolation failures.-> vs ->>), partial index predicate mismatches, and CTE materialization assumptions.MERGE concurrency caveats, virtual generated column indexing issues, and logical replication REPLICA IDENTITY defaults.Ask an AI to review your PR diff for Postgres-related concurrency, transaction, and indexing anti-patterns and return only evidence-backed fixes.
High-intent search queries and answers about installing and using this skill.
Prevent Postgres deadlocks by reviewing PR diffs for inconsistent lock ordering and unsafe FOR UPDATE usage. Targeted detection flags long-lived transactions and lock contention to ensure safe concurrency in application code paths.
JSONB indexing mismatches occur when using the wrong operator, such as -> instead of ->>. Detecting these mismatches in SQL changes ensures query plans correctly leverage JSONB indexes for efficient data retrieval.
pgBouncer transaction pooling does not work safely with session-state constructs. Reviews enforce safe transaction-scoped alternatives, ensuring your SQL changes avoid session-state dependencies that break pgBouncer compatibility.
MERGE concurrency caveats in Postgres 17 involve potential race conditions during concurrent execution. Reviewing MERGE statements in PR diffs detects unsafe concurrency patterns and provides guidance for safe transaction handling.
Handling SERIALIZABLE transaction isolation requires retry logic for isolation failures. Reviews detect missing retry mechanisms around SERIALIZABLE transactions to prevent data loss during concurrency conflicts.
Review logical replication REPLICA IDENTITY defaults when modifying tables involved in replication. Detection highlights unsafe defaults in Postgres 17/18 feature usage to prevent replication gaps during database migrations.
motoki317Provide SQL patterns for database design, querying, and migrations across PostgreSQL, MySQL, and SQLite.
iadr-devCorrect Supabase Postgres query, indexing, schema, and concurrency anti-patterns.
jacob-balslevSize connection pools and diagnose failure modes for Postgres/MySQL workloads.
interflownexAnalyze PostgreSQL performance on Google Cloud SQL using PromQL and pg_stat_activity.