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
Install
npx skills add Dimon94/skills --skill supabase-postgres-best-practicesgit clone --depth 1 https://github.com/Dimon94/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/skills/supabase-postgres-best-practices ~/.claude/skills/supabase-postgres-best-practicesPersonal 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
Details
- Skill name
supabase-postgres-best-practices- Repository
- Dimon94/skills
- Path
skills/supabase-postgres-best-practices/SKILL.md- Repo updated
- 18 November 2026
FAQ
What does the Supabase Postgres Best Practices skill do?
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
How do I install the Supabase Postgres Best Practices skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add Dimon94/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 Dimon94/skills, which has 107 GitHub stars and 21 forks.
Related skills
Maintain Verification Skill
107Dimon94/skills
Periodic pass that keeps a project's verification skill and feature map honest: parallel source readers per feature, one live session driving every feature, at most one PR of proven corrections. Use for /maintain-verification-skill or "audit the verify skill".
Create Verification Skill
107Dimon94/skills
Generate a project-local verification skill that drives your app the way a user does — any language, framework, or platform. Use for /create-verification-skill, "make a control skill for this repo", or when a project has no scripted way to prove UI/CLI/service behavior.
How
107Dimon94/skills
Use for "how does X work", code walkthroughs before changing something, and placement / ownership / layering questions ("where should this live", "which package owns this", "is this the right layer"). Explains subsystem architecture, runtime flow, onboarding mental models. Use why for motivation.
Dolphindb Skill
36hugo2046/dolphindb_skill
DolphinDB/DolphinScript 的数据库、SQL、流计算、回测与排障技能。用户提到 DolphinDB,或仓库/代码出现 dfs://、createPartitionedTable、context by、streamTable、subscribeTable、createTimeSeriesEngine、DStream::、Backtest:: 等专有线索时调用;已有 DolphinDB 上下文时,即使本轮只说“分区表”“实时 K 线”“回测报错”也要使用。用于按目标 Server/插件版本核对官方 API、选择 OLAP/TSDB/PKEY/IOT,并生成可验证的代码与方案。明确只涉及其他技术栈且无 DolphinDB 上下文时不调用。
Db Ops
43cilangzzz/yudao-skill-pro
yudao-skill-pro 的数据库操作技能:通过解析 application.yaml 自动获取数据库凭证, 本地直连或经 badseal/ssh-skill 中转到 dev/prod 环境执行 SQL,最后通过 SQL 自检验证程序成果。 触发场景: - 用户提出"执行 SQL"、"建表"、"插入数据"、"查询数据"等 - 用户要求"验证程序成果"、"确认表结构"、"对比数据" - 任何涉及 yudao 项目数据库修改、查询、DDL、DML 的请求 实现机制: - 本技能本身不包含可执行脚本,agent 直接调用系统命令(mysql/psql/sqlplus 等) - 远程环境委托给 badseal/ssh-skill(agent 自动检测/安装)
Drupal Ddev
84grasmash/drupal-claude-skills
Provides DDEV local development patterns for Drupal - ddev commands, .ddev/config.yaml, database import/export and snapshots, Drush and Composer through ddev, Xdebug, local Solr, Mutagen performance, and recovery from Docker, Mutagen and router failures. Use when running ddev start/restart/exec/drush/composer, editing .ddev/config.yaml, importing or snapshotting a database, debugging slow or hung DDEV containers, or recovering a local environment after a Docker crash.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.