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.
SQL query optimization and database performance specialist. An agent skill from aiskillstore/marketplace.
Install Database Optimization
$ npx skills add aiskillstore/marketplace --skill database-optimization -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install aiskillstore/marketplace database-optimization --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/89jobrien/database-optimization .claude/skills/database-optimization && rm -rf skills-srcUse ~/.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/
Install the "database-optimization" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/89jobrien/database-optimization into .claude/skills/database-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimization", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/aiskillstore/marketplace/tree/main/skills/89jobrien/database-optimizationType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add aiskillstore/marketplace --skill database-optimization -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install aiskillstore/marketplace database-optimization --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/89jobrien/database-optimization .agents/skills/database-optimization && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "database-optimization" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/89jobrien/database-optimization into .agents/skills/database-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimization", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add aiskillstore/marketplace --skill database-optimization -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install aiskillstore/marketplace database-optimization --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/89jobrien/database-optimization .cursor/skills/database-optimization && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "database-optimization" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/89jobrien/database-optimization into .cursor/skills/database-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimization", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/aiskillstore/marketplace.git --path skills/89jobrien/database-optimization--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add aiskillstore/marketplace --skill database-optimization -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install aiskillstore/marketplace database-optimization --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/89jobrien/database-optimization .gemini/skills/database-optimization && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "database-optimization" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/89jobrien/database-optimization into .gemini/skills/database-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimization", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install aiskillstore/marketplace database-optimizationInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add aiskillstore/marketplace --skill database-optimization -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/89jobrien/database-optimization .github/skills/database-optimization && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "database-optimization" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/89jobrien/database-optimization into .github/skills/database-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimization", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add aiskillstore/marketplace --skill database-optimization -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install aiskillstore/marketplace database-optimization --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/89jobrien/database-optimization .opencode/skills/database-optimization && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "database-optimization" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/89jobrien/database-optimization into .opencode/skills/database-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimization", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
database-optimization- GitHub stars
- 430
- Used in
- 1 other repo
- Token cost
- ~787 tokens
- SKILL.md length
- 175 words
- Files
- 3 (incl. references)
- Skills in repo
- 1,085
- Repo updated
- First seen
- Licence
- None found
At a glance
SQL query optimization and database performance specialist. An agent skill from aiskillstore/marketplace.
- Works in 6 steps: Query Optimization: Analyzes and… → Index Design: Creates appropriate indexes → N+1 Resolution: Fixes N+1 query problems → …
- Optimizing slow queries
- SKILL.md covers When to Use This Skill, What This Skill Does, How to Use and Optimization Areas, plus 1 more section
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Database Optimization is an agent skill from aiskillstore/marketplace. SQL query optimization and database performance specialist. Use when optimizing slow queries, fixing N+1 problems, designing indexes, implementing caching, or improving database performance. Works with PostgreSQL, MySQL, and other databases.
Its SKILL.md is about 790 tokens, which your agent loads only when the skill is triggered. The skill folder holds 3 other files, including reference files (for example `references/query-patterns.md` and `skill-report.json`).
It sits in Databases, covering Query optimization, Caching and SQL. It works with SQL, MySQL and PostgreSQL. The repository describes itself as: Security-audited skills for Claude, Codex & Claude Code. One-click install, quality verified.
When your agent uses it
- Optimizing slow queries
- Fixing N+1 problems
- Designing indexes
- Implementing caching
Example prompts
- “/database-optimization”
Requirements
- Python 3
Workflow steps
6 steps, taken from the first numbered list in SKILL.md.
- Query Optimization: Analyzes and optimizes SQL queries
- Index Design: Creates appropriate indexes
- N+1 Resolution: Fixes N+1 query problems
- Caching: Implements caching layers (Redis, Memcached)
- Migration Optimization: Optimizes database migrations
- Performance Monitoring: Sets up query performance monitoring
What it can do on your machine
Read from SKILL.md and the folder at commit 4ac52da. 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 python, markdown and sql).
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
Database Optimization loads about 787 tokens when it runs, and up to ~1.6k if it reads all its reference files. Until then it costs about 66 tokens; SKILL.md has 175 words of instructions outside code blocks.
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 175 words (~787 tokens).
“This skill optimizes database performance including query optimization, indexing strategies, N+1 problem resolution, and caching implementation.”
- name
- database-optimization
- author
- Joseph OBrien
- status
- unpublished
- updated
- 2025-12-23
- version
- 1.0.1
- tag
- skill
- type
- skill
Files
SKILL.md and 2 other files (references) in skills/89jobrien/database-optimization of aiskillstore/marketplace.
- SKILL.md
- references/query-patterns.md
- skill-report.json
Open the folder on GitHubat commit 4ac52da
Used in 1 other repository
We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in aiskillstore/marketplace, which our catalogue first saw on October 7, 2026.
Compare with similar skills
Database Optimization 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Database Optimization this skillaiskillstore/marketplace | 430 | 1 repos | ~787 | Automated safety check: Pass | None | |
| SQL ProJeffallan/claude-skills | 12k | — | ~1.3k | Automated safety check: Pass | MIT | |
| SQL Optimizationgithub/awesome-copilot | 40k | 2 repos | ~2.3k | Automated safety check: Pass | MIT | |
| Query Expertjamesrochabrun/skills | 215 | — | ~4.3k | Automated safety check: Pass | MIT | |
| Optimizing SQLancoleman/ai-design-components | 526 | — | ~3k | Automated safety check: Pass | MIT | |
| Dsqlawslabs/agent-plugins | 912 | — | ~6.9k | Automated safety check: Pass | Apache-2.0 |
Similar skills
- Official
SQL Optimization
github/awesome-copilot
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…
Query Expert
jamesrochabrun/skills
Master SQL and database queries across multiple systems. An agent skill from jamesrochabrun/skills.
Optimizing SQL
ancoleman/ai-design-components
Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.
- Official
Dsql
awslabs/agent-plugins
Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed…
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.
More from aiskillstore/marketplace
All 1,085 skills in this repoCode Stats
aiskillstore/marketplace
Analyze codebase with tokei (fast line counts by language) and difft (semantic AST-aware diffs).
Data Processing
aiskillstore/marketplace
Process JSON with jq and YAML/TOML with yq. An agent skill from aiskillstore/marketplace.
Doc Scanner
aiskillstore/marketplace
Scans for project documentation files (AGENTS.md, CLAUDE.md, GEMINI.md, COPILOT.md, CURSOR.md, WARP.md, and 15+ other formats) and synthesizes guidance.
File Search
aiskillstore/marketplace
Modern file and content search using fd, ripgrep (rg), and fzf.
Find Replace
aiskillstore/marketplace
Modern find-and-replace using sd (simpler than sed) and batch replacement patterns.
Investigating Codebases
aiskillstore/marketplace
Automatically activated when user asks how something works, wants to understand unfamiliar code, needs to explore a new codebase, or asks questions like "where is X implemented?", "how does Y…
Related
Works with
Categories
Questions about Database Optimization
What does Database Optimization do?
SQL query optimization and database performance specialist. An agent skill from aiskillstore/marketplace. Database Optimization is an agent skill from aiskillstore/marketplace. SQL query optimization and database performance specialist.
When should I use Database Optimization?
Database Optimization fits situations like: optimizing slow queries; fixing N+1 problems; designing indexes; implementing caching.
How do I install Database Optimization in Claude Code?
Run `npx skills add aiskillstore/marketplace --skill database-optimization -a claude-code`. Or copy the skill folder (skills/89jobrien/database-optimization in aiskillstore/marketplace) into .claude/skills/database-optimization in your project. Claude Code loads it when a task matches its description.
How do I install Database Optimization in Codex?
Run `npx skills add aiskillstore/marketplace --skill database-optimization -a codex`. Or copy the skill folder (skills/89jobrien/database-optimization in aiskillstore/marketplace) into .agents/skills/database-optimization in your project. Codex loads it when a task matches its description.
Can I use Database Optimization 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 aiskillstore/marketplace --skill database-optimization -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-optimization, .gemini/skills/database-optimization, .github/skills/database-optimization and .opencode/skills/database-optimization in your project.
What does Database Optimization need to run?
SKILL.md names no scripts, command-line tools or credentials: Database Optimization is instructions for the agent only. Our summary lists: Python 3.
Does Database Optimization 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 Database Optimization 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 Database Optimization use?
No licence was found for Database Optimization or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.
How many tokens does Database Optimization use?
About 787 tokens (SKILL.md is roughly 3.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 840 tokens, read only when the agent opens those files.
What are the alternatives to Database Optimization?
Skills that share tags, products or a category with Database Optimization: SQL Pro (Jeffallan/claude-skills, 12k stars), SQL Optimization (github/awesome-copilot, 40k stars), Query Expert (jamesrochabrun/skills, 215 stars) and Optimizing SQL (ancoleman/ai-design-components, 526 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Database Optimization?
aiskillstore (a GitHub organization) maintains it in aiskillstore/marketplace, which has 430 GitHub stars. The repository holds 1,085 skills in this directory. The repository was last updated on October 7, 2026.
Source: aiskillstore/marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.