PostgreSQL Query Optimizer
SkillSuggests indexes, EXPLAIN insights, and ActiveRecord query rewrites.
About this skill
Turns slow Postgres queries and heavy ActiveRecord scopes into concrete optimization plans with index recommendations, join strategies, and safer eager-loading patterns.
Skill preview
This is a short excerpt. Full instructions are available after you add the skill to your workspace.
When to use
Invoke for slow endpoints, timeouts, high-cost queries in logs, or heavy ActiveRecord scopes on PostgreSQL.
Inputs
- The SQL,
EXPLAIN (ANALYZE, BUFFERS)output, or the ActiveRecord scope/relation code. - Approximate table sizes, typical and worst-case row counts, and existing indexes (request
\d tableif unknown). - Whether the query is read-heavy, write-heavy, or both, and any latenc…
postgres
sql
performance
Use this skill in your AI tools
Sign in to add this skill to your Knotr workspace and expose it through your MCP profiles.