pgStack

The Complete PostgreSQL Backend

Auth, REST API, Live Queries, Storage, and Dashboard.
Two processes. One command.

$ npx pgstack init myapp && cd myapp && pgstack dev
Open Studio Documentation
Everything included

Six pillars. Zero glue code.

Everything you need to build a production backend, powered entirely by PostgreSQL.

Authentication

Email/password, OAuth (Google, GitHub), magic links. JWT tokens with PostgreSQL RLS for row-level security.

REST API

PostgREST-compatible CRUD with filters, embedding, RPC, and auto-generated OpenAPI. Zero boilerplate.

Live Queries

SQL-level reactivity via pg_reactive. Column-level change tracking, delta computation, WebSocket delivery.

Storage

File upload and download with bucket ACLs. Public and private access control. No S3 dependency required.

Studio Dashboard

Table editor, SQL editor, auth manager, and realtime monitor. All in a browser-based admin panel.

CLI

Project scaffolding, dev server, migrations, type generation, and deployment. One tool for the full lifecycle.

Architecture

Radically simple infrastructure

No orchestrator. No message broker. No cache layer. Just PostgreSQL doing what it does best.

Your App ---> pgstack-proxy ---> PostgreSQL REST, Auth, + pg_reactive WebSocket extension
Typical BaaS
15+ containers
pgStack
2 processes
Get started

Up and running in 60 seconds

From zero to a full backend with auth, REST, and live queries.

1

Scaffold your project

Initialize a new pgStack project with all configuration files and a default migration.

npx pgstack init myapp
2

Start the dev server

Launches PostgreSQL with pg_reactive and the proxy server. Hot-reloads on migration changes.

cd myapp && pgstack dev
3

Build your app

Use the TypeScript SDK, REST API, or raw SQL. Add auth, live queries, and storage as needed.

import { createClient } from '@pgstack/sdk'
See it in action

Live examples

Interactive demos showing real-time SQL subscriptions, from simple filters to full-stack applications.

Example 01
Live Products Dashboard

Real-time product catalog with live price and stock updates.

Basic
Example 02
Order Feed

Streaming order feed with live status transitions.

Basic
Example 03
Revenue Dashboard

Aggregate revenue metrics updating in real time.

Intermediate
Example 04
Category Leaderboard

Live-ranked leaderboard with animated position changes.

Intermediate
Example 05
Realtime CRM

Customer pipeline with multi-stage live tracking.

Advanced
Example 06
Inventory Monitor

Stock level monitoring with threshold alerts.

Intermediate
Tutorial
Interactive Tutorial

Step-by-step guide to building live queries from scratch.

Basic
Full-stack App
Todo App

Complete todo application with auth, REST, and real-time sync.

Full-stack
Full-stack App
Shopping List

Collaborative shopping list PWA with sharing and live updates.

Full-stack