postgres-best-practices

Optimize Postgres query performance by identifying missing indexes, correcting inappropriate index types, and resolving suboptimal partitioning. This skill analyzes your schema and query workloads to recommend precise automated improvements for accelerating analytics.

Manage Postgres connection pooling by surveying your operational environment to identify misconfigured pools. This skill provides structured guidance on connection management to resolve bottlenecks and improve database reliability under concurrent workloads.

Secure multi-tenant databases using Postgres Row Level Security (RLS) policies by applying structured security best practices. This skill evaluates your data access patterns and RLS configurations to ensure proper isolation and referential integrity across tenants.

You need table partitioning in Postgres when preparing scalable schemas for growth and large datasets. This skill evaluates your schema design and data access patterns to determine if partitioning is appropriate for improving maintenance and query speed.

Postgres vacuum stalls when maintenance workflows are misconfigured or statistics are outdated. This skill offers monitoring and diagnostics guidance to tune maintenance operations, ensuring statistics are updated and database performance remains stable.

You can run a quick Postgres health check by surveying your existing indexes, statistics, and RLS policies. This skill requires access to your database schema and operational environment to tailor recommendations and implement the top three optimizations.