Supabase Postgres Best Practices

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection

2,971 stars 258 forksDatabasesOfficial

Install

skills CLI (Claude Code, Cursor, Codex and more)

npx skills add supabase/agent-skills --skill supabase-postgres-best-practices

Manual install

git clone --depth 1 https://github.com/supabase/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/supabase-postgres-best-practices ~/.claude/skills/supabase-postgres-best-practices

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 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

| Priority | Category | Impact | Prefix |
|----------|----------|--------|--------|
| 1 | Query Performance | CRITICAL | `query-` |
| 2 | Connection Management | CRITICAL | `conn-` |
| 3 | Security & RLS | CRITICAL | `security-` |
| 4 | Schema Design | HIGH | `schema-` |
| 5 | Concurrency & Locking | MEDIUM-HIGH | `lock-` |
| 6 | Data Access Patterns | MEDIUM | `data-` |
| 7 | Monitoring & Diagnostics | LOW-MEDIUM | `monitor-` |
| 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

Read the full skill on GitHub

Details

Skill name: supabase-postgres-best-practices
Repository: supabase/agent-skills
Path: skills/supabase-postgres-best-practices/SKILL.md
License: MIT
Repo updated: 2 October 2026
Listed in: heilcheng/awesome-agent-skills, skillmatic-ai/awesome-agent-skills

FAQ

What does the Supabase Postgres Best Practices skill do?

How do I install the Supabase Postgres Best Practices skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add supabase/agent-skills --skill supabase-postgres-best-practices. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Supabase Postgres Best Practices popular?

It lives in supabase/agent-skills, which has 2,971 GitHub stars and 258 forks, and is included in 2 curated skill lists.

Related skills

Claimable Postgres

659

neondatabase/mcp-server-neon

Provision instant temporary Postgres databases via Claimable Postgres by Neon (neon.new) with no login, signup, or credit card. Supports REST API, CLI, and SDK. Use when users ask for a quick Postgres environment, a throwaway DATABASE_URL for prototyping/tests, or "just give me a DB now". Triggers include: "quick postgres", "temporary postgres", "no signup database", "no credit card database", "instant DATABASE_URL", "npx neon-new", "neon.new", "neon.new API", "claimable postgres API".

DatabasesIn 1 list133

SQL Pro

12k

Jeffallan/claude-skills

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between database dialects (PostgreSQL, MySQL, SQL Server, Oracle).

DatabasesIn 3 lists1.2k

Wx Favorites Report

642

zhuyansen/wx-favorites-report

微信收藏可视化：从加密的微信本地数据库端到端解密、解析，生成交互式 HTML 可视化报告。触发词：/wx-favorites-report、微信收藏可视化、收藏报告、收藏分析支持输入：加密/解密后的 Favorite.db（SQLite）或 CSV/JSON 导出文件

Databases134

Postgres Pro

12k

Jeffallan/claude-skills

Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.

DatabasesIn 3 lists1.2k

Mssql

448

sanjay3290/ai-skills

Execute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

DatabasesIn 4 lists49

SQL Queries

28k

phuryn/pm-skills

Generate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or translating business questions into queries.

DatabasesIn 3 lists2.9k

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.