Postgres performance and security

Workflow

Supabase’s Postgres guide supplies rules and SQL examples for query performance, connections, security, schema design and locking. It applies to Postgres beyond Supabase-hosted projects.

Run this command in your project after reviewing the instructions and access terms. Install complete upstream directories to keep referenced rules and scripts.

npx skills add https://github.com/supabase/agent-skills/tree/c9be0e931b7930f7d02126d04774d904c381e7d7/skills/supabase-postgres-best-practices --skill supabase-postgres-best-practices --agent claude-code

Project file: .claude/skills/supabase-postgres-best-practices/SKILL.md

This brief helps you choose the skill. Read the complete upstream SKILL.md and companion files for its actual instructions.

# Postgres performance and security (supabase-postgres-best-practices)
Supabase’s Postgres guide supplies rules and SQL examples for query performance, connections, security, schema design and locking. It applies to Postgres beyond Supabase-hosted projects.

## Use when
- Write or review Postgres queries, migrations or security policies.
- Diagnose slow queries or connection exhaustion.

## Required inputs
- Schema, queries and query plans
- Postgres version and workload constraints

## Prerequisites
- A Postgres project and representative queries or schema.
- A test database for executing changes; keep the referenced rule collection.

## Expected outputs
- SQL or schema recommendations
- Relevant performance and access-control checks

Source: https://github.com/supabase/agent-skills/blob/c9be0e931b7930f7d02126d04774d904c381e7d7/skills/supabase-postgres-best-practices/SKILL.md
Full SKILL.md: https://agenttaste.dev/skills/supabase-postgres-best-practices/SKILL.md