Skip to content

slight76/data-standards

v1.0.1MIT

Team data standards for developers and AI agents: database design, naming, Postgres, migrations, persistence, caching, backup and restore

Changelog

All notable changes to this handbook. Versioning follows SemVer; rule IDs are never renamed or reused.

1.0.1 - 2026-10-07

  • Declare license: MIT in the skill frontmatter so gh skill publish validates cleanly.
  • Pin the shared docs-lint workflow to a marketplace commit SHA.

1.0.0 - 2026-10-07

First release of data-standards, split out of Slight76/architecture-standards (v0.3.0, commit c1bda3d) as decided in ADR-0001.

Moved from architecture-standards@c1bda3d

Rule IDs, statements, and historic ADR references are unchanged. Wording was adjusted from "enterprise" to "team" and links were rewritten for the new repository layout; frontmatter was added.

New locationFormer locationRules
docs/database-architecture.mddatabase/architecture.mdDB-001..DB-005
docs/design-standard.mddatabase/design-standard.mdDB-006..DB-008
docs/migration-recovery-standard.mddatabase/migration-recovery-standard.mdMIG-001, MIG-002, DR-001
docs/persistence-standard.mdbackend/persistence-standard.mdDATA-001..DATA-003
docs/caching-standard.mdbackend/caching-standard.mdCACHE-001, CACHE-002

Added

  • docs/naming-conventions.md with rules NAME-001..NAME-004 (snake_case, plural tables, named constraints, module schemas, timestamp columns, enums, EF Core mapping).
  • docs/postgres-anti-patterns.md with rules PGX-001..PGX-003 (FK indexes, keyset pagination, non-locking migrations) and a review checklist.
  • docs/backup-restore-runbook.md (pg_dump/pg_restore and Fly Postgres procedures, restore drill cadence, evidence; verifies DB-005 and DR-001).
  • catalog/catalog.json scoped to this handbook with externalDecisions for ADR-0005, ADR-0016, ADR-0018, ADR-0019.
  • adr/0001-adopt-data-standards.md.
  • skills/data-standards/SKILL.md with references/read-by-task.md and references/catalog-digest.md.
  • plugin.json, README.md, AGENTS.md, CLAUDE.md, MIT LICENSE, lint configuration, and the shared docs.yml workflow.