FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
PostgreSQL best practices: queries, schema and RLS v1.0.0
Use this resource to write, review and optimize PostgreSQL queries, schemas and configuration
New
- 519 downloads
- 234 likes
- 115 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install postgres-performance-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 best-practice rules published by Supabase: indexing, pagination, batch inserts, connections and pooling, N+1 queries and row-level security (RLS). It flags each rule by priority. You get a reasoned review of your queries and schema.
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
- AGENTS.md: compiled rules for use by agents
- rules/: one rule per file, for example pagination, batch inserts or pooling
Good fit for
- You review SQL queries before a production release
- Your database slows down because of connections or pagination
Not for
Tags
- postgres
- sql
- rls
About
You say
“Review this pagination query and this RLS policy, and tell me what to fix.”
Skill published by davila7 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, review and optimize PostgreSQL queries, schemas and configuration
- Review and adjust the result
Content preview
Files
- AGENTS.md45.3 KB
- LICENSE1.1 KB
- metadata.json0.8 KB
- NOTICE-PALATEKIT.md0.5 KB
- README.md3.2 KB
- rules/_contributing.md4.2 KB
- rules/_sections.md1.7 KB
- rules/_template.md1 KB
- rules/advanced-full-text-search.md1.5 KB
- rules/advanced-jsonb-indexing.md1.5 KB
- rules/conn-idle-timeout.md1.3 KB
- rules/conn-limits.md1.3 KB
- rules/conn-pooling.md1.4 KB
- rules/conn-prepared-statements.md1.5 KB
- rules/data-batch-inserts.md1.3 KB
- rules/data-n-plus-one.md1.4 KB
- rules/data-pagination.md1.4 KB
- rules/data-upsert.md1.4 KB
- rules/lock-advisory.md1.5 KB
- rules/lock-deadlock-prevention.md1.9 KB
- rules/lock-short-transactions.md1.4 KB
- rules/lock-skip-locked.md1.4 KB
- rules/monitor-explain-analyze.md1.5 KB
- rules/monitor-pg-stat-statements.md1.4 KB
- rules/monitor-vacuum-analyze.md1.5 KB
- rules/query-composite-indexes.md1.5 KB
- rules/query-covering-indexes.md1.3 KB
- rules/query-index-types.md1.4 KB
- rules/query-missing-indexes.md1.2 KB
- rules/query-partial-indexes.md1.4 KB
- rules/schema-data-types.md1.5 KB
- rules/schema-foreign-key-indexes.md1.7 KB
- rules/schema-lowercase-identifiers.md1.7 KB
- rules/schema-partitioning.md1.6 KB
- rules/schema-primary-keys.md1.8 KB
- rules/security-privileges.md1.6 KB
- rules/security-rls-basics.md1.4 KB
- rules/security-rls-performance.md1.5 KB
- SKILL.md1.9 KB
Origin and licence
Listed unmodified
- Author
- davila7
- Source
- github.com/davila7/claude-code-templates/tree/f57964ebda91cdfb31755661ecea9395f30020f1/cli-tool/components/skills/development/postgres-best-practices
- Licence
- MIT
Notice
« postgres-best-practices » (davila7, MIT) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…