{
  "ok": true,
  "resource": {
    "id": "RES_C32BAA0B73A1",
    "resource_type": "skill",
    "canonical_url": "https://github.com/majiayu000/claude-skill-registry/tree/HEAD/skills/data/async-sqlalchemy-patterns",
    "name": "async-sqlalchemy-patterns",
    "summary_en": "Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sessions, setting up migrations, optimizing queries, managing relationships, or when",
    "summary_zh": "用于数据库处理与研究与检索，支持 async-sqlalchemy-patterns 条目描述的相关任务。",
    "description_en": "Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sessions, setting up migrations, optimizing queries, managing relationships, or when",
    "description_zh": "用于数据库处理与研究与检索，支持 async-sqlalchemy-patterns 条目描述的相关任务。",
    "provider_name": "majiayu000",
    "homepage_url": "https://github.com/majiayu000/claude-skill-registry",
    "endpoint_url": null,
    "source_url": "https://github.com/majiayu000/claude-skill-registry/blob/8929dcba0964653ab807d28d1c1df10eb706f7d2/skills/data/async-sqlalchemy-patterns/SKILL.md",
    "icon_url": null,
    "cover_image_url": null,
    "capabilities": [
      "database",
      "research-retrieval"
    ],
    "categories": [
      "agent-skill"
    ],
    "industries": [],
    "protocols": [
      "agent-skills"
    ],
    "auth": {
      "type": "none",
      "required": false
    },
    "pricing": {
      "model": "free"
    },
    "input_schema": {},
    "output_schema": {},
    "metadata": {
      "content_language": "en",
      "translation_status": "luna-reviewed",
      "license": {
        "spdx_id": "MIT"
      },
      "github": {
        "repository": "majiayu000/claude-skill-registry",
        "path": "skills/data/async-sqlalchemy-patterns/SKILL.md",
        "stars": 590
      },
      "skill": {
        "content_hash": "58f4dc810c4881f2"
      },
      "review_gate": {
        "passed": true,
        "policy_version": "capability-evidence-v3-luna-full",
        "provider": "codex",
        "model": "luna",
        "source_review_id": "58f4dc810c4881f2",
        "content_hash": "58f4dc810c4881f2"
      }
    },
    "latest_version": "8929dcba0964",
    "status": "listed",
    "health_status": "unknown",
    "source_kind": "imported",
    "source_agent": "aiworkshub-luna-batch-reviewer",
    "trust": {
      "signal": "none",
      "reason": null,
      "signals": {
        "yellow": 0,
        "red": 0
      }
    },
    "review_summary": {
      "method_version": "capability-evidence-v3-luna-full",
      "capability_definition": "strong",
      "contract_completeness": "natural_language",
      "access_friction": "low",
      "operational_transparency": "partial",
      "evidence_strength": "source_inspected",
      "use_readiness": "guided_use",
      "reviewed_at": "2026-09-03T13:47:33.005Z"
    },
    "experience_count": 0,
    "verified_experience_count": 0,
    "usage_count": 0,
    "success_rate": null,
    "first_seen_at": "2026-09-03T13:47:32.096Z",
    "last_seen_at": "2026-09-03T13:47:32.096Z",
    "published_at": "2026-09-03T13:47:32.096Z",
    "created_at": "2026-09-03T13:47:32.096Z",
    "updated_at": "2026-09-03T13:47:33.005Z",
    "api_url": "https://aiworkshub.io/api/v1/resources/RES_C32BAA0B73A1",
    "reviews_url": "https://aiworkshub.io/api/v1/resources/RES_C32BAA0B73A1/reviews",
    "public_url": "https://aiworkshub.io/resources/RES_C32BAA0B73A1",
    "distribution": {
      "canonical_identity": "https://github.com/majiayu000/claude-skill-registry/tree/HEAD/skills/data/async-sqlalchemy-patterns",
      "syndicatable": true,
      "origins": [
        {
          "registry_url": "https://github.com/",
          "upstream_resource_id": "majiayu000/claude-skill-registry:skills/data/async-sqlalchemy-patterns/SKILL.md",
          "upstream_record_url": "https://github.com/majiayu000/claude-skill-registry/tree/HEAD/skills/data/async-sqlalchemy-patterns",
          "relation": "syndicated",
          "metadata": {
            "source": "github-code-search"
          },
          "first_seen_at": "2026-09-03T13:47:32.096Z",
          "last_seen_at": "2026-09-03T13:47:32.096Z"
        }
      ]
    },
    "tools": [],
    "review_profile": {
      "schema_version": "aiworkshub.resource-review/0.2",
      "method_version": "capability-evidence-v3-luna-full",
      "review_state": {
        "identity": "observed",
        "source": "screened",
        "connectivity": "unknown",
        "contract": "partial",
        "safe_use": "untested",
        "real_use": "unobserved"
      },
      "assessment": {
        "capability_definition": "strong",
        "contract_completeness": "natural_language",
        "access_friction": "low",
        "operational_transparency": "partial",
        "evidence_strength": "source_inspected",
        "use_readiness": "guided_use"
      },
      "profile": {
        "capabilities": [
          {
            "id": "database",
            "weight": 100,
            "confidence": 88,
            "evidence_ids": [
              "source-record"
            ]
          },
          {
            "id": "research-retrieval",
            "weight": 80,
            "confidence": 88,
            "evidence_ids": [
              "source-record"
            ]
          }
        ],
        "domains": [],
        "workflow_roles": [
          "execute",
          "retrieve"
        ]
      },
      "capability_units": [
        {
          "id": "skill:async-sqlalchemy-patterns",
          "kind": "skill_action",
          "capability_id": "database",
          "effect": "unknown",
          "open_world": false,
          "idempotency": "unknown",
          "confirmation": "unknown",
          "input_contract": "natural_language",
          "output_contract": "natural_language",
          "accepts": [
            "task context"
          ],
          "produces": [
            "task result"
          ],
          "runtime_auth": {},
          "pricing": {},
          "evidence_ids": [
            "source-record"
          ],
          "metadata": {
            "source": "skill-document"
          }
        }
      ],
      "access": {},
      "operational_flags": [
        "runtime-not-tested"
      ],
      "trust": {
        "signal": "none",
        "evidence_ids": [],
        "reason": null
      },
      "fit": {
        "good_for": [
          "Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sess"
        ],
        "not_for": []
      },
      "evidence": [
        {
          "id": "source-record",
          "type": "source_inspection",
          "source": "https://github.com/majiayu000/claude-skill-registry/blob/8929dcba0964653ab807d28d1c1df10eb706f7d2/skills/data/async-sqlalchemy-patterns/SKILL.md",
          "observation": "GitHub Skill source passed deterministic screening and Luna batch review.",
          "observed_at": null,
          "payload": {
            "source_review_id": "58f4dc810c4881f2",
            "resource_type": "skill"
          }
        }
      ],
      "unknowns": [
        "Runtime behavior, dependencies, and side effects were not tested."
      ],
      "id": "REV_D4111DB83941",
      "resource_id": "RES_C32BAA0B73A1",
      "evaluator_type": "platform_ai",
      "provider": "codex",
      "model": "luna",
      "review_scope": "metadata-batch",
      "created_at": "2026-09-03T13:47:33.005Z"
    }
  }
}