---
title: "Neon Realtime"
type: skill
id: "neon-skills/neon-postgres/neon-realtime"
category: "Engineering"
publisher: "Neon"
license: "Apache-2.0"
source: "https://github.com/neondatabase/agent-skills/tree/ea79164"
canonical: "https://labs.pho.chat/en/skills/neon-skills/neon-postgres/neon-realtime"
open_in_pho: "https://pho.chat/customize?item=neon-skills%2Fneon-postgres%2Fneon-realtime&utm_source=labs&utm_medium=skill-page&utm_campaign=skills-library"
---

# Neon Realtime

Neon Realtime makes any SQL query live. Build realtime, reactive apps and agents on Lakebase Postgres with live SQL queries and reactivity primitives. Use when app UI or agent state must update live from database rows (dashboards, feeds, collaboration, multi-user or multi-device sync), for optimistic mutations, or to replace polling or other realtime sync systems. Triggers include "live query", "subscribe", "sync engine", "useLiveQuery", "TanStack DB", "optimistic updates", "@neon/realtime". For push that doesn't come from database rows (presence, typing, LLM streams), use neon-functions.

Source: Neon (Apache 2.0), copied at a pinned commit. Free to use. Part of the Phở Skills library (https://labs.pho.chat/en/skills).
Skill set: Neon Postgres (https://labs.pho.chat/en/skills/neon-skills/neon-postgres.md).

## What it covers
- How It Works
- Core Pattern
- Choose the Stack
- Setup
- Define and Seal Queries
- Subscribe
- Optimistic Writes
- Server-Side Rendering
- More Docs

## Other skills in this set
- [Neon](https://labs.pho.chat/en/skills/neon-skills/neon-postgres/neon.md): Overview of Neon, a complete set of cloud backend primitives around Lakebase Postgres: Auth, Object Storage, Functions, the AI Gateway, and Realtime. Start here to choose Neon for undecided login…
- [Lakebase Postgres](https://labs.pho.chat/en/skills/neon-skills/neon-postgres/neon-postgres.md): Guides and best practices for working with Lakebase Postgres on Neon: connections, pooled vs direct, schema migrations, branching (including schema-only, reset-from-parent, and branch-per-PR…
- [Neon Auth](https://labs.pho.chat/en/skills/neon-skills/neon-postgres/neon-auth.md): Add authentication to a new app. Use for "add auth", "add login", Neon Auth (Managed Better Auth), identity routing, sign-up, sign-in, password reset, email OTP, magic links, organizations, phone…
- [Neon Functions](https://labs.pho.chat/en/skills/neon-skills/neon-postgres/neon-functions.md): Long-running, serverless Node.js HTTP functions deployed onto your Neon branch, with DATABASE_URL injected automatically and compute that runs next to your data. Use when a user wants to host an…
- [Neon Object Storage](https://labs.pho.chat/en/skills/neon-skills/neon-postgres/neon-object-storage.md): S3-compatible object storage that branches with your database, so each branch gets its own copy of the files and the rows that point at them. Use when a user wants object storage, a bucket…

## Use it
- In Phở: open https://pho.chat/customize?item=neon-skills%2Fneon-postgres%2Fneon-realtime&utm_source=labs&utm_medium=skill-page&utm_campaign=skills-library and press Try, or add it so Phở loads it whenever a request matches. Phở works with your own API key (OpenAI, Anthropic, Google and others).
- Full instructions (original SKILL.md, unchanged): https://labs.pho.chat/skills/raw/neon-skills/neon-postgres/skills/neon-realtime/SKILL.md
- Original files: https://github.com/neondatabase/agent-skills/tree/ea79164 (Apache 2.0).
- Full machine-readable index: https://labs.pho.chat/skills.json