Closing the Loop: Modular, Testable Postgres for AI Agents

Coding agents don’t need better instructions. They need a tighter feedback loop.

This session shows how to build that loop directly into Postgres. We’ll use `pgpm`, a Postgres package manager, to turn schemas into composable, versioned modules with deterministic dependencies, then test them against the real database with `pgsql-test` — including roles, permissions, functions, constraints, and RLS.

From there, we close the loop: write → test → fix → push → CI/CD.

That changes the role of testing. Tests are no longer just something humans run before shipping; they become the control system for coding agents. An agent can generate code quickly, but the database provides the deterministic signal for whether that code is actually correct.

| We’ll build a modular schema live, let an agent extend it, and let the tests decide what ships |
| ---------------------------------------------------------------------------------------------- |
|