database-reviewer

What problem does it solve?

PostgreSQL database code often suffers from suboptimal performance, brittle schema designs, and inconsistent security policies, leading to slow queries and maintenance headaches.

Core Features & Use Cases

• Query performance: optimize SQL, add appropriate indexes, and tune queries for speed.
• Schema design & integrity: propose robust schemas, constraints, and normalization guidance.
• Security & access control: advise on Row Level Security, roles, and least-privilege permissions for multi-tenant or shared schemas.
• Use Case: A team migrating a monolith to Postgres can rely on this skill to audit queries, refine schemas, and enforce security best practices.

Quick Start

Provide a targeted review of your PostgreSQL setup by sharing sample queries and schema definitions.