FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
Apply Postgres best practices to schema and queries v1.0.0
Use this resource to write or fix Postgres SQL, schemas or migrations following best practices
New
- 336 downloads
- 190 likes
- 233 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install postgres-best-practices-rulesWith no option, the skill goes to ~/.agents/skills/; add --agent claude-code (or codex, cursor…) to target an agent.
First time: connect the CLI with
npx --yes palatekit@latest loginThe agent applies the Postgres rules maintained by Supabase before writing a schema, query, index, RLS policy or migration. It also helps diagnose slow queries, connection exhaustion or rows visible to the wrong user.
Mostly picked by
Updated November 2, 2026
Previews
Details
- Install guides
- Generates with
- Your agent's model
- Licence
- MIT
Similar resources
View all- Free
FreeSkills
Sentry CLI guide
- 525525 downloads
- 117117 likes
- 128128 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Drizzle ORM best practices with PostgreSQL
- 407407 downloads
- 194194 likes
- 151151 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
SLO design wizard
- 537537 downloads
- 105105 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
User stories and sprint fit
- 451451 downloads
- 150150 likes
- 132132 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Capacity-based sprint plan
- 423423 downloads
- 192192 likes
- 102102 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Startup CTO advisor
- 580580 downloads
- 201201 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Creating GitHub pull requests with quality checks
- 427427 downloads
- 230230 likes
- 196196 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
What you get
- SKILL.md: rule categories ranked by impact
- references/data-pagination.md: pagination
- references/lock-advisory.md: advisory locks
Good fit for
- You are creating a Postgres table or migration
- A query is slow or the database is running out of connections
Not for
Tags
- postgres
- sql
- indexes
- performance
About
You say
“Review this schema and its indexes before the migration, following Postgres best practices.”
Skill published by supabase under the MIT license, delivered in its original version.
Show moreShow less
How to use it
- Install the skill in your agent's skills folder
- Ask your agent to write or fix Postgres SQL, schemas or migrations following best practices
- Review and adjust the result
Content preview
Files
- CHANGELOG.md5.6 KB
- LICENSE1 KB
- NOTICE-PALATEKIT.md0.5 KB
- references/_contributing.md4.2 KB
- references/_sections.md1.7 KB
- references/_template.md1 KB
- references/advanced-full-text-search.md1.5 KB
- references/advanced-jsonb-indexing.md1.5 KB
- references/conn-idle-timeout.md1.3 KB
- references/conn-limits.md1.3 KB
- references/conn-pooling.md1.4 KB
- references/conn-prepared-statements.md1.5 KB
- references/data-batch-inserts.md1.3 KB
- references/data-n-plus-one.md1.4 KB
- references/data-pagination.md1.4 KB
- references/data-upsert.md1.4 KB
- references/lock-advisory.md1.5 KB
- references/lock-deadlock-prevention.md1.9 KB
- references/lock-short-transactions.md1.4 KB
- references/lock-skip-locked.md1.4 KB
- references/monitor-explain-analyze.md1.5 KB
- references/monitor-pg-stat-statements.md1.4 KB
- references/monitor-vacuum-analyze.md1.5 KB
- references/query-composite-indexes.md1.5 KB
- references/query-covering-indexes.md1.3 KB
- references/query-index-types.md1.5 KB
- references/query-missing-indexes.md1.2 KB
- references/query-partial-indexes.md1.4 KB
- references/schema-constraints.md1.9 KB
- references/schema-data-types.md1.5 KB
- references/schema-foreign-key-indexes.md1.7 KB
- references/schema-lowercase-identifiers.md1.7 KB
- references/schema-partitioning.md1.6 KB
- references/schema-primary-keys.md1.8 KB
- references/security-privileges.md1.6 KB
- references/security-rls-basics.md1.4 KB
- references/security-rls-performance.md2.1 KB
- SKILL.md3.2 KB
Origin and licence
Listed unmodified
- Author
- supabase
- Source
- github.com/supabase/agent-skills/tree/c9be0e931b7930f7d02126d04774d904c381e7d7/skills/supabase-postgres-best-practices
- Licence
- MIT
Notice
« supabase-postgres-best-practices » (supabase, MIT) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…