菜单
Write PostgreSQL DDL and analytical SQL with explicit types, maintainable naming, and raw-to-analytics conventions.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Apply layer-specific quality checklists for Python ETL, Airflow DAGs, dbt models, SQL, FastAPI, Vue.js, and Docker Compose changes in the HH data platform.
Inspect git history and diffs to identify what changed, which platform layers are affected, and what risk signals to prioritise before applying review checklists.
Design small, maintainable Airflow DAGs with clear task boundaries, retry policy, and runtime assumptions.
Apply asyncio patterns for concurrent IO, background work, and coordinated refresh flows in Python analytics services.
Design dbt source, staging, and mart models with explicit schemas and clear layer responsibilities.
Break down a data-platform request into sequenced work items, dependencies, risks, and definition of done.
| name | postgres-sql |
| description | Write PostgreSQL DDL and analytical SQL with explicit types, maintainable naming, and raw-to-analytics conventions. |
| license | MIT |
| compatibility | opencode |
| metadata | {"audience":"data-engineers","domain":"postgres"} |
jsonb when useful for traceability.timestamptz for externally sourced event times.