Supabase Postgres Best Practices

syahiidkamil/supabase-postgres-best-practices

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

14k tokens

context cost

the whole folder, loaded on every use

files

instructions only

copies elsewhere

how many repositories repackaged it

314

stars on the repo

on the repository, not the skill itself

Install

one command, takes just this skill from the repository

npx skills add https://github.com/syahiidkamil/Software-Engineer-AI-Agent-Atlas --skill supabase-postgres-best-practices

What comes with it

52 482 bytes besides the instruction

references/_contributing.md

references/_sections.md

references/_template.md

references/advanced-full-text-search.md

references/advanced-jsonb-indexing.md

references/conn-idle-timeout.md

references/conn-limits.md

references/conn-pooling.md

references/conn-prepared-statements.md

references/data-batch-inserts.md

references/data-n-plus-one.md

references/data-pagination.md

references/data-upsert.md

references/lock-advisory.md

references/lock-deadlock-prevention.md

references/lock-short-transactions.md

references/lock-skip-locked.md

references/monitor-explain-analyze.md

references/monitor-pg-stat-statements.md

references/monitor-vacuum-analyze.md

references/query-composite-indexes.md

references/query-covering-indexes.md

references/query-index-types.md

references/query-missing-indexes.md

references/query-partial-indexes.md

references/schema-constraints.md

references/schema-data-types.md

references/schema-foreign-key-indexes.md

references/schema-lowercase-identifiers.md

references/schema-partitioning.md

references/schema-primary-keys.md

references/security-privileges.md

references/security-rls-basics.md

references/security-rls-performance.md

The instruction itself

5 sections, as written by the author

Supabase Postgres Best Practices

Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.

When to Apply

Reference these guidelines when:

Writing SQL queries or designing schemas
Implementing indexes or query optimization
Reviewing database performance issues
Configuring connection pooling or scaling
Optimizing for Postgres-specific features
Working with Row-Level Security (RLS)

Rule Categories by Priority

|----------|----------|--------|--------|

| 8 | Advanced Features | LOW | advanced- |

How to Use

Read individual rule files for detailed explanations and SQL examples:

references/query-missing-indexes.md
references/query-partial-indexes.md
references/_sections.md

Each rule file contains:

Brief explanation of why it matters
Incorrect SQL example with explanation
Correct SQL example with explanation
Optional EXPLAIN output or metrics
Additional context and references
Supabase-specific notes (when applicable)

References

https://www.postgresql.org/docs/current/
https://supabase.com/docs
https://wiki.postgresql.org/wiki/Performance_Optimization
https://supabase.com/docs/guides/database/overview
https://supabase.com/docs/guides/auth/row-level-security

Repackaged in 1 other repositories

same content, different owner

aAAaqwq/AGI-Super-Team open on GitHub →

How to use it

Copy the folder

Take syahiidkamil/supabase-postgres-best-practices from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.