# neon-postgres

> Claude/Codex skill by [@neondatabase](https://omgskills.com/library/neondatabase/index.md) · 108 stars · 311k installs · Updated 2026-10-30

Guides and best practices for working with Lakebase Postgres on Neon: connections, pooled vs direct, schema migrations, branching, autoscaling, scale-to-zero, instant restore, read replicas, IP allow lists, logical replication, and Lakebase Search. Use when the work is an existing DATABASE\_URL, SQL, schema, inspect, or search. New backends, Auth, files, Functions, and LLM calls go to the parent \`neon\` skill. Live queries, reactive UIs, and realtime data go to \`neon-realtime\`. Also use for "@neondatabase/serverless", "@neon/neon-js", "neon inspect db", "semantic search", "vector search", "full-text search", "BM25", or "hybrid search".

## Install

```sh
git clone https://github.com/neondatabase/agent-skills /tmp/agent-skills && ln -s /tmp/agent-skills/skills/neon-postgres ~/.claude/skills/neon-postgres
```

## From README

Lakebase Postgres Lakebase Postgres is the database at the core of Neon. It runs on the lakebase architecture — OLTP built directly on cloud object storage — which decouples storage from compute to offer autoscaling, branching, instant restore, and scale-to-zero. It's fully compatible with Postgres and works with any language, framework, or ORM that supports Postgres. It is the same database whether you reach it through Neon or through Databricks; this skill covers the Neon access path. Login, users, sessions, and @neon/auth belong in neon-auth. Live queries, reactive UIs, and realtime data belong in neon-realtime. Flow Select the organization and project If a DATABASEURL is already supplied (prompt, environment, or repo) or a .neon file points at a project, use it. Do not list organizations or create a second project for schema work. Otherwise use the CLI (default) or MCP server to list organizations and projects. Let the user select an existing project or create a new one.

## Links

- HTML page: https://omgskills.com/library/neondatabase/agent-skills/neon-postgres/
- GitHub: https://github.com/neondatabase/agent-skills
- Author: [@neondatabase](https://omgskills.com/library/neondatabase/index.md)

## More from this repo

- [neon-postgres-egress-optimizer](https://omgskills.com/library/neondatabase/agent-skills/neon-postgres-egress-optimizer/index.md) — Diagnose and fix excessive Postgres egress (network data transfer) in a codebase.
   - [@neondatabase](https://omgskills.com/library/neondatabase/index.md) · 108 stars
- [neon](https://omgskills.com/library/neondatabase/agent-skills/skills/neon/index.md) — Overview of Neon, a complete set of cloud backend primitives around Lakebase Postgres: Auth, Object Storage, Functions,...
   - [@neondatabase](https://omgskills.com/library/neondatabase/index.md) · 105 stars
- [neon-ai-gateway](https://omgskills.com/library/neondatabase/agent-skills/skills/neon-ai-gateway/index.md) — One API and one credential for frontier and open-source LLMs and embedding models, built into your Neon branch and...
   - [@neondatabase](https://omgskills.com/library/neondatabase/index.md) · 105 stars