# Neon opens live SQL subscriptions in Realtime beta — but row-level security is not ready

Neon's October 15 Realtime beta lets apps subscribe to deterministic SQL query results, including joins and aggregates, directly against branch-aware Postgres. It removes a separate sync service but is not yet a production-ready replacement for every realtime stack.

Live SQL subscriptions, a React/TypeScript SDK and scale-to-zero integration are available in four regions. Realtime is free during beta, but compute and egress still cost money, row-level security is absent, and the protocol is changing.

- Status: Active
- Published: 2026-10-16T06:16:40+13:00
- Updated: 2026-10-16T06:16:40+13:00
- Categories: Web Development, SaaS, Cloud & Infrastructure, Frameworks, SaaS Operations, Databases & Storage
- Tags: live queries, Neon, PostgreSQL, realtime databases, serverless databases
- Canonical HTML: https://beyondthe.news/dossiers/neon-realtime-public-beta-live-sql-subscriptions-no-rls-2026

## What changed

On October 15, 2026, Neon made Realtime available in public beta on its Lakebase Postgres backend. Developers can subscribe to the changing result of a read-only deterministic SQL query, including joins, aggregations and window functions, rather than consuming raw table change events and reconstructing UI state. The TypeScript SDK supports sealed queries created on a trusted backend and subscription from clients; React, Drizzle, Kysely, TanStack DB and SSR integrations are described. Realtime follows database branches and is designed to scale to zero.

## Why it matters

For builders of collaborative SaaS, dashboards, notifications and agent-status interfaces, the shift is from separately wiring polling, change feeds and sync state to declaring the result the UI needs. Branch awareness may reduce staging/production cross-wiring. The beta is important as an architectural option, not proof of mature scale or security: Neon explicitly says row-level security is not supported yet and has not published production benchmarks.

## Live SQL rather than raw change events

Neon says any read-only deterministic SQL query can be subscribed to, including joins, aggregates and subqueries. The subscription maintains the result set when relevant database writes commit. This is more expressive than table-level notifications, though real workload costs and throughput have not been independently established.

## How developers connect

The Neon CLI enables Realtime per branch and can subscribe directly from the terminal. Backend code defines and seals queries using a secret, while frontend code subscribes using the SDK or React useLiveQuery. Drizzle and Kysely adapters and TanStack DB integration support existing application structures. Query parameters tied to user identity must be set on the trusted backend.

## Branching, scale-to-zero and cost

Subscriptions connect through Neon's ingress layer, and incremental processing is described as running on a replica. The company says live subscriptions need not hold a primary database connection open. Realtime itself is free during beta, but database compute and network egress remain billable; enabling or starting a query can wake a database.

## Security and rollout boundaries

The initial public beta supports us-east-1, us-east-2, eu-central-1 and ap-southeast-1. Neon states that row-level security is not yet available, the raw protocol is still changing and the console experience is minimal. Production systems handling per-user data need to assess the sealed-query model, authorisation, tenancy and leak risks before replacing established sync architecture.

## What is and is not verified

The official launch and earlier Electric-team engineering preview document the design and rollout. Claims of large-enterprise scalability and cost-efficiency are vendor statements without published benchmark methodology. The relevant decision is whether to trial the SDK in an isolated branch, not assume performance parity with established realtime services.

## Key details

- Public beta announced October 15, 2026.
- Subscriptions cover deterministic read-only SQL including joins and aggregates.
- TypeScript/React SDK, Drizzle/Kysely adapters and TanStack DB integration.
- Per-branch enablement, server-sealed queries and scale-to-zero support.
- No row-level security in beta; raw protocol subject to change.
- Four initial regions; beta Realtime free but compute and egress billed.

## Builder takeaways

- Test a representative live query on a staging branch before replacing polling or an existing sync service.
- Enforce per-user authorisation in backend query sealing; do not assume Postgres RLS protects beta subscriptions.
- Budget for database wakeups, compute and egress despite free beta Realtime.
- Use the supported SDK rather than coding against an unstable wire protocol.
- Measure latency, reconnect behaviour and resource use with your own workload.

## What to watch

- Introduction of row-level security and stronger tenancy guarantees.
- Published production benchmarks, pricing after beta and additional regions.
- Protocol stability, SDK compatibility and reconnect/recovery guarantees.
- Independent comparisons against Electric, Supabase Realtime and polling.

## Uncertainties

- No independent benchmark replication is available for the new service.
- Neon has not committed to final post-beta pricing or a GA date.
- Beta documentation may change, and RLS is not yet supported.

## Sources

- [Neon now has realtime](https://neon.com/blog/neon-now-has-realtime) — Neon · primary product announcement · 2026-10-15T00:00:00+13:00. Public beta features, SDK, limitations, regions, free beta and billing.
- [Electrifying Neon: building the realtime backend](https://neon.com/blog/electrifying-neon-building-the-realtime-backend) — Neon · primary engineering context · 2026-09-24T00:00:00+12:00. Electric team's earlier architecture and roadmap; not independent validation.

