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
- Days since the last commit
- 5
- GitHub forks
- 4,490
- GitHub stars
- 42,501
- Days to a first reply on issues
- 5.6
- Open issues
- 4
- Releases in the last 90 days
- 0
Each value shows when we last confirmed it and where it came from. Values we have not confirmed are left out, never guessed.
Stars and usage
How SQL Optimization Patterns is growing
42,071 to 42,501
Health and security
Is SQL Optimization Patterns looked after, and what do its setup files show
Health score
60 out of 100
| Part | Points | What we saw |
|---|---|---|
| Recent activity | 30 of 30 | Last push 5 days ago |
| Releases | 0 of 15 | 0 releases in 90 days |
| Issue replies | 18 of 20 | First reply in 5.6 days (median) |
| Maintainer | 0 of 15 | Owned by a single user |
| Official source | Not counted | MCP servers only |
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.
Alternatives
Alternatives to SQL Optimization Patterns
| Record | Type | How we know | Checked |
|---|---|---|---|
| tencent-pg-slowquery-diagnosisAlternative to this | Skill | Matched from the listing text |
Compare
Compare SQL Optimization Patterns side by side
Sources
Where this comes from
- GitHubRegistry
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.
Open-source & AI alternatives
Swap-in tools that solve the same job. Weigh the trade-offs before you commit.
Pairs with
Other entries in the index that connect to this one. Click through to see the chain.
database-optimizer
Jeffallan
67 Specialized Skills for Full-Stack Developers. Transform Claude Code into your expert pair programmer.
performance-optimization
addyosmani
Production-grade engineering skills for AI coding agents.
Postgresql
PatrickJS
📄 Configuration files that enhance Cursor AI editor experience with custom rules and behaviors
sql-pro
Jeffallan
67 Specialized Skills for Full-Stack Developers. Transform Claude Code into your expert pair programmer.
supabase-postgres-best-practices
supabase
Agent Skills to help developers using AI agents with Supabase
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.
design-postgis-tables
timescale
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
design-postgres-tables
timescale
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Duckdb
sanjeed5
Curated list of awesome Cursor Rules .mdc files
find-hypertable-candidates
timescale
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
migrate-postgres-tables-to-hypertables
timescale
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
neon
neondatabase
Agent Skills for Neon Severless Postgres
neon-functions
neondatabase
Agent Skills for Neon Severless Postgres
neon-postgres
neondatabase
Agent Skills for Neon Severless Postgres
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.