القائمة
Analyze database query performance with execution plans and index recommendations
يُحدَّد Prompt الذي يراجع المصدر أولًا بشكل افتراضي. يمكنك التبديل إلى أمر مباشر أو تنزيل نسخة محلية.
اقرأ SKILL.md وأي ملفات مرافقة يعرضها SkillsMP قبل أن تقرر التثبيت.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
يتجاوز الأمر المباشر Prompt المخصّص للمراجعة. افحص المصدر قبل تشغيله.
npx skills add https://github.com/a5c-ai/babysitter --skill db-query-analyzerيبقى الأمر في سطر واحد. مرّر أفقيًا لمراجعته كاملًا قبل النسخ.
تفضّل نسخة محلية؟ نزّل الملفات المتاحة حاليًا لدى SkillsMP.
استنادا إلى تصنيف SOC المهني
Reference for querying the Atlas knowledge graph through its MCP tools — the SECONDARY enrichment/comparison layer that adds best-practice context to systems you have ALREADY scanned from your real sources (`az`, repos, dirs). Use when you need to look up nodes, edges, kinds, clusters, stats, or wiki pages in Atlas to compare against your real inventory. (atlas graph, query atlas, atlas mcp, search the graph, graph neighbors, atlas record, atlas kinds, enrichment layer)
Atlas turns your STATED NEED into a real systems atlas by SCANNING your actual sources (Azure via `az`, git repos, local dirs) and process/data mining them, THEN enriching against the Atlas knowledge graph. Use this skill when asked to inventory/map your real systems, scan your cloud + repos + directories, mine the real processes or data they contain, or collect their real constraints/gotchas. (atlas, scan my systems, inventory our azure account, map my repos, real systems atlas, process mining, data mining, collect nuances, system discovery)
This skill should be used when the user asks to "find skills in the wild", "assimilate popular workflows", "discover SKILL.md files in repos", "research external skills", "find workflow patterns", "survey the skill landscape", "what skills exist out there", or wants to investigate public repositories for extractable processes, babysitter plugins, and reusable procedural insights. Searches GitHub for SKILL.md files, classifies repos by archetype, and maintains structured research under docs/reference-repos/.
عرض SKILL.md
| name | db-query-analyzer |
| description | Analyze database query performance with execution plans and index recommendations |
| allowed-tools | ["Bash","Read","Write","Glob"] |
| graph | {"domains":["domain:software-engineering"],"specializations":["specialization:software-architecture"],"skillAreas":["skill-area:backend-data-persistence","skill-area:postgres-tuning"],"roles":["role:backend-engineer","role:architect"],"workflows":["workflow:technical-debt-reduction"],"topics":["topic:technical-debt"]} |
Analyzes database query performance including execution plan analysis, index recommendations, slow query identification, and optimization suggestions.
{
"type": "object",
"required": ["queries"],
"properties": {
"queries": {
"type": "array",
"items": {
"type": "object",
"properties": {
"sql": { "type": "string" },
"name": { "type": "string" }
}
}
},
"database": {
"type": "string",
"enum": ["postgresql", "mysql", "sqlserver", "oracle"],
"default": "postgresql"
},
"connectionString": {
"type": "string",
"description": "Database connection string (optional, for live analysis)"
},
"options": {
"type": "object",
"properties": {
"analyzeExplain": {
"type": "boolean",
"default": true
},
"suggestIndexes": {
"type": "boolean",
"default": true
},
"slowQueryThreshold": {
"type": "number",
"default": 1000,
"description": "Slow query threshold in milliseconds"
}
}
}
}
}
{
"type": "object",
"properties": {
"analyses": {
"type": "array",
"items": {
"type": "object",
"properties": {
"query": { "type": "string" },
"executionPlan": { "type": "object" },
"estimatedCost": { "type": "number" },
"issues": { "type": "array" },
"suggestions"
{
kind: 'skill',
skill: {
name: 'db-query-analyzer',
context: {
queries: [
{ sql: 'SELECT * FROM users WHERE email = ?', name: 'get-user-by-email' }
],
database: 'postgresql',
options: {
analyzeExplain: true,
suggestIndexes: true
}
}
}
}