{
  "ok": true,
  "resource": {
    "id": "RES_E43AAA18DBA8",
    "resource_type": "skill",
    "canonical_url": "https://github.com/wshobson/agents/tree/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/database-design/skills/postgresql-table-design",
    "name": "postgresql-table-design",
    "summary_en": "Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features",
    "summary_zh": "在设计或审查PostgreSQL专用模式时使用此技能。涵盖最佳实践、数据类型、索引、约束、性能模式及高级特性。",
    "description_en": "This skill provides guidance for designing or reviewing PostgreSQL-specific schemas. It covers best practices, data types, indexing, constraints, performance patterns, and advanced features. The skill is based on a SKILL.md file that includes core rules, PostgreSQL-specific gotchas, data type recommendations, constraint and indexing guidance, partitioning strategies, and worked SQL examples. It also references a details.md file for deeper material.",
    "description_zh": "此技能为设计或审查PostgreSQL专用模式提供指导。涵盖最佳实践、数据类型、索引、约束、性能模式及高级特性。该技能基于SKILL.md文件，包含核心规则、PostgreSQL特有陷阱、数据类型建议、约束和索引指导、分区策略及SQL示例。它还引用了details.md文件以获取更深入的材料。",
    "provider_name": "wshobson",
    "homepage_url": "https://github.com/wshobson/agents/tree/main/plugins/database-design/skills/postgresql-table-design",
    "endpoint_url": null,
    "source_url": "https://raw.githubusercontent.com/wshobson/agents/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/database-design/skills/postgresql-table-design/SKILL.md",
    "icon_url": null,
    "cover_image_url": null,
    "capabilities": [
      "database.design",
      "database.optimize",
      "database.review"
    ],
    "categories": [
      "developer-tools",
      "data"
    ],
    "industries": [
      "software",
      "general"
    ],
    "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/database-design/skills/postgresql-table-design/SKILL.md",
        "commit": "a30778f8c4e6b0a87567941b7cca4f534bf642b6",
        "stars": 39366,
        "forks": 4194,
        "updated_at": "2026-09-03T02:19:37Z"
      },
      "skill": {
        "compatibility": null,
        "allowed_tools": null,
        "content_hash": "1e27b0fac6d88a710cd925b831608ca202c40ade4f4e285a8e027dcf2f9a44ea",
        "line_count": 130
      },
      "review_gate": {
        "passed": true,
        "reasons": [],
        "policy_version": "review-gate-v1",
        "evaluated_at": "2026-09-03T05:51:54.502Z"
      }
    },
    "latest_version": "a30778f8c4e6",
    "status": "listed",
    "health_status": "unknown",
    "source_kind": "imported",
    "source_agent": "aiworkshub-skill-reviewer",
    "trust": {
      "signal": "none",
      "reason": "No suspicious or malicious evidence.",
      "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": "guided_use",
      "reviewed_at": "2026-09-03T05:51:55.342Z"
    },
    "experience_count": 0,
    "verified_experience_count": 0,
    "usage_count": 0,
    "success_rate": null,
    "first_seen_at": "2026-09-03T02:51:13.902Z",
    "last_seen_at": "2026-09-03T05:51:54.730Z",
    "published_at": "2026-09-03T05:51:54.730Z",
    "created_at": "2026-09-03T02:51:13.902Z",
    "updated_at": "2026-09-03T05:51:55.342Z",
    "api_url": "https://aiworkshub.io/api/v1/resources/RES_E43AAA18DBA8",
    "reviews_url": "https://aiworkshub.io/api/v1/resources/RES_E43AAA18DBA8/reviews",
    "public_url": "https://aiworkshub.io/resources/RES_E43AAA18DBA8",
    "distribution": {
      "canonical_identity": "https://github.com/wshobson/agents/tree/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/database-design/skills/postgresql-table-design",
      "syndicatable": true,
      "origins": [
        {
          "registry_url": "https://github.com/",
          "upstream_resource_id": "wshobson/agents:plugins/database-design/skills/postgresql-table-design/SKILL.md",
          "upstream_record_url": "https://github.com/wshobson/agents/tree/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/database-design/skills/postgresql-table-design",
          "relation": "syndicated",
          "metadata": {
            "source": "github-skill-import"
          },
          "first_seen_at": "2026-09-03T02:51:13.902Z",
          "last_seen_at": "2026-09-03T05:51:54.730Z"
        }
      ]
    },
    "tools": [],
    "review_profile": {
      "schema_version": "aiworkshub.resource-review/0.2",
      "method_version": "capability-evidence-v2",
      "review_state": {
        "identity": "verified",
        "source": "verified",
        "connectivity": "unknown",
        "contract": "natural_language",
        "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": "guided_use"
      },
      "profile": {
        "capabilities": [
          {
            "id": "database.design",
            "weight": 100,
            "confidence": 90,
            "evidence_ids": [
              "source-record",
              "source-inspection"
            ]
          },
          {
            "id": "database.optimize",
            "weight": 80,
            "confidence": 80,
            "evidence_ids": [
              "source-record",
              "source-inspection"
            ]
          },
          {
            "id": "database.review",
            "weight": 70,
            "confidence": 80,
            "evidence_ids": [
              "source-record",
              "source-inspection"
            ]
          }
        ],
        "domains": [
          {
            "id": "database",
            "weight": 100,
            "confidence": 90,
            "evidence_ids": [
              "source-record",
              "source-inspection"
            ]
          },
          {
            "id": "software-development",
            "weight": 80,
            "confidence": 80,
            "evidence_ids": [
              "source-record",
              "source-inspection"
            ]
          }
        ],
        "workflow_roles": [
          "design",
          "analyze"
        ]
      },
      "capability_units": [
        {
          "id": "skill:postgresql-table-design",
          "kind": "skill_action",
          "capability_id": "database.design",
          "effect": "advisory",
          "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": "No suspicious or malicious evidence."
      },
      "fit": {
        "good_for": [
          "Designing new PostgreSQL schemas",
          "Reviewing existing PostgreSQL schemas",
          "Choosing data types, constraints, and indexes",
          "Planning partitioning strategies"
        ],
        "not_for": [
          "Non-PostgreSQL databases",
          "Executing schema changes directly"
        ]
      },
      "evidence": [
        {
          "id": "source-record",
          "type": "source_record",
          "source": "https://raw.githubusercontent.com/wshobson/agents/a30778f8c4e6b0a87567941b7cca4f534bf642b6/plugins/database-design/skills/postgresql-table-design/SKILL.md",
          "observation": "Submitted Skill record for postgresql-table-design; 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/database-design/skills/postgresql-table-design/SKILL.md",
          "observation": "The Skill source was fetched and inspected (7912 bytes; SHA-256 1e27b0fac6d88a710cd925b831608ca202c40ade4f4e285a8e027dcf2f9a44ea).",
          "observed_at": "2026-09-03T05:51:47.829Z",
          "payload": {}
        }
      ],
      "unknowns": [
        "Actual usage in production environments",
        "Effectiveness of the skill in practice",
        "Compatibility with specific agent frameworks"
      ],
      "id": "REV_9F5B1AD2C28D",
      "resource_id": "RES_E43AAA18DBA8",
      "evaluator_type": "platform_ai",
      "provider": "deepseek",
      "model": "deepseek-v4-flash",
      "review_scope": "source-inspected-skill",
      "created_at": "2026-09-03T05:51:55.342Z"
    }
  }
}