FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
Database query tuning v1.0.0
Use this resource to tune slow database queries
New
- 429 downloads
- 249 likes
- 200 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install optimize-database-queriesWith 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 reads execution plans with EXPLAIN ANALYZE, measures P50, P95 and P99 latency, then proposes indexes, query rewrites and fixes for N+1 patterns. You get a performance report with the trade-offs of each change.
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: analysis method, critical thresholds and rewrite rules
- reference/: EXPLAIN ANALYZE guide, connection pool tuning, materialized views and ORM pitfalls
Good fit for
- A page takes several seconds to load because of one query
- You want to choose which indexes to add without slowing writes
Not for
Tags
- sql queries
- indexes
- performance
- explain analyze
About
You say
“This query on the orders table takes 4 seconds: analyze the plan and suggest an index.”
Skill published by simota 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 tune slow database queries
- Review and adjust the result
Content preview
Files
- LICENSE1 KB
- NOTICE-PALATEKIT.md0.4 KB
- reference/cache-strategy.md7.4 KB
- reference/cloud-db-optimization-patterns.md14.5 KB
- reference/connection-pool-tuning.md13.9 KB
- reference/db-monitoring-observability.md5.4 KB
- reference/db-specific-query-visualization.md2.8 KB
- reference/explain-analyze-guide.md1.5 KB
- reference/fix-prompt-generation.md8.5 KB
- reference/materialized-views-partitioning.md2.4 KB
- reference/n1-detection-cache-orm.md2 KB
- reference/optimization-patterns.md2.9 KB
- reference/orm-performance-pitfalls.md7.1 KB
- reference/performance-report-template.md0.9 KB
- reference/postgresql-17-performance.md3.5 KB
- reference/postgresql-18-performance.md13.5 KB
- reference/postgresql-19-preview.md4.3 KB
- reference/query-index-anti-patterns.md2.4 KB
- reference/slow-query-benchmarks.md13.2 KB
- reference/vacuum-autovacuum-tuning.md9.1 KB
- reference/vector-search-query-optimization.md10 KB
- reference/workflow-detail.md1.3 KB
- SKILL.md22.8 KB
Origin and licence
Listed unmodified
- Author
- simota
- Source
- github.com/simota/agent-skills/tree/2e02cc9efb3852a45334495df3784d59b87b0e18/tuner
- Licence
- MIT
Notice
« tuner » (simota, MIT) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…