This is the final installment of our PostgresConf 2026 series. Read Part 2 here.
In my second talk at PostgresConf 2026, we moved from theory into deep mechanics. If we are going to build an agent-first infrastructure, we can't treat our databases like fragile, monolithic black boxes anymore. We have to treat them like modern software.
Modular Databases
For decades, developers have managed databases using linear, timestamped migration files. It's fragile, it's hard to test, and it makes collaborating across large teams a nightmare.
I introduced the crowd to our solution: pgpm (Postgres Package Manager).
Our vision is to treat Postgres schemas as composable, versioned modules. Imagine being able to install a complete, secure authentication schema or a fully-featured CRM schema into your database with a single command, just like you would run npm install in Node.js.
Test-Driven Database Development
By putting Postgres in package.json, we are moving away from fragile migrations and embracing test-driven database development with pgsql-test. With deterministic dependency graphs, we can make Postgres as agile, testable, and modular as modern application code.
This focus on testing isn't just a best practice—it's a survival requirement for AI. During my conversations at PostgresConf with the original Berkeley Postgres team, we bonded over the fact that database unit tests should actually be integration tests. You have to test from the client all the way down to the metal.
I told them about how we control our AI coding agents at Constructive: "I figured out the way to control these agents to help them actually write good quality code was through testing." The rule has to be unambiguous: the tests pass. No "that was a pre-existing failure," no skipping a check to turn the build green—the moment an agent has room to negotiate around a red test, quality slides.
When you combine this level of rigorous testing and modularity with the secure-by-default Postgres architecture we discussed in Part 2, you get a platform that is truly ready for the AI era. You get an agent-friendly database that is safe, composable, and blazing fast to build on.
Want to build the future of agent-first infrastructure with us? Check out what we're doing at Constructive.io.