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.