Skip to content
Agentmart
Submit a tool

sql-query-optimizer

SQL 性能优化与慢查询诊断。提供索引覆盖（Covering Index）、分页深度优化与 JOIN 性能建议。

Skill by 2428424081cn

IndexedMIT★ 1
Write a review

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/2428424081cn-sql-query-optimizer

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

SQL 性能优化与慢查询诊断。提供索引覆盖（Covering Index）、分页深度优化与 JOIN 性能建议。

Use cases: backend, data

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools
No tools found
Secrets
None asked for
Install scripts
None found
Runs as
Node.js package

Network hosts it talks to 1

  • codeload.github.com · found in install command

Files it touches

  • ~/.claude/skills/sql-query-optimizer

What's inside

Skill name
sql-query-optimizer
Description
SQL 性能优化与慢查询诊断。提供索引覆盖（Covering Index）、分页深度优化与 JOIN 性能建议。
License
MIT
Instructions
8 lines in SKILL.md · view on GitHub

Before installing

  • Ships executable scripts

Files (3)

  • SKILL.md
  • analyze_sql_antipatterns.mjs · scripts/
  • skill.json

SKILL.md (first lines)

# SQL 性能优化与索引调优指南

## 常见慢查询反模式与优化方案
1. **避免 `SELECT *`**：仅投影业务所需列，利于覆盖索引（Covering Index）。
2. **大偏移量深度分页优化**：使用延迟关联或游标式分页代替 `LIMIT 1000000, 20`。
3. **模糊搜索前缀匹配**：`LIKE '%abc'` 无法走索引，建议全文索引或前缀索引。

From 2428424081cn/Skill-mcp, MIT.

More from 2428424081cn/Skill-mcp

Signals

Stars
1
Forks
0
Open issues
0
Last commit (this folder)
Aug 24, 2026 (2 months ago)

From GitHub (fetched Oct 24, 2026).

Details

License
MIT
Repository
github.com/2428424081cn/Skill-mcp
First seen
Oct 24, 2026
Last checked
Oct 24, 2026
Source
GitHubgithub-graphql

More from 2428424081cn

Cite this page

sql-query-optimizer skill. Agent Mart. https://agentmart.dev/skills/2428424081cn-sql-query-optimizer (last updated 2026-10-24)