Enterprise DNAEnterprise DNA

Skills

SQL Optimization Patterns

by wshobson

Speed up slow SQL: read EXPLAIN plans, choose indexes, rewrite queries and fix N+1 problems.

Our verdict

Not reviewed yet

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.

How we review records

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

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
Checked GitHub
GitHub forks
4,490
Checked GitHub
GitHub stars
42,501
Checked GitHub
Days to a first reply on issues
5.6
Checked GitHub
Open issues
4
Checked GitHub
Releases in the last 90 days
0
Checked GitHub

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

GitHub stars

42,071 to 42,501

stars. 1 Nov 2026 to 14 Nov 2026, 3 readings.

Source: GitHub. Checked .

Health and security

Is SQL Optimization Patterns looked after, and what do its setup files show

Health score

60 out of 100

Does someone look after this repository? It does not say the code is good or safe. Worked out from GitHub signals checked . How it is worked out

PartPointsWhat we saw
Recent activity30 of 30Last push 5 days ago
Releases0 of 150 releases in 90 days
Issue replies18 of 20First reply in 5.6 days (median)
Maintainer0 of 15Owned by a single user
Official sourceNot countedMCP servers only

Security check static checks

100 out of 100

Reads what is published about the server: package advisories, licence, secrets in the documented setup and tool permissions. Nothing is installed or run, so this is not a security assessment. Checked by edna-skill-static-v1 main@0874a27b17a2. What it checks

  • 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

RecordTypeHow we knowChecked
tencent-pg-slowquery-diagnosisAlternative to thisSkillMatched from the listing text

Compare

Compare SQL Optimization Patterns side by side

Sources

Where this comes from

  • GitHubRegistry

    Checked · Days since the last commit, GitHub forks, GitHub stars, Days to a first reply on issues, Open issues, Releases in the last 90 days

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.

Pairs with12 entries
SSkillslowCatalogue

csharp-developer

Jeffallan

67 Specialized Skills for Full-Stack Developers. Transform Claude Code into your expert pair programmer.

★ 12,283
SSkillslowCatalogue

database-optimizer

Jeffallan

67 Specialized Skills for Full-Stack Developers. Transform Claude Code into your expert pair programmer.

★ 12,283
SSkillsmediumCatalogue

Databricks SQL

Databricks

Use advanced Databricks SQL: scripting, stored procedures, materialized views, pipe syntax, geospatial and AI functions.

★ 369
SSkillslowCatalogue

data-sql-analysis

BlueSkyXN

Public-safe Codex plugin-first preset system with agents, skills, examples, scripts, and a read-only dashboard.

★ 22
SSkillslowCatalogue

design-postgis-tables

timescale

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

★ 1,885
SSkillslowCatalogue

design-postgres-tables

timescale

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

★ 1,885
SSkillslowCatalogue

Duckdb

sanjeed5

Curated list of awesome Cursor Rules .mdc files

★ 3,584
SSkillslowCatalogue

find-hypertable-candidates

timescale

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

★ 1,885
SSkillslowCatalogue

migrate-postgres-tables-to-hypertables

timescale

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

★ 1,885
SSkillslowCatalogue

neon

neondatabase

Agent Skills for Neon Severless Postgres

★ 113
SSkillslowCatalogue

neon-functions

neondatabase

Agent Skills for Neon Severless Postgres

★ 113
SSkillslowCatalogue

neon-postgres

neondatabase

Agent Skills for Neon Severless Postgres

★ 113
Free 27-page guide

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.

No spam. Unsubscribe any time.