Skills
SQL Optimization Patterns
by wshobson
Speed up slow SQL: read EXPLAIN plans, choose indexes, rewrite queries and fix N+1 problems.
Our verdict
We have not reviewed SQL Optimization Patterns yet
No one at Enterprise DNA has checked this listing against its sources. The description comes from public listings gathered automatically. Any fact below shows where it came from and when it was last checked.
From the listing
About SQL Optimization Patterns
A skill from Seth Hobson's agents collection. It explains how to read query plans in PostgreSQL and other databases, which scan types to look for, indexing strategies, query rewrites, schema design for performance and how to remove N+1 query patterns in application code.
Best for
Developers and DBAs tuning relational databases
Use cases
- Find out why one query is slow from its EXPLAIN output
- Choose the right index for a hot query
- Remove N+1 queries from an ORM-heavy endpoint
Notes
Why it matters
Most slow queries are fixed by reading the plan and adding the right index. This skill makes the agent do that before suggesting anything else.
Source
- Skill file: plugins/developer-essentials/skills/sql-optimization-patterns/SKILL.md in wshobson/agents.
- Repository: 41,631 GitHub stars, MIT licence. Checked 24 Oct 2026 through the GitHub API.
- Last change to the skill: 22 May 2026.
- This page was written from the skill's own SKILL.md. It is not an Enterprise DNA source review and the skill has not been installed or tested by us.
Pros
- Starts from the query plan, which is the right place
- Covers indexes, rewrites and schema
- From a very widely used collection
Cons
- Mostly PostgreSQL examples
- General patterns, not tuned to your workload
Key facts
What we have checked
Not checked yet. Dated facts such as prices, releases and repository activity appear here once we have confirmed them from a source.
Health and security
Is SQL Optimization Patterns looked after, and what do its setup files show
Security check static checks
100 out of 100
- Note No dependency list or install command was found in the skill, so there were no packages to look up on OSV.
Sources
Where this comes from
No sources recorded yet. Each source we check is listed here with the date we checked it.
A source shows what was published when we checked it. It does not certify security, performance or a working installation. Read our method.
Changelog
What changed
No changes recorded yet. Releases, price changes and deprecations appear here, with their dates, once we track them for this record.
Pairs with
Other entries in the index that connect to this one. Click through to see the chain.
csharp-developer
Jeffallan
67 Specialized Skills for Full-Stack Developers. Transform Claude Code into your expert pair programmer.
database-optimizer
Jeffallan
67 Specialized Skills for Full-Stack Developers. Transform Claude Code into your expert pair programmer.
Databricks SQL
Databricks
Use advanced Databricks SQL: scripting, stored procedures, materialized views, pipe syntax, geospatial and AI functions.
data-sql-analysis
BlueSkyXN
Public-safe Codex plugin-first preset system with agents, skills, examples, scripts, and a read-only dashboard.
Get the free Developer’s Field Guide
A 27-page field guide to the AI coding workflow with Claude. Claude Code, MCP servers, the prompt patterns that work, and what to delegate. Free.
Enter your work email. We send it straight over, plus a few short notes worth knowing. Unsubscribe any time.