用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/microwind/ai-skills --skill analyzer命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
基于 SOC 职业分类
正在显示 SKILL.md
| name | 数据库-查询-analyzer |
| description | Enhanced skill for 数据库-查询-analyzer |
| license | MIT |
详细的分析和验证 数据库-查询-analyzer.
核心原则: 优化 查询 before they 缓慢 down your 系统. Bad 查询 compound as data grows.
始终:
触发短语:
Problem:
for item in items:\n item.user = User.find(item.user_id)
Consequence:
- 1 query gets items
- N queries for each user (slow!)
- Performance degrades with data
Solution:
Use JOIN: SELECT items.*, users.* FROM items JOIN users...
Problem:
WHERE email = 'user@example.com' with no index on email column
Consequence:
- Full table scan (slow)
- Disk I/O increases
- CPU usage high
Solution:
CREATE INDEX idx_email ON users(email)
Problem:
SELECT * WHERE deleted_at IS NULL (no index on deleted_at)
Consequence:
- Scans entire table
- Slow for millions of rows
- Blocks other queries
Solution:
Add index: CREATE INDEX idx_deleted_at ON table(deleted_at)
Problem:
SELECT * FROM orders o, items i, users u WHERE...
Consequence:
- Cartesian product possible
- Temporary tables created
- High memory usage
Solution:
Use proper JOIN syntax with ON clauses
| 问题 | 解决方案 |
|---|---|
| "Not sure where to start" | 识别 the specific issue using the 常见问题 section above. |
| "性能 is poor" | Profile first to 识别 bottleneck before optimizing. |
| "Not sure about 最佳实践" | 检查 the 验证检查清单 to understand quality standards. |
❌ Running 查询 in loop (N+1) ❌ SELECT * 没有WHERE clause ❌ No 索引 on WHERE 列s ❌ Implicit type conversion in WHERE ❌ 函数 on 索引ed 列s ❌ Not using LIMIT on large 表s