The Complete PostgreSQL Backend
Auth, REST, live SQL queries, edge functions, storage, a job queue,
auto-HTTPS and a Studio dashboard.
Two processes. One command.
$ npx pgstack init myapp && cd myapp && pgstack dev
Everything you need to build and ship a production backend, powered entirely by PostgreSQL.
Email/password (argon2id), OAuth, magic links, JWT. Row-Level Security on every request via a two-pool least-privilege model — hardened against 26 documented trust-boundary invariants.
PostgREST-compatible CRUD with filters, embedding, RPC, and auto-generated OpenAPI. Zero boilerplate.
SQL-level reactivity via pg_reactive. Column-level change tracking, delta computation over WebSocket, generation-isolated tenancy. No CDC, no polling.
File upload and download with bucket ACLs. Public and private access control. No S3 dependency required.
Table editor, SQL editor, auth manager, and realtime monitor. All in a browser-based admin panel.
Project scaffolding, dev server, migrations, type generation, and deployment. One tool for the full lifecycle.
One endpoint, five runtimes: embedded JS (goja), PL/v8, PL/Python, a Deno sidecar, or a per-function HTTP container in any language. Pick per function.
Automatic Let's Encrypt certificates (ACME), provisioned and renewed for your domains. Serve your SPA and assets straight from the proxy, gzip-compressed. No nginx, no certbot.
Durable background jobs and scheduled tasks with no Redis or RabbitMQ. Jobs are rows. Failures retry. Observability is a SELECT.
No orchestrator. No message broker. No cache layer. Just PostgreSQL doing what it does best — and the proxy ships as two co-equal builds, Go or Rust, hardened to parity.
From zero to a full backend with auth, REST, and live queries.
Initialize a new pgStack project with all configuration files and a default migration.
Launches PostgreSQL with pg_reactive and the proxy server. Hot-reloads on migration changes.
Use the TypeScript SDK, REST API, or raw SQL. Add auth, live queries, and storage as needed.
Interactive demos showing real-time SQL subscriptions, from simple filters to full-stack applications.
Live-updating product catalog — the simplest end-to-end demo.
BasicStreaming order feed with live status transitions.
BasicLive GROUP BY aggregate with rolling charts that recompute on every write.
IntermediateWindow functions in a live query — ranks shifting as the data lands.
IntermediateCustomer activity stream with row-level filtering and per-row badges.
IntermediateLow-stock alerts and threshold tripwires triggered from the live subscription.
IntermediateSeveral independent live queries sharing one WebSocket connection.
IntermediateComposite live charts driven by joins and CTEs against the order stream.
AdvancedLive pivot — products by vendor — recomputed without a polling loop.
AdvancedTop-level KPIs aggregating multiple feeds into one live dashboard.
AdvancedSame data — notify vs delta side-by-side. Pick the wire for the job.
IntermediateStep-by-step walkthrough — subscribe, mutate, watch deltas arrive.
TutorialComplete todo application with auth, REST, and real-time sync.
Full-stackMulti-user expense tracker with auth, REST, and a live shared ledger.
Full-stack