kosolapov.com
All agent resources
FOR AGENTS / Skills

PostgreSQL queries, indexes and access

Review slow SQL, schema design and row-level access. Supabase provides explanations and examples for PostgreSQL, including deployments outside Supabase.

2,603 · GitHubsupabase/agent-skillsEditorial selection · source reviewedAuthor: Supabase MIT Revision 8331f91
USE CASES

When to use it

  1. Read a slow query’s execution plan

  2. Choose indexes for actual filter patterns

  3. Review tenant data isolation

What you’ll get

SQL and schema recommendations with performance and access checks.

For example

Review this EXPLAIN output and order schema. Suggest indexes for our queries and RLS tests for two tenants. Do not change production.
Original, requirements and limits

Original skill: Supabase. Editorial description: kossolapov.com.

Agent
  • An agent that can read Agent Skills instructions; tool access depends on the host
Tools
  • PostgreSQL schema, queries and EXPLAIN plans
  • A separate test database for changes
Access
  • Database access only when execution is requested; use a limited test role
Possible costs
  • A hosted database may incur usage charges
Limits
  • Index advice depends on selectivity, workload and write cost; example speedups are not guarantees.
  • RLS must be tested with real application roles and trusted identity context.
  • Editorial selection based on source inspection, not a comparative performance certification.