#0001
`Postgres.new`: browser Postgres sandbox with AI control
80radar
Postgres.newBrowser DB sandbox — AI runs and retries SQL directly
A full Postgres sandbox now runs entirely in the browser with PGlite, and the LLM gets unrestricted DB access to retry SQL until it works. Useful as a zero-setup playground for schema, SQL, CSV, charts, and lightweight RAG flows before deploying anything.
PGliteshrinks Postgres-in-WASM from roughly 30MB to under 3MB, which changes browser startup and shareability.- The LLM can run back-to-back SQL with full permissions and use Postgres errors as feedback, so natural-language tasks complete more reliably than one-shot query generation.
- CSV upload creates tables automatically, then the same session can query them in plain English and generate charts with editable colors.
pgvectorworks in-browser, and embeddings are generated locally withtransformers.js, making small RAG demos possible without external infra.- A read-only deployment path via
pg-gatewayand S3 is next, which opens a clean handoff from local browser sandbox to sharable Postgres endpoints.
Source: supabase.com/blog/postgres-newRead original →