# onwardpg

> PostgreSQL migration planning around one evolving application deployment, with compatibility-aware expand/contract SQL, captured semantic decisions, and disposable verification.

Start with [the onwardpg agent skill](https://onwardpg.solberg.is/skill.md) when operating onwardpg. It contains the workflow, constraints, and required evidence handoff. This file is the documentation directory, not the operating procedure.

## Start here

- [Introduction](https://onwardpg.solberg.is/start/introduction): Plan the PostgreSQL schema that old and new application code can safely share through one rolling deployment. ([raw Markdown](https://onwardpg.solberg.is/start/introduction.md))
- [Comparison](https://onwardpg.solberg.is/start/comparison): See why onwardpg plans one compatibility-safe PostgreSQL migration around one merge and one rolling application deployment. ([raw Markdown](https://onwardpg.solberg.is/start/comparison.md))
- [Installation](https://onwardpg.solberg.is/start/installation): Install onwardpg and connect authoritative DDL, development, and scratch PostgreSQL. ([raw Markdown](https://onwardpg.solberg.is/start/installation.md))
- [Your first plan](https://onwardpg.solberg.is/start/first-plan): Establish history, evolve desired DDL, answer ambiguity, and verify a bundle. ([raw Markdown](https://onwardpg.solberg.is/start/first-plan.md))

## Core concepts

- [The plan command](https://onwardpg.solberg.is/concepts/plan-command): One evolving migration reconciles accepted history, working DDL, and a branch-worn development database. ([raw Markdown](https://onwardpg.solberg.is/concepts/plan-command.md))
- [Expand and contract](https://onwardpg.solberg.is/concepts/expand-contract): One migration bundle surrounds exactly one application rollout. ([raw Markdown](https://onwardpg.solberg.is/concepts/expand-contract.md))
- [Contract readiness](https://onwardpg.solberg.is/concepts/contract-readiness): Prove the post-expand catalog, overlap data, and every potential writer before restoring enforcement. ([raw Markdown](https://onwardpg.solberg.is/concepts/contract-readiness.md))
- [Decisions and manual work](https://onwardpg.solberg.is/concepts/decisions): How onwardpg handles intent and product semantics that catalogs cannot prove. ([raw Markdown](https://onwardpg.solberg.is/concepts/decisions.md))
- [What verification proves](https://onwardpg.solberg.is/concepts/verification): Understand clone convergence evidence and the operational facts it cannot establish. ([raw Markdown](https://onwardpg.solberg.is/concepts/verification.md))

## Framework guides

- [Drizzle](https://onwardpg.solberg.is/guides/drizzle): Export complete Drizzle PostgreSQL DDL and carry one plan through development, merge, and the next feature. ([raw Markdown](https://onwardpg.solberg.is/guides/drizzle.md))
- [Django](https://onwardpg.solberg.is/guides/django): Materialize final Django migration state hermetically, export PostgreSQL DDL, and give one runner ownership of production changes. ([raw Markdown](https://onwardpg.solberg.is/guides/django.md))
- [Prisma](https://onwardpg.solberg.is/guides/prisma): Generate complete PostgreSQL DDL from an empty source to the current Prisma schema. ([raw Markdown](https://onwardpg.solberg.is/guides/prisma.md))
- [SQLAlchemy and Alembic](https://onwardpg.solberg.is/guides/sqlalchemy): Turn Alembic history into deterministic from-empty DDL for onwardpg. ([raw Markdown](https://onwardpg.solberg.is/guides/sqlalchemy.md))

## Coding agents

- [Agent-assisted planning](https://onwardpg.solberg.is/agents/agent-assisted-planning): Give coding agents a strict planning protocol and carefully scoped production evidence. ([raw Markdown](https://onwardpg.solberg.is/agents/agent-assisted-planning.md))

## Delivery

- [GitHub Actions](https://onwardpg.solberg.is/delivery/github-actions): Scaffold a deployment pipeline that sandwiches the app rollout between expand and contract. ([raw Markdown](https://onwardpg.solberg.is/delivery/github-actions.md))
- [Production runbook](https://onwardpg.solberg.is/delivery/production-runbook): Operational checks for safely applying an onwardpg bundle. ([raw Markdown](https://onwardpg.solberg.is/delivery/production-runbook.md))

## Reference

- [CLI reference](https://onwardpg.solberg.is/reference/cli): The preferred onwardpg authoring, verification, development, and drift commands. ([raw Markdown](https://onwardpg.solberg.is/reference/cli.md))
- [Generated CLI help](https://onwardpg.solberg.is/reference/generated-cli-help): Exact help emitted by the current onwardpg binary for every documented command surface. ([raw Markdown](https://onwardpg.solberg.is/reference/generated-cli-help.md))
- [Safety boundary](https://onwardpg.solberg.is/reference/safety): What onwardpg is allowed to touch, where it fails closed, and what reviewers still own. ([raw Markdown](https://onwardpg.solberg.is/reference/safety.md))

## Optional

- [Complete documentation corpus](https://onwardpg.solberg.is/llms-full.txt): Every public documentation page in one file; use only when bulk context is appropriate.