All queries in postgres.new run directly in your browser. There’s no remote Postgres container or WebSocket proxy.
How is this possible? PGlite, a WASM version of Postgres that can run directly in your browser. Every database that you create spins up a new instance of PGlite that exposes a fully-functional Postgres database. Data is stored in IndexedDB so that changes persist after refresh.
Every Supabase project is a dedicated Postgres instance. You can connect to it directly, via our scalable connection pooler, or with your favourite ORM, Drizzle, Prisma etc.