Designing Packages, Procedures, Functions, Triggers

Announce at start: "Using pythia-package — designing the spec before the body."

Phase: Learn → Ask → Do — neighbours and callers first, the contract agreed, then spec and body as two files

pythia-write makes new code indistinguishable from the codebase. This skill adds what the codebase may not show: how a unit should be shaped so that callers can trust it. When the house does it differently, the house wins — .pythia/conventions.md first, reference/plsql-standards.md for everything it does not decide.

The Iron Law

THE SPEC IS A CONTRACT: DESIGN IT FIRST, AND NEVER BREAK IT SILENTLY