postgresql-code-review

PostgreSQL code review assistant covering JSONB, arrays, custom types, schema design, and security best practices. Expert PostgreSQL code review for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific best practices, anti-patterns, and quality standards that are unique to PostgreSQL. Focus on PostgreSQL's unique capabilities and ensure the code leverages what makes PostgreSQL special rather than treating it as a generic SQL database. - Reviews JSONB operations for indexing efficiency, array usage with GIN indexes, and proper containment operators - Evaluates schema design including ENUM types, CITEXT for case-insensitive data, TIMESTAMPTZ usage, and CHECK constraints - Identifies anti-patterns in function optimization, trigger design, and extension usage - Assesses Row Level Security (RLS) implementation, privilege management, and PostgreSQL-specific security features - Analyzes performance considerations including index strategy, window functions, and PostgreSQL-exclusive optimization techniques - Avoiding PostgreSQL-specific indexes : Not using GIN/GiST for appropriate data types - Misusing JSONB : Treating JSONB like a simple string field - Ignoring array operators : Using inefficient array operations - Poor partition key selection : Not leveraging PostgreSQL partitioning effectively - Not using ENUM types : Using VARCHAR for limited value sets -...