FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
Optimize PostgreSQL queries and schema v1.0.0
Use this resource to write and optimize PostgreSQL queries and schemas
New
- 396 downloads
- 247 likes
- 243 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install postgres-query-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 performance rules ranked by impact: indexes, pagination, batch inserts, connection pooling, upserts, advisory locks and full-text search. You get reviewed queries or schemas with the reasoning behind each rule.
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
- rules/data-pagination.md and rules/data-upsert.md: pagination and upserts
- rules/conn-pooling.md and rules/conn-limits.md: pooling and connection limits
- rules/advanced-jsonb-indexing.md: JSONB indexing
Good fit for
- A query slows down as the table grows
- You design a schema and want to avoid connection pitfalls
Not for
Tags
- postgres
- indexes
- queries
- performance
About
You say
“Review this paginated list query and suggest the indexes to add.”
Skill published by julianromli 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 and optimize PostgreSQL queries and schemas
- Review and adjust the result
Content preview
Files
- AGENTS.md45.3 KB
- LICENSE1.3 KB
- NOTICE-PALATEKIT.md0.5 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
- julianromli
- Source
- github.com/julianromli/ai-skills/tree/1a245b1423d9959c83775181febc31b60ed4a157/skills/supabase-postgres-best-practices
- Licence
- MIT
Notice
« supabase-postgres-best-practices » (julianromli, MIT) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…