📦
content-creator
88Create Brand-Consistent Marketing Content
Marketing teams need content that stays consistent across channels. This skill helps plan, write, analyze, and optimize content for brand voice and SEO.
Writing & Content View
Skills sql-optimization-patterns
📦
sql-optimization-patterns
Content revision r1 Safe 📁 Filesystem access⚙️ External commands
Optimize SQL Queries Faster
Slow queries increase application latency and database costs. This skill guides indexing, EXPLAIN review, and query rewrites for faster SQL performance.
Supports: Claude Codex Code(CC)
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Agent request
Review the Skillstore skill "sql-optimization-patterns" from https://skillstore.io/skills/sickn33-sql-optimization-patterns.md and its manifest at https://skillstore.io/api/skills/sickn33-sql-optimization-patterns/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Agent-readable resources
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Test it
Using "sql-optimization-patterns". A slow user lookup query with a filter on email and no useful index.
Expected outcome:
The skill would explain why a full table scan is likely, recommend an email index, and ask for an EXPLAIN plan to confirm.
Using "sql-optimization-patterns". An API endpoint loads users, then loads orders once for each user.
Expected outcome:
The skill would identify the N+1 pattern and suggest a join or batch query with grouped results.
Using "sql-optimization-patterns". A reporting query uses a large offset for pagination on a growing table.
Expected outcome:
The skill would recommend cursor-based pagination and an index that matches the sort order.
Security Audit
Safev4 • 7/7/2026 Open versioned report
The static findings are false positives caused by Markdown inline code and SQL documentation examples. No executable shell commands, prompt injection, data exfiltration, or malicious intent were found in the reviewed files.
2
Files scanned
541
Lines analyzed
0
Review items
0
False positives ignored
Risk Factors
📁 Filesystem access (1)
⚙️ External commands (2)
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
Copy report link
https://skillstore.io/skills/sickn33-sql-optimization-patterns/audits/4?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/sickn33-sql-optimization-patterns?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/sickn33-sql-optimization-patterns?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-sql-optimization-patterns/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/sickn33-sql-optimization-patterns.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Academic citations (APA · BibTeX · CFF)
APA citation
sickn33. (2026). sql-optimization-patterns security audit report (audit version 4) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-sql-optimization-patterns/audits/4BibTeX citation
@techreport{sickn33-sickn33-sql-optimization-patterns-2026,
author = {sickn33},
title = {sql-optimization-patterns security audit report (audit version 4)},
institution = {Skillstore},
year = {2026},
number = {4},
url = {https://skillstore.io/skills/sickn33-sql-optimization-patterns/audits/4},
note = {Author version unspecified}
}CITATION.cff
cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "sql-optimization-patterns security audit report (audit version 4)"
version: "unspecified"
type: report
authors:
- name: "sickn33"
date-released: "2026-07-07"
url: "https://skillstore.io/skills/sickn33-sql-optimization-patterns/audits/4"
identifiers:
- type: other
value: "skillstore:sickn33-sql-optimization-patterns:audit:4"
description: "Skillstore immutable audit report identifier"
Compare variants
2 installable variantsEach author remains a separate installable skill. The recommended variant is ranked by Skillstore evidence.
Why this variant is first
Higher Skillstore usage
Author / source Skillstore Score Evidence Confidence Skillstore usage Updated
wshobson Recommended
wshobson-sql-optimization-patterns
Skillstore Score 78
Evidence Confidence High
Skillstore usage 27
Updated
2026-08-21
sickn33 Current
sickn33-sql-optimization-patterns
Skillstore Score 78
Evidence Confidence High
Skillstore usage 16
Updated
2026-08-21
Skillstore Score
Why this score Evidence Confidence: High 55
Architecture
85
Maintainability
87
Content
69
Community
83
Spec Compliance
What You Can Build
Tune a Slow Endpoint
Review a slow query, interpret its plan, and choose indexes or rewrites that reduce response time.
Review Database Indexes
Compare query patterns with existing indexes and identify missing, redundant, or poorly ordered indexes.
Plan Scaling Work
Prioritize high-impact SQL changes before traffic growth or a major product launch.
Try These Prompts
Review One Query
Use the SQL optimization patterns skill. Review this slow query and explain the most likely bottlenecks in plain language: [paste query].
Interpret an EXPLAIN Plan
Use the SQL optimization patterns skill. Analyze this EXPLAIN output and suggest indexes or query rewrites: [paste query and plan].
Fix N Plus One Access
Use the SQL optimization patterns skill. Identify N+1 query risks in this data access flow and propose batch loading or joins: [paste flow].
Design a Tuning Plan
Use the SQL optimization patterns skill. Build a prioritized tuning plan for these queries, schema notes, data volumes, and latency goals: [paste details].
Best Practices
- Share the query, relevant schema, current indexes, row counts, and EXPLAIN output when asking for help.
- Validate every recommended change with before-and-after query plans and realistic data volume.
- Consider write overhead, storage cost, and maintenance impact before adding indexes.
Avoid
- Do not add indexes without matching them to real query predicates and sort orders.
- Do not optimize only from syntax when execution plans and production metrics are available.
- Do not run destructive or locking maintenance commands in production without a reviewed rollout plan.
Frequently Asked Questions
Does this skill connect to my database?
No. It provides analysis and recommendations from information you provide.
Which databases does it support?
It is strongest for PostgreSQL and general SQL patterns. Some examples mention MySQL behavior.
Can it read EXPLAIN plans?
Yes. It can help interpret plan operators, row estimates, costs, timing, and index usage.
Will every suggested index improve performance?
No. Index value depends on data distribution, workload, write volume, and query frequency.
Can it fix ORM performance issues?
It can identify common ORM issues such as N+1 queries and suggest joins, preloading, or batch loading.
Should I run examples directly in production?
No. Test changes in a safe environment and follow normal database change controls.
Developer Details
Author
sickn33License
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Repository
https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/sql-optimization-patternsRef
9f814fc6a43fd99946f2da5e0df231c65a38bc76
Maintenance freshness
7/18/2026
Usage
12 downloads · 113 views
File structure
More from sickn33
View all📦
prompt-engineering-patterns
85Improve LLM Prompts With Proven Patterns
Inconsistent prompts waste time and make AI outputs hard to trust. This skill guides prompt design with reusable patterns, examples, evaluation steps, and optimization workflows.
Productivity View
📦
senior-fullstack
82Build Fullstack Apps with Senior Patterns
Teams need consistent setup, architecture, and review guidance for modern web applications. This skill provides scaffolders, workflow references, and quality prompts for React, Next.js, Node.js, GraphQL, and PostgreSQL projects.
Coding & Development View
📦
senior-architect
81Design Scalable Software Architectures
Architecture decisions are hard to compare across web, mobile, backend, and cloud systems. This skill provides structured guides and local scaffold scripts for reports, dependency review, and trade-off documentation.
Coding & Development View
📦
prompt-engineer
81Optimize AI Prompts With Prompt Engineer
Writing clear prompts is hard when goals are vague or complex. This skill turns rough requests into structured prompts using proven prompt frameworks.
Productivity View
📦
product-manager-toolkit
80Prioritize Product Work With Research Insights
Product teams need faster ways to rank features, synthesize interviews, and document decisions. This skill provides RICE scoring, interview analysis, and PRD templates for structured planning.
Productivity View
Related Skills
View all📦
postgres-patterns
78Review PostgreSQL Migrations and Queries
by CJHarmath
PostgreSQL migrations can pass tests while causing locks, slow scans, or index bloat. This skill gives Claude, Codex, and Claude Code practical patterns for safer schema and query review.
Data & Analytics View
📦
sql-queries-tool
79Generate SQL Queries for DBX Studio
by Dbxstudio
Database users need reliable SQL that matches their connection type and schema. This skill guides Claude, Codex, and Claude Code to inspect schemas, write read-only queries, and explain results clearly.
Data & Analytics View
📦
postgresql-table-design
78Design PostgreSQL Tables
by wshobson
PostgreSQL schemas can fail when data types, constraints, and indexes are chosen without workload context. This skill guides table design with PostgreSQL-specific rules for durable, performant, and maintainable schemas.
Data & Analytics View
📦
postgres-performance
78Optimize PostgreSQL Performance
by CJHarmath
Slow database queries harm application reliability and scale. This skill gives practical PostgreSQL patterns for faster queries, safer migrations, and clearer monitoring.
Data & Analytics View
📦
database-fundamentals
78Review Database Design Safely
by DanielPodolsky
Database changes can create slow queries, data loss, and unsafe migrations. This skill guides Claude, Codex, and Claude Code through schema, query, index, ORM, and migration reviews.
Data & Analytics View
📦
supabase-postgres-best-practices
80Optimize Supabase Postgres Performance
by supabase
Slow queries and schema drift can make Postgres apps hard to scale. This skill gives AI agents Supabase-backed rules for indexes, RLS, pooling, and diagnostics.
Data & Analytics View