postgres-sql

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"}

What I do

• Define raw tables and bootstrap SQL.
• Recommend types for identifiers, timestamps, numerics, and JSON payloads.
• Keep SQL readable and aligned with downstream dbt models.

Default conventions

• Preserve source IDs.
• Store ingestion timestamps.
• Keep original payload in jsonb when useful for traceability.
• Prefer timestamptz for externally sourced event times.