New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

SQL Optimization Patterns

by ynulihao in ynulihao/AgentSkillOS

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

No licenceAuto-check passedDatabases

Install SQL Optimization Patterns

skills CLI
$ npx skills add ynulihao/AgentSkillOS --skill sql-optimization-patterns -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install ynulihao/AgentSkillOS sql-optimization-patterns --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/ynulihao/AgentSkillOS.git skills-src && mkdir -p .claude/skills && cp -r skills-src/data/skill_seeds/sql-optimization-patterns .claude/skills/sql-optimization-patterns && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
sql-optimization-patterns
GitHub stars
617
Used in
10 other repos
Token cost
~3.3k tokens
SKILL.md length
427 words
Files
1
Skills in repo
26
Repo updated
First seen
Licence
None found

At a glance

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

  • Works in 3 steps: Query Execution Plans (EXPLAIN) → Index Strategies → Query Optimization Patterns
  • Debugging slow queries
  • SKILL.md covers When to Use This Skill, Core Concepts, Optimization Patterns and Advanced Techniques, plus 4 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

SQL Optimization Patterns is an agent skill from ynulihao/AgentSkillOS. Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

Its SKILL.md is about 3.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering SQL, Query optimization and Database schema design. It works with SQL. The repository describes itself as: Build your agent from 200,000+ skills via skill RETRIEVAL & ORCHESTRATION.

When your agent uses it

  • Debugging slow queries
  • Designing database schemas
  • Optimizing application performance

Example prompts

  • “/sql-optimization-patterns”

Requirements

  • Python 3

Workflow steps

3 steps, taken from the step headings in SKILL.md.

  1. Query Execution Plans (EXPLAIN)
  2. Index Strategies
  3. Query Optimization Patterns

What it can do on your machine

Read from SKILL.md and the folder at commit c3cfae1. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are sql and python).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

SQL Optimization Patterns loads about 3.3k tokens when it runs. Until then it costs about 68 tokens; SKILL.md has 427 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~68
When it runs · the whole SKILL.md, loaded when a task matches
~3.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 427 words (~3,274 tokens).

“Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.”

— opening of SKILL.md by ynulihao
name
sql-optimization-patterns

Read the full SKILL.md on GitHub

Files

Just SKILL.md in data/skill_seeds/sql-optimization-patterns of ynulihao/AgentSkillOS.

Open the folder on GitHubat commit c3cfae1

Used in 10 other repositories

We found 25 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 10 other GitHub owners. This page covers the copy in ynulihao/AgentSkillOS, which our catalogue first saw on October 7, 2026.

Compare with similar skills

SQL Optimization Patterns next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

SQL Optimization Patterns compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
SQL Optimization Patterns this skillynulihao/AgentSkillOS61710 repos~3.3kAutomated safety check: PassNone
SQL Database Assistantborghei/Claude-Skills874—~1.5kAutomated safety check: PassMIT
SQL Optimization InterviewerPrepLabsAI/InterviewMentor112—~2.1kAutomated safety check: PassMIT
SQL ProJeffallan/claude-skills12k—~1.3kAutomated safety check: PassMIT
Discover Databaserand/cc-polymath181—~2kAutomated safety check: PassMIT
Agent SQL Proxiaoyuge886/aigc198—~315Automated safety check: PassMIT

Similar skills

  • SQL Database Assistant

    borghei/Claude-Skills

    This skill should be used when the user asks to "optimize SQL queries", "explore database schemas", "generate migration SQL", "analyze query performance", or "document database structure".

    874 GitHub stars~1.5k tokensUpdated today
    DatabasesAuto-check passed

  • SQL Optimization Interviewer

    PrepLabsAI/InterviewMentor

    A Data Engineering interviewer focused on database performance.

    112 GitHub stars~2.1k tokensUpdated today
    DatabasesAuto-check passed

  • SQL Pro

    Jeffallan/claude-skills

    Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.

    12k GitHub stars~1.3k tokensUpdated 3 days ago
    DatabasesAuto-check passed

  • Discover Database

    rand/cc-polymath

    Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection.

    181 GitHub stars~2k tokensUpdated 7 mo ago
    DatabasesAuto-check passed

  • Agent SQL Pro

    xiaoyuge886/aigc

    Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.

    198 GitHub stars~315 tokensUpdated 2 mo ago
    DatabasesAuto-check passed

  • SQL Expert

    aiskillstore/marketplace

    Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server.

    430 GitHub stars~3.4k tokensUpdated today
    DatabasesAuto-check passed

