Postgres Best Practices

Review slow Postgres queries, indexes, pooling and access policies.

Supabase’s rules help the Agent review PostgreSQL queries and database design, including indexes, connection pools, row-level security and lock contention. Rules include problematic examples, suggested changes and explanations to apply to your SQL and query plans.

Example task

Review this slow query and EXPLAIN ANALYZE output. Identify the most useful first change and explain how to measure it.

Upstream project ↗

View or edit installation request

Send the request to your Agent. It includes the original source, installation scope and a verification task.

View or edit installation request

Please install and help me use Postgres Best Practices (supabase) in my current agent environment.
Upstream: https://github.com/supabase/agent-skills
Exact source: https://github.com/supabase/agent-skills/tree/8331f910845103c08d51f6ca1d86ebb7d1f745e3/skills/supabase-postgres-best-practices
Installation guide: https://github.com/supabase/agent-skills#readme
Reviewed source revision: 8331f910845103c08d51f6ca1d86ebb7d1f745e3 (2026-09-16)
Installation unit: Complete skills/supabase-postgres-best-practices directory with referenced files and resources. Follow the upstream README for required dependencies; add companion Skills only when the task needs them.
Minimal verification: Verify one change against a query plan in a test database and retain the before-and-after output.

Read the upstream instructions, check compatibility and required resources, and prefer project scope where supported. Install the complete skill directory or required tool package, including mandatory dependencies. If the current revision differs, check the changes first. Keep existing configuration and explain any conflicting setup. Ask me for credentials only if needed, in my local agent session. Verify discovery/connection and run a minimal task; report what was actually verified and how to use it.

My task:

Sources & verification2026-09-16

Publisher casesSupabase rules and query examples ↗

Maintainer examples of concrete Postgres anti-patterns and rules. These reflect engineering experience, not a single measured speedup for the Skill.

Installation guide ↗Reviewed source ↗

Source revision: 8331f9108451
License: MIT
Repository stars: 2617

My reading

Start a learning journey

Your next good read

Pick up where you left off

Postgres Best Practices

Example task