# Why Agents Love Supabase — with Paul Copplestone and Ant Wilson

## Executive summary

Supabase co-founders Paul Copplestone and Ant Wilson detail the company's strategy for becoming the preeminent open-source, integrated backend for AI-built applications. The core focus is on enabling AI agents by providing a seamless 'build, operate, and scale' experience. Key technical advancements include collocated compute (Supabase Compute), performance enhancements (OrioleDB), and massive scaling solutions (Multigress and the acquisition of Turso) designed to handle billions of databases per month.

## Key takeaways

- Agent-Centric Development Model: The platform is evolving to support AI agents by prioritizing a 'code-first' approach. This includes using declarative schemas (via PG Delta) to allow agents to understand the full shape of the database (tables, policies, comments) directly from the file system, rather than relying on traditional migration files.
- Integrated Compute and Database: Supabase Compute offers a long-running, serverless, collocated compute environment (similar to a containerized Lambda function) running on the same private network as the database. This minimizes latency and allows agents to run complex workloads (like chunking and embedding) directly from the database connection.
- Scaling to Billions of Databases: To handle massive scale, Supabase announced Multigress, a groundup rewrite of the Postgres operator designed for sharding. The goal is to allow zero-code changes for users scaling their databases, alongside the acquisition of Turso, which specializes in MVCC for SQLite, enabling agentic databases.
- Product-Led Growth (PLG) Strategy: The company's enterprise strategy focuses on winning 'green field' use cases (new builds) rather than complex database migrations. They leverage product triggers (e.g., hitting scaling limits or errors) to initiate sales conversations, making the platform sticky from day one.

## Technical details

- Database Performance & Reliability: OrioleDB is a drop-in replacement for the current Postgres `heap` storage engine, offering 1.5 to 2 times faster performance and removing the need for background tasks like `vacuum` cleanup. It is fully compatible with Postgres and released under an Apache 2 license.
- Database Scaling (Sharding): Multigress is a major rewrite of the Postgres operator designed to manage multi-node clusters and sharding. It aims to provide sharding capabilities with zero required code changes for the user, ensuring high stability even after rigorous testing (1,000 sequential failovers).
- Local Development & Schema Management: The introduction of declarative schemas, facilitated by the PG Delta library, allows developers to represent the full shape of a Postgres database (tables, policies, comments) in a file system folder. This is critical for agents, as it provides a complete, easily crawlable source of truth without needing to run slow introspection queries.
- Compute Architecture: Supabase Compute provides a full, long-running, serverless compute instance collocated with the database. Unlike previous limitations (e.g., Deno's 2C limit), this environment supports multiple languages (Rust, Python) and is designed to host complex agentic workloads.

## Practical implications

- For build engineers, the shift toward declarative schemas and local file system representations (PG Delta) simplifies the process of having AI agents interact with and understand complex database structures.
- The emphasis on collocated, long-running compute (Supabase Compute) means that complex backend processes (like embedding or chunking) can be executed with minimal latency, treating the backend as a single, integrated unit.
- The focus on 'green field' development and product triggers suggests that modern backend architecture should prioritize rapid iteration and initial adoption over complex, multi-stage migrations.
- The architectural trend points toward specialized, highly scalable backends (like Turso for SQLite) and robust sharding solutions (Multigress) to support massive, decentralized deployments.

## Topics

PostgreSQL, AI Agents, Backend Development, Database Scaling, Serverless Computing, DevOps, Open Source, Supabase, Supabase Select, PG Delta, Turso

Source: https://www.youtube.com/watch?v=zHG6sAss_kE