Postgresql Code Review

This is a code review assistant that actually understands PostgreSQL's weird and wonderful features instead of treating it like generic SQL. It'll catch things like missing GIN indexes on your JSONB queries, warn you when you're using VARCHAR instead of CITEXT for emails, and remind you that Row Level Security exists. The examples are solid, showing actual before/after patterns for JSONB operations, array queries, and custom types. It's opinionated about schema design in a good way. Use this when you're working on a Postgres-heavy project and want someone to yell at you for not using ENUM types or for writing data->>'status' queries that can't use indexes. The checklist alone is worth having around.

Install to Claude Code

npx -y skills add syahiidkamil/software-engineer-ai-agent-atlas --skill postgresql-code-review --agent claude-code