More from ynulihao/AgentSkillOS

All 26 skills in this repo

  • Generate Image

    ynulihao/AgentSkillOS

    Generate or edit images using AI models (FLUX, Gemini). An agent skill from ynulihao/AgentSkillOS.

    617 GitHub starsUsed in 10 repos~1.7k tokens
    Auto-check: notes

  • Data Storytelling

    ynulihao/AgentSkillOS

    Transform data into compelling narratives using visualization, context, and persuasive structure.

    617 GitHub starsUsed in 15 repos~2.8k tokens
    Auto-check passed

  • Prompt Engineering Patterns

    ynulihao/AgentSkillOS

    Master advanced prompt engineering techniques to maximize LLM performance, reliability, and controllability in production.

    617 GitHub starsUsed in 14 repos~1.7k tokens
    Auto-check passed

  • Employment Contract Templates

    ynulihao/AgentSkillOS

    Create employment contracts, offer letters, and HR policy documents following legal best practices.

    617 GitHub starsUsed in 11 repos~4.1k tokens
    Auto-check passed

  • Media Processing

    ynulihao/AgentSkillOS

    Process multimedia files with FFmpeg (video/audio encoding, conversion, streaming, filtering, hardware acceleration), ImageMagick (image manipulation, format conversion, batch processing, effects…

    617 GitHub stars~817 tokensUpdated 7 mo ago
    Auto-check: notes

  • Baoyu Xhs Images

    ynulihao/AgentSkillOS

    Xiaohongshu (Little Red Book) infographic series generator with multiple style options.

    617 GitHub starsUsed in 1 repo~2.7k tokens
    Auto-check passed

Works with

Categories

Questions about SQL Optimization Patterns

What does SQL Optimization Patterns do?

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. SQL Optimization Patterns is an agent skill from ynulihao/AgentSkillOS. Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

When should I use SQL Optimization Patterns?

SQL Optimization Patterns fits situations like: debugging slow queries; designing database schemas; optimizing application performance.

How do I install SQL Optimization Patterns in Claude Code?

Run `npx skills add ynulihao/AgentSkillOS --skill sql-optimization-patterns -a claude-code`. Or copy the skill folder (data/skill_seeds/sql-optimization-patterns in ynulihao/AgentSkillOS) into .claude/skills/sql-optimization-patterns in your project. Claude Code loads it when a task matches its description.

How do I install SQL Optimization Patterns in Codex?

Run `npx skills add ynulihao/AgentSkillOS --skill sql-optimization-patterns -a codex`. Or copy the skill folder (data/skill_seeds/sql-optimization-patterns in ynulihao/AgentSkillOS) into .agents/skills/sql-optimization-patterns in your project. Codex loads it when a task matches its description.

Can I use SQL Optimization Patterns in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add ynulihao/AgentSkillOS --skill sql-optimization-patterns -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sql-optimization-patterns, .gemini/skills/sql-optimization-patterns, .github/skills/sql-optimization-patterns and .opencode/skills/sql-optimization-patterns in your project.

What does SQL Optimization Patterns need to run?

SKILL.md names no scripts, command-line tools or credentials: SQL Optimization Patterns is instructions for the agent only. Our summary lists: Python 3.

Does SQL Optimization Patterns access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is SQL Optimization Patterns safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does SQL Optimization Patterns use?

No licence was found for SQL Optimization Patterns or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does SQL Optimization Patterns use?

About 3.3k tokens (SKILL.md is roughly 13k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to SQL Optimization Patterns?

Skills that share tags, products or a category with SQL Optimization Patterns: SQL Database Assistant (borghei/Claude-Skills, 874 stars), SQL Optimization Interviewer (PrepLabsAI/InterviewMentor, 112 stars), SQL Pro (Jeffallan/claude-skills, 12k stars) and Discover Database (rand/cc-polymath, 181 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains SQL Optimization Patterns?

ynulihao (a GitHub user) maintains it in ynulihao/AgentSkillOS, which has 617 GitHub stars. The repository holds 26 skills in this directory. The repository was last updated on March 7, 2026.

Source: ynulihao/AgentSkillOS on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.