database-reviewer

PostgreSQL query optimization involves analyzing query plans, adding appropriate indexes, and tuning SQL for speed. This skill provides actionable guidance on indexing strategies and query tuning to resolve slow queries and improve overall database performance.

Row Level Security (RLS) in PostgreSQL restricts data access at the row level based on user roles. This skill advises on RLS implementations, permission models, and least-privilege policies to enforce security best practices for multi-tenant or shared database schemas.

Designing a scalable PostgreSQL schema requires robust constraints, proper data-type selection, and normalization. This skill proposes maintainable schema designs and integrity rules to prevent brittle structures and reduce long-term maintenance headaches.

Auditing SQL queries and migrations for security involves reviewing access control policies and permission models. This skill evaluates your PostgreSQL setup to enforce least-privilege permissions and refine security policies across both small projects and multi-tenant deployments.

You need to add PostgreSQL indexes when query performance degrades due to full table scans or missing access paths. This skill reviews your sample queries and schema definitions to recommend appropriate indexing strategies and tune queries for speed.