菜单
Use when designing schemas, writing migrations, reviewing queries, or establishing data access patterns. Provides schema design, migration, query review, and data dictionary templates.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Use when designing Copilot agents, authoring agent definitions, creating skill folders, or scaffolding instruction files. Provides templates and conventions for the agent ecosystem.
Use when designing, reviewing, or evolving API contracts. Provides OpenAPI templates, breaking-change checklists, versioning decision trees, and governance checklists.
API authentication, authorization, input validation, rate limiting, and protection patterns
Scan legacy applications to discover project structure, NuGet/npm dependencies, database connection strings, external service bindings, framework versions, and migration complexity scores. Produces structured JSON, YAML, or Markdown inventory reports.
Use when designing systems, recording architecture decisions, evaluating technologies, or assessing architectural risks. Provides C4 diagram templates, ADR format, technology selection matrices, and risk registers.
Deploy, scale, and manage containerized applications on Azure Container Apps with Dapr, revision management, and advanced networking
| name | data-tier |
| description | Use when designing schemas, writing migrations, reviewing queries, or establishing data access patterns. Provides schema design, migration, query review, and data dictionary templates. |
| compatibility | ["VS Code","Cursor","Windsurf","Claude Code"] |
| metadata | {"category":"Uncategorized","tags":["uncategorized"],"maturity":"beta","audience":["developers"]} |
| allowed-tools | ["bash","git","grep","find"] |
Use this skill when the task involves schema design, database migrations, query review, indexing strategy, or data access pattern definition.
Reference this skill by attaching skills/data-tier/SKILL.md to your agent context, or instruct the agent:
Use the data-tier skill. Apply the schema design template, migration template, and query review checklist to the data work being done.
| Template | Purpose |
|---|---|
schema-design-template.md | Schema design document: entities, attributes, relationships, constraints, and indexes |
migration-template.md | Migration scaffold with up/down blocks, rollback plan, and zero-downtime notes |
query-review-checklist.md | Query review checklist: N+1 check, index usage, pagination, explain plan guidance |
data-dictionary-template.md | Data dictionary: table, column, type, nullable, description, and example values |
This skill is designed to be used alongside the data-tier agent. The agent drives the workflow; this skill provides the reference templates and review checklists.
The data tier persists domain entities defined by the backend-dev agent. Changes to schema require coordination with the backend-dev agent to keep repository patterns aligned.
