Use this skill as a thin workflow wrapper around the bundled Supabase reference notes. The reference files contain the detailed SQL guidance; this file tells Codex when to load them and how to apply them.

When to Apply

Use this skill when the task involves any of the following:

Writing or reviewing SQL, migrations, functions, triggers, or views
Designing tables, indexes, constraints, partitions, or primary keys
Optimizing slow queries or diagnosing Postgres performance issues
Reviewing Row Level Security or privilege design
Choosing connection pooling, prepared statement, or concurrency patterns
Working in Supabase-backed applications where Postgres behavior matters

Rule Categories by Priority

Start with the highest-impact category that matches the task:

Prefix	Category	Use For
`query-`	Query performance	Missing indexes, bad plans, scans, index strategy

When to Apply

Use this skill when the task involves any of the following:

Writing or reviewing SQL, migrations, functions, triggers, or views
Designing tables, indexes, constraints, partitions, or primary keys
Optimizing slow queries or diagnosing Postgres performance issues
Reviewing Row Level Security or privilege design
Choosing connection pooling, prepared statement, or concurrency patterns
Working in Supabase-backed applications where Postgres behavior matters

Rule Categories by Priority

Start with the highest-impact category that matches the task:

Prefix	Category	Use For
`query-`	Query performance	Missing indexes, bad plans, scans, index strategy

Supabase Postgres Best Practices

When to Apply

Rule Categories by Priority

Supabase Postgres Best Practices

When to Apply

Rule Categories by Priority

How to Use

Working Style

References

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns