Skill · em Construir backend e dados
neon-postgres
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,…
Procedência
- Origem: neondatabase/agent-skills
- Caminho:
skills/neon-postgres - Versão fixada:
80164a28443aca7c82ac1a70aed836950d6c29ea - Licença: Apache-2.0
- Espelhado em 25/09/2026
- 187,4 mil instalações no skills.sh (lido em 25/09/2026)
Antes de instalar
5 arquivos · 37 KB · só texto, nenhum script
Instalar na sua CLI
O comando baixa a versão fixada (commit 80164a2) direto da origem, para a pasta que a CLI lê. Precisa de curl (macOS e Linux); no Windows não há comando, porque o Rook Labs é para macOS.
Claude Code
Neste projeto: instala em .claude/skills/neon-postgres/.
d=".claude/skills/neon-postgres" u="https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/skills/neon-postgres" curl -fsSL --create-dirs \ -o "$d/SKILL.md" "$u/SKILL.md" \ -o "$d/references/full-text-search.md" "$u/references/full-text-search.md" \ -o "$d/references/hybrid-search.md" "$u/references/hybrid-search.md" \ -o "$d/references/lakebase-search-drizzle.md" "$u/references/lakebase-search-drizzle.md" \ -o "$d/references/vector-search.md" "$u/references/vector-search.md" \ -o "$d/LICENSE" "https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/LICENSE"
Global: instala em ~/.claude/skills/neon-postgres/.
d="$HOME/.claude/skills/neon-postgres" u="https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/skills/neon-postgres" curl -fsSL --create-dirs \ -o "$d/SKILL.md" "$u/SKILL.md" \ -o "$d/references/full-text-search.md" "$u/references/full-text-search.md" \ -o "$d/references/hybrid-search.md" "$u/references/hybrid-search.md" \ -o "$d/references/lakebase-search-drizzle.md" "$u/references/lakebase-search-drizzle.md" \ -o "$d/references/vector-search.md" "$u/references/vector-search.md" \ -o "$d/LICENSE" "https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/LICENSE"
Codex
Neste projeto: instala em .agents/skills/neon-postgres/.
d=".agents/skills/neon-postgres" u="https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/skills/neon-postgres" curl -fsSL --create-dirs \ -o "$d/SKILL.md" "$u/SKILL.md" \ -o "$d/references/full-text-search.md" "$u/references/full-text-search.md" \ -o "$d/references/hybrid-search.md" "$u/references/hybrid-search.md" \ -o "$d/references/lakebase-search-drizzle.md" "$u/references/lakebase-search-drizzle.md" \ -o "$d/references/vector-search.md" "$u/references/vector-search.md" \ -o "$d/LICENSE" "https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/LICENSE"
Global: instala em ~/.agents/skills/neon-postgres/.
d="$HOME/.agents/skills/neon-postgres" u="https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/skills/neon-postgres" curl -fsSL --create-dirs \ -o "$d/SKILL.md" "$u/SKILL.md" \ -o "$d/references/full-text-search.md" "$u/references/full-text-search.md" \ -o "$d/references/hybrid-search.md" "$u/references/hybrid-search.md" \ -o "$d/references/lakebase-search-drizzle.md" "$u/references/lakebase-search-drizzle.md" \ -o "$d/references/vector-search.md" "$u/references/vector-search.md" \ -o "$d/LICENSE" "https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/LICENSE"
Antigravity
Neste projeto: instala em .agents/skills/neon-postgres/.
d=".agents/skills/neon-postgres" u="https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/skills/neon-postgres" curl -fsSL --create-dirs \ -o "$d/SKILL.md" "$u/SKILL.md" \ -o "$d/references/full-text-search.md" "$u/references/full-text-search.md" \ -o "$d/references/hybrid-search.md" "$u/references/hybrid-search.md" \ -o "$d/references/lakebase-search-drizzle.md" "$u/references/lakebase-search-drizzle.md" \ -o "$d/references/vector-search.md" "$u/references/vector-search.md" \ -o "$d/LICENSE" "https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/LICENSE"
Global: instala em ~/.gemini/antigravity-cli/skills/neon-postgres/.
d="$HOME/.gemini/antigravity-cli/skills/neon-postgres" u="https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/skills/neon-postgres" curl -fsSL --create-dirs \ -o "$d/SKILL.md" "$u/SKILL.md" \ -o "$d/references/full-text-search.md" "$u/references/full-text-search.md" \ -o "$d/references/hybrid-search.md" "$u/references/hybrid-search.md" \ -o "$d/references/lakebase-search-drizzle.md" "$u/references/lakebase-search-drizzle.md" \ -o "$d/references/vector-search.md" "$u/references/vector-search.md" \ -o "$d/LICENSE" "https://raw.githubusercontent.com/neondatabase/agent-skills/80164a28443aca7c82ac1a70aed836950d6c29ea/LICENSE"
Peça ao Rook
Já usa o Rook Labs? Cole no chat do Rook: instale a skill https://rooklabs.sh/marketplace/neondatabase.agent-skills.neon-postgres
Prévia do SKILL.md
---
name: neon-postgres
description: >-
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. Also use for
"@neondatabase/serverless", "@neondatabase/neon-js", "neon inspect db",
"semantic search", "vector search", "full-text search", "BM25", or
"hybrid search".
metadata:
parent: neon
source: https://github.com/neondatabase/agent-skills/tree/main/skills/neon-postgres
---
**FIRST**: Use the parent `neon` skill for a Neon overview, getting started with Neon, Neon development best practices, and more.
If the `neon` skill is not installed, fetch it from https://neon.com/docs/ai/skills/neon/SKILL.md or install it with:
```bash
neon skills -s neon -y
```
# 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…
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 `@neondatabase/auth` belong in `neon-auth`.
## Setup Flow
### 1. Select the organization and project
If a `DATABASE_URL` 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.
…