{
  "ok": true,
  "resource": {
    "id": "RES_75C2CD458761",
    "resource_type": "skill",
    "canonical_url": "https://github.com/wshobson/agents/tree/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/developer-essentials/skills/sql-optimization-patterns",
    "name": "sql-optimization-patterns",
    "summary_en": "Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.",
    "summary_zh": "掌握SQL查询优化、索引策略和EXPLAIN分析，显著提升数据库性能并消除慢查询。在调试慢查询、设计数据库模式或优化应用程序性能时使用。",
    "description_en": "This Agent Skill provides systematic guidance for SQL query optimization, indexing strategies, and EXPLAIN analysis. It includes patterns for avoiding common pitfalls, monitoring query performance, and maintaining database health. The skill is designed for developers debugging slow queries, designing schemas, or optimizing application performance. Evidence is based on the source SKILL.md file, which contains detailed instructions and SQL examples.",
    "description_zh": "该Agent技能提供SQL查询优化、索引策略和EXPLAIN分析的系统性指导。包含避免常见陷阱、监控查询性能和维护数据库健康的模式。该技能面向调试慢查询、设计模式或优化应用程序性能的开发人员。证据基于源SKILL.md文件，其中包含详细说明和SQL示例。",
    "provider_name": "wshobson",
    "homepage_url": "https://github.com/wshobson/agents/tree/main/plugins/developer-essentials/skills/sql-optimization-patterns",
    "endpoint_url": null,
    "source_url": "https://raw.githubusercontent.com/wshobson/agents/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/developer-essentials/skills/sql-optimization-patterns/SKILL.md",
    "icon_url": null,
    "cover_image_url": null,
    "capabilities": [
      "data.analyze",
      "data.optimize",
      "data.design",
      "code.generate"
    ],
    "categories": [
      "developer-tools",
      "data"
    ],
    "industries": [
      "software"
    ],
    "protocols": [
      "agent-skills"
    ],
    "auth": {
      "type": "none",
      "required": false
    },
    "pricing": {
      "model": "free"
    },
    "input_schema": {},
    "output_schema": {},
    "metadata": {
      "content_language": "en",
      "translation_status": "original-only",
      "license": {
        "spdx_id": "MIT",
        "source": "https://github.com/wshobson/agents/blob/a30778f8c4e6b0a87567941b7cca4f534bf642b6/LICENSE"
      },
      "github": {
        "repository": "wshobson/agents",
        "owner": "wshobson",
        "path": "plugins/developer-essentials/skills/sql-optimization-patterns/SKILL.md",
        "commit": "a30778f8c4e6b0a87567941b7cca4f534bf642b6",
        "stars": 39366,
        "forks": 4194,
        "updated_at": "2026-09-03T02:19:37Z"
      },
      "skill": {
        "compatibility": null,
        "allowed_tools": null,
        "content_hash": "cfe8234323daaeb47577261c96933f519004fad2f45f1460f340b883af5d7354",
        "line_count": 215
      },
      "review_gate": {
        "passed": true,
        "reasons": [],
        "policy_version": "review-gate-v1",
        "evaluated_at": "2026-09-03T06:08:34.628Z"
      }
    },
    "latest_version": "a30778f8c4e6",
    "status": "listed",
    "health_status": "unknown",
    "source_kind": "imported",
    "source_agent": "aiworkshub-skill-reviewer",
    "trust": {
      "signal": "none",
      "reason": null,
      "signals": {
        "yellow": 0,
        "red": 0
      }
    },
    "review_summary": {
      "method_version": "capability-evidence-v2",
      "capability_definition": "strong",
      "contract_completeness": "natural_language",
      "access_friction": "low",
      "operational_transparency": "strong",
      "evidence_strength": "source_inspected",
      "use_readiness": "ready_for_guidance",
      "reviewed_at": "2026-09-03T06:08:35.457Z"
    },
    "experience_count": 0,
    "verified_experience_count": 0,
    "usage_count": 0,
    "success_rate": null,
    "first_seen_at": "2026-09-03T02:51:16.284Z",
    "last_seen_at": "2026-09-03T06:08:34.846Z",
    "published_at": "2026-09-03T06:08:34.846Z",
    "created_at": "2026-09-03T02:51:16.284Z",
    "updated_at": "2026-09-03T06:08:35.457Z",
    "api_url": "https://aiworkshub.io/api/v1/resources/RES_75C2CD458761",
    "reviews_url": "https://aiworkshub.io/api/v1/resources/RES_75C2CD458761/reviews",
    "public_url": "https://aiworkshub.io/resources/RES_75C2CD458761",
    "distribution": {
      "canonical_identity": "https://github.com/wshobson/agents/tree/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/developer-essentials/skills/sql-optimization-patterns",
      "syndicatable": true,
      "origins": [
        {
          "registry_url": "https://github.com/",
          "upstream_resource_id": "wshobson/agents:plugins/developer-essentials/skills/sql-optimization-patterns/SKILL.md",
          "upstream_record_url": "https://github.com/wshobson/agents/tree/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/developer-essentials/skills/sql-optimization-patterns",
          "relation": "syndicated",
          "metadata": {
            "source": "github-skill-import"
          },
          "first_seen_at": "2026-09-03T02:51:16.284Z",
          "last_seen_at": "2026-09-03T06:08:34.846Z"
        }
      ]
    },
    "tools": [],
    "review_profile": {
      "schema_version": "aiworkshub.resource-review/0.2",
      "method_version": "capability-evidence-v2",
      "review_state": {
        "identity": "verified",
        "source": "verified",
        "connectivity": "unknown",
        "contract": "strong",
        "safe_use": "untested",
        "real_use": "unobserved"
      },
      "assessment": {
        "capability_definition": "strong",
        "contract_completeness": "natural_language",
        "access_friction": "low",
        "operational_transparency": "strong",
        "evidence_strength": "source_inspected",
        "use_readiness": "ready_for_guidance"
      },
      "profile": {
        "capabilities": [
          {
            "id": "data.analyze",
            "weight": 90,
            "confidence": 90,
            "evidence_ids": [
              "source-record",
              "source-inspection"
            ]
          },
          {
            "id": "data.optimize",
            "weight": 90,
            "confidence": 90,
            "evidence_ids": [
              "source-record",
              "source-inspection"
            ]
          },
          {
            "id": "data.design",
            "weight": 70,
            "confidence": 70,
            "evidence_ids": [
              "source-record"
            ]
          },
          {
            "id": "code.generate",
            "weight": 60,
            "confidence": 60,
            "evidence_ids": [
              "source-record"
            ]
          }
        ],
        "domains": [
          {
            "id": "database",
            "weight": 100,
            "confidence": 100,
            "evidence_ids": [
              "source-record"
            ]
          },
          {
            "id": "software-development",
            "weight": 90,
            "confidence": 90,
            "evidence_ids": [
              "source-record"
            ]
          }
        ],
        "workflow_roles": [
          "analyze",
          "design",
          "generate",
          "instruct"
        ]
      },
      "capability_units": [
        {
          "id": "skill:sql-optimization-patterns",
          "kind": "skill_action",
          "capability_id": "data.optimize",
          "effect": "unknown",
          "open_world": false,
          "idempotency": "safe_to_retry",
          "confirmation": "explicit policy",
          "input_contract": "natural_language",
          "output_contract": "natural_language",
          "accepts": [
            "task context"
          ],
          "produces": [
            "task result"
          ],
          "runtime_auth": {},
          "pricing": {},
          "evidence_ids": [
            "source-inspection"
          ],
          "metadata": {}
        }
      ],
      "access": {
        "distribution_license": {
          "spdx_id": "MIT",
          "source": "https://github.com/wshobson/agents/blob/a30778f8c4e6b0a87567941b7cca4f534bf642b6/LICENSE"
        },
        "runtime_auth": {},
        "runtime_pricing": {},
        "dependencies": []
      },
      "operational_flags": [],
      "trust": {
        "signal": "none",
        "evidence_ids": [],
        "reason": null
      },
      "fit": {
        "good_for": [
          "Debugging slow SQL queries",
          "Designing database schemas with performance in mind",
          "Optimizing application response times",
          "Analyzing EXPLAIN query plans",
          "Implementing efficient indexes"
        ],
        "not_for": [
          "Non-SQL database optimization",
          "Real-time query monitoring without additional tools"
        ]
      },
      "evidence": [
        {
          "id": "source-record",
          "type": "source_record",
          "source": "https://raw.githubusercontent.com/wshobson/agents/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/developer-essentials/skills/sql-optimization-patterns/SKILL.md",
          "observation": "Submitted Skill record for sql-optimization-patterns; declared license MIT.",
          "observed_at": "2026-09-03T02:19:37Z",
          "payload": {}
        },
        {
          "id": "source-inspection",
          "type": "source_inspection",
          "source": "https://raw.githubusercontent.com/wshobson/agents/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/developer-essentials/skills/sql-optimization-patterns/SKILL.md",
          "observation": "The Skill source was fetched and inspected (5961 bytes; SHA-256 cfe8234323daaeb47577261c96933f519004fad2f45f1460f340b883af5d7354).",
          "observed_at": "2026-09-03T06:08:27.663Z",
          "payload": {}
        }
      ],
      "unknowns": [
        "Actual runtime behavior in agent environments",
        "Compatibility with specific database systems beyond PostgreSQL examples",
        "Effectiveness in real-world usage"
      ],
      "id": "REV_1C68790B9B4D",
      "resource_id": "RES_75C2CD458761",
      "evaluator_type": "platform_ai",
      "provider": "deepseek",
      "model": "deepseek-v4-flash",
      "review_scope": "source-inspected-skill",
      "created_at": "2026-09-03T06:08:35.457Z"
    }
  }
}