supabase-postgres-best-practices
Review PostgreSQL design and performance by priority
Source: supabase
At a glance
- Best for
- Eight categories of PostgreSQL rules ranked by impact
- Works with
- SQL, schemas, RLS policies, or performance issues · EXPLAIN output and connection diagnostics (optional)
- Outcome
- Database-design and query recommendations · Rule references and example changes
- Source
- supabase/agent-skills
01 / Understand the skill
About supabase-postgres-best-practices
A PostgreSQL guide maintained by Supabase covering queries, connections, RLS, schemas, concurrency, access patterns, and diagnostics, with correct and incorrect SQL examples in supporting rule files.
Requirements
- Install the complete references rule files
- Reading the guide does not require a database connection; executing SQL requires appropriate permissions
- Applies to PostgreSQL; SQLite and Cloudflare D1 are not listed as verified targets
Inputs
- SQL, schemas, RLS policies, or performance issues
- EXPLAIN output and connection diagnostics (optional)
Outputs
- Database-design and query recommendations
- Rule references and example changes
02 / Confirm the fit
Use supabase-postgres-best-practices when you need to
- Eight categories of PostgreSQL rules ranked by impact
- Index, connection, and RLS guidance
- Correct and incorrect SQL examples and diagnostic guidance
03 / See the workflow
How supabase-postgres-best-practices works
- 01Define the PostgreSQL task and version environment
- 02Read the rules for the relevant priority
- 03Review recommendations, then validate in a controlled environment
Check before installing
Compatible platforms
Cursor · GitHub Copilot · Claude Code
Best fit
Eight categories of PostgreSQL rules ranked by impact
Review the source instructions if the required output differs from the formats described above.
Install and use
Compatible with Cursor and GitHub Copilot and Claude Code · Published by supabase
Ready to add supabase-postgres-best-practices?
Use the published instructions below, then provide the required input and describe the result you need.
General instructions · Cursor · GitHub Copilot · Claude Code
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices The upstream README's Skills CLI installation, limited to this Skill. Installation has not been run.
Review the source repository and license before installing third-party skills.
Continue exploring
Similar skills
Authoritative reference for the Claude API and Anthropic SDKs: model IDs, pricing, thinking/effort params, streaming, tool use, caching, managed agents, and model migration.
Read, edit, create, and fix Excel/CSV files — formulas, formatting, charts, and clean financial models with zero formula errors.
Generate distinctive, production-grade frontend UI that avoids generic AI aesthetics — pages, components, dashboards, and landing pages.
Build high-quality MCP (Model Context Protocol) servers in Python (FastMCP) or Node/TypeScript that let LLMs use external services through well-designed tools.