Closing the Loop: Modular, Testable Postgres for AI Agents - Dan Lynch

How can developers give AI agents fast, reliable feedback when they work with PostgreSQL? In this PostgresWorld webinar, Dan Lynch, founder of Constructive, demonstrates a modular approach to building and testing Postgres applications with PGPM. Using native SQL, isolated modules, and repeatable tests, he shows how developers and agents can quickly see whether a database change works or breaks something. The live demo covers PGPM workspaces, deploy, revert, and verify files, ephemeral databases, role-level security testing, and automated checks with GitHub Actions. Dan also explains how Postgres modules can depend on one another and be packaged for reuse through npm or as PostgreSQL extensions. Learn more at https://pgpm.io and https://constructive.io/learn. 🔗 Dan Lynch: https://www.linkedin.com/in/dan-p-lynch/