benchflow-ai / optimizing-queries

Install for your project team

Run this command in your project directory to install the skill for your entire team:

mkdir -p .claude/skills/optimizing-queries && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3997" && unzip -o skill.zip -d .claude/skills/optimizing-queries && rm skill.zip

New-Item -Path ".claude/skills/optimizing-queries" -ItemType Directory -Force; Invoke-WebRequest -Uri "https://fastmcp.me/Skills/Download/3997" -OutFile "skill.zip"; Expand-Archive -Path "skill.zip" -DestinationPath ".claude/skills/optimizing-queries" -Force; Remove-Item "skill.zip"

Project Skills

This skill will be saved in .claude/skills/optimizing-queries/ and checked into git. All team members will have access to it automatically.

Important: Please verify the skill by reviewing its instructions before using it.

Install skill for Codex

Run one of these commands to install the skill depending on your needs:

Project Local ($CWD/.codex/skills)

mkdir -p .codex/skills/optimizing-queries && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3997" && unzip -o skill.zip -d .codex/skills/optimizing-queries && rm skill.zip

New-Item -Path ".codex/skills/optimizing-queries" -ItemType Directory -Force; Invoke-WebRequest -Uri "https://fastmcp.me/Skills/Download/3997" -OutFile "skill.zip"; Expand-Archive -Path "skill.zip" -DestinationPath ".codex/skills/optimizing-queries" -Force; Remove-Item "skill.zip"

User Global (~/.codex/skills)

mkdir -p ~/.codex/skills/optimizing-queries && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3997" && unzip -o skill.zip -d ~/.codex/skills/optimizing-queries && rm skill.zip

New-Item -Path "$HOME/.codex/skills/optimizing-queries" -ItemType Directory -Force; Invoke-WebRequest -Uri "https://fastmcp.me/Skills/Download/3997" -OutFile "skill.zip"; Expand-Archive -Path "skill.zip" -DestinationPath "$HOME/.codex/skills/optimizing-queries" -Force; Remove-Item "skill.zip"

Scope	Location	Suggested Use
REPO	`$CWD/.codex/skills`	Project directory. Teams can check in skills most relevant to a working folder here.
REPO	`$CWD/../.codex/skills`	A folder above CWD. Organizations can check in skills relevant to a shared area.
REPO	`$REPO_ROOT/.codex/skills`	Top-most root folder. Relevant to everyone using the repository.
USER	`$CODEX_HOME/skills`	Personal folder (`~/.codex/skills`). Curate skills that apply to any repository.

Install skill for GitHub Copilot

Run one of these commands to install the skill depending on your needs:

Project (.github/skills)

mkdir -p .github/skills/optimizing-queries && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3997" && unzip -o skill.zip -d .github/skills/optimizing-queries && rm skill.zip

New-Item -Path ".github/skills/optimizing-queries" -ItemType Directory -Force; Invoke-WebRequest -Uri "https://fastmcp.me/Skills/Download/3997" -OutFile "skill.zip"; Expand-Archive -Path "skill.zip" -DestinationPath ".github/skills/optimizing-queries" -Force; Remove-Item "skill.zip"

Personal (~/.copilot/skills)

mkdir -p ~/.copilot/skills/optimizing-queries && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3997" && unzip -o skill.zip -d ~/.copilot/skills/optimizing-queries && rm skill.zip

New-Item -Path "$HOME/.copilot/skills/optimizing-queries" -ItemType Directory -Force; Invoke-WebRequest -Uri "https://fastmcp.me/Skills/Download/3997" -OutFile "skill.zip"; Expand-Archive -Path "skill.zip" -DestinationPath "$HOME/.copilot/skills/optimizing-queries" -Force; Remove-Item "skill.zip"

Scope	Location	Suggested Use
Project	`.github/skills/`	Repository-specific skills. Checked into git for the whole team.
Personal	`~/.copilot/skills/`	Personal skills available across all your projects.

Install skill for Google Antigravity

Run one of these commands to install the skill depending on your needs:

Workspace (.agent/skills)

mkdir -p .agent/skills/optimizing-queries && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3997" && unzip -o skill.zip -d .agent/skills/optimizing-queries && rm skill.zip

New-Item -Path ".agent/skills/optimizing-queries" -ItemType Directory -Force; Invoke-WebRequest -Uri "https://fastmcp.me/Skills/Download/3997" -OutFile "skill.zip"; Expand-Archive -Path "skill.zip" -DestinationPath ".agent/skills/optimizing-queries" -Force; Remove-Item "skill.zip"

Global (~/.gemini/antigravity/skills)

mkdir -p ~/.gemini/antigravity/skills/optimizing-queries && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3997" && unzip -o skill.zip -d ~/.gemini/antigravity/skills/optimizing-queries && rm skill.zip

New-Item -Path "$HOME/.gemini/antigravity/skills/optimizing-queries" -ItemType Directory -Force; Invoke-WebRequest -Uri "https://fastmcp.me/Skills/Download/3997" -OutFile "skill.zip"; Expand-Archive -Path "skill.zip" -DestinationPath "$HOME/.gemini/antigravity/skills/optimizing-queries" -Force; Remove-Item "skill.zip"

Scope	Location	Suggested Use
Workspace	`.agent/skills/`	Workspace-specific skills for project workflows and conventions.
Global	`~/.gemini/antigravity/skills/`	Personal skills available across all workspaces.

Analyzes and optimizes SQL/NoSQL queries for performance. Use when reviewing query performance, optimizing slow queries, analyzing EXPLAIN output, suggesting indexes, identifying N+1 problems, recommending query rewrites, or improving database access patterns. Supports PostgreSQL, MySQL, SQLite, MongoDB, Redis, DynamoDB, and Elasticsearch.

Data & Analytics

0 views

0 installs

Source: https://github.com/benchflow-ai/skillsbench/tree/main/registry/terminal_bench_2.0/full_batch_reviewed/terminal_bench_2_0_query-optimize/environment/skills/optimizing-queries

benchflow-ai / optimizing-queries

Install for your project team

Download skill

Enable skills in Claude

Upload to Claude

Install skill for Codex

Install skill for GitHub Copilot

Install skill for Google Antigravity