Catalog
neondatabase/neon-postgres

neondatabase

neon-postgres

Guides and best practices for working with Neon Serverless Postgres. Covers getting started, local development with Neon, choosing a connection method, Neon features, authentication (@neondatabase/auth), PostgREST-style data API (@neondatabase/neon-js), Neon CLI, and Neon's Platform API/SDKs. Use for any Neon-related questions.

global
0installs0uses~1.8k
v1.1Saved Apr 20, 2026

Neon Serverless Postgres

Neon is a serverless Postgres platform that separates compute and storage 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.

Neon Documentation

The Neon documentation is the source of truth for all Neon-related information. Always verify claims against the official docs before responding. Neon features and APIs evolve, so prefer fetching current docs over relying on training data.

Fetching Docs as Markdown

Any Neon doc page can be fetched as markdown in two ways:

  1. Append .md to the URL (simplest): https://neon.com/docs/introduction/branching.md
  2. Request text/markdown on the standard URL: curl -H "Accept: text/markdown" https://neon.com/docs/introduction/branching

Both return the same markdown content. Use whichever method your tools support.

Finding the Right Page

The docs index lists every available page with its URL and a short description:

https://neon.com/docs/llms.txt

Common doc URLs are organized in the topic links below. If you need a page not listed here, search the docs index: https://neon.com/docs/llms.txt — don't guess URLs.

What Is Neon

Use this for architecture explanations and terminology (organizations, projects, branches, endpoints) before giving implementation advice.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/what-is-neon.md

Getting Started

Use this for first-time setup: org/project selection, connection strings, driver installation, optional auth, and initial schema setup.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/getting-started.md

Connection Methods & Drivers

Use this when you need to pick the correct transport and driver based on runtime constraints (TCP, HTTP, WebSocket, edge, serverless, long-running).

Link: https://neon.com/docs/ai/skills/neon-postgres/references/connection-methods.md

Serverless Driver

Use this for @neondatabase/serverless patterns, including HTTP queries, WebSocket transactions, and runtime-specific optimizations.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/neon-serverless.md

Neon JS SDK

Use this for combined Neon Auth + Data API workflows with PostgREST-style querying and typed client setup.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/neon-js.md

Developer Tools

Use this for local development enablement with npx neonctl@latest init, VSCode extension setup, and Neon MCP server configuration.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/devtools.md

Neon CLI

Use this for terminal-first workflows, scripts, and CI/CD automation with neonctl.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/neon-cli.md

Neon Admin API

The Neon Admin API can be used to manage Neon resources programmatically. It is used behind the scenes by the Neon CLI and MCP server, but can also be used directly for more complex automation workflows or when embedding Neon in other applications.

Neon REST API

Use this for direct HTTP automation, endpoint-level control, API key auth, rate-limit handling, and operation polling.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/neon-rest-api.md

Neon TypeScript SDK

Use this when implementing typed programmatic control of Neon resources in TypeScript via @neondatabase/api-client.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/neon-typescript-sdk.md

Neon Python SDK

Use this when implementing programmatic Neon management in Python with the neon-api package.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/neon-python-sdk.md

Neon Auth

Use this for managed user authentication setup, UI components, auth methods, and Neon Auth integration pitfalls in Next.js and React apps.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/neon-auth.md

Neon Auth is also embedded in the Neon JS SDK - so depending on your use case, you may want to use the Neon JS SDK instead of Neon Auth. See https://neon.com/docs/ai/skills/neon-postgres/references/connection-methods.md for more details.

Branching

Use this when the user is planning isolated environments, schema migration testing, preview deployments, or branch lifecycle automation.

Key points:

  • Branches are instant, copy-on-write clones (no full data copy).
  • Each branch has its own compute endpoint.
  • Use the neonctl CLI or MCP server to create, inspect, and compare branches.

Link: https://neon.com/docs/ai/skills/neon-postgres/references/branching.md

Autoscaling

Use this when the user needs compute to scale automatically with workload and wants guidance on CU sizing and runtime behavior.

Link: https://neon.com/docs/introduction/autoscaling.md

Scale to Zero

Use this when optimizing idle costs and discussing suspend/resume behavior, including cold-start trade-offs.

Key points:

  • Idle computes suspend automatically (default 5 minutes, configurable) (unless disabled - launch & scale plan only)
  • First query after suspend typically has a cold-start penalty (around hundreds of ms)
  • Storage remains active while compute is suspended.

Link: https://neon.com/docs/introduction/scale-to-zero.md

Instant Restore

Use this when the user needs point-in-time recovery or wants to restore data state without traditional backup restore workflows.

Key points:

  • Restore windows depend on plan limits.
  • Users can create branches from historical points-in-time.
  • Time Travel queries can be used for historical inspection workflows.

Link: https://neon.com/docs/introduction/branch-restore.md

Read Replicas

Use this for read-heavy workloads where the user needs dedicated read-only compute without duplicating storage.

Key points:

  • Replicas are read-only compute endpoints sharing the same storage.
  • Creation is fast and scaling is independent from primary compute.
  • Typical use cases: analytics, reporting, and read-heavy APIs.

Link: https://neon.com/docs/introduction/read-replicas.md

Connection Pooling

Use this when the user is in serverless or high-concurrency environments and needs safe, scalable Postgres connection management.

Key points:

  • Neon pooling uses PgBouncer.
  • Add -pooler to endpoint hostnames to use pooled connections.
  • Pooling is especially important in serverless runtimes with bursty concurrency.

Link: https://neon.com/docs/connect/connection-pooling.md

IP Allow Lists

Use this when the user needs to restrict database access by trusted networks, IPs, or CIDR ranges.

Link: https://neon.com/docs/introduction/ip-allow.md

Logical Replication

Use this when integrating CDC pipelines, external Postgres sync, or replication-based data movement.

Key points:

  • Neon supports native logical replication workflows.
  • Useful for replicating to/from external Postgres systems.

Link: https://neon.com/docs/guides/logical-replication-guide.md

Files1
1 files · 11.1 KB

Select a file to preview

Overall Score

87/100

Grade

A

Excellent

Safety

88

Quality

88

Clarity

87

Completeness

84

Summary

A comprehensive reference skill for Neon Serverless Postgres that guides agents on architecture, connection methods, developer tools, authentication, and platform APIs. The skill provides structured links to detailed documentation pages, enabling agents to fetch current Neon docs as markdown and answer user questions with authoritative, up-to-date information.

Detected Capabilities

fetch and parse Neon documentation as markdownsearch Neon docs index for specific reference pagesguide Neon architecture and terminology explanationsrecommend connection methods based on runtime constraintsimplement Neon Auth and authentication flowsuse Neon CLI for terminal-first workflows and CI/CD automationmanage Neon resources programmatically via REST API or SDKsdesign and implement database branching strategiesconfigure autoscaling, pooling, and read replicasadvise on performance optimization and cost control

Trigger Keywords

Phrases that MCP clients use to match this skill to user intent.

neon postgres setupserverless databaseneon branchingneon authenticationdatabase connection poolingneon cli automationneon api managementread replicas

Risk Signals

INFO

Instructs agent to fetch documentation from external domain (neon.com)

Multiple sections, e.g., 'Fetching Docs as Markdown'
INFO

References API keys and authentication tokens for Neon Admin API

Section: 'Neon Admin API' and subsections
INFO

Guides use of SDK packages that may handle credentials (@neondatabase/api-client, neon-api)

Sections: 'Neon TypeScript SDK', 'Neon Python SDK'

Referenced Domains

External domains referenced in skill content, detected by static analysis.

neon.com

Use Cases

  • Answer questions about Neon Serverless Postgres features and architecture
  • Guide users through initial Neon setup and project configuration
  • Help choose appropriate connection methods for different runtime environments
  • Implement authentication flows using Neon Auth or Neon JS SDK
  • Automate Neon resource management via REST API, TypeScript SDK, or Python SDK
  • Set up local development workflows with Neon CLI and developer tools
  • Design branching strategies for preview deployments and schema migration testing
  • Optimize database performance with autoscaling, pooling, and read replicas
  • Implement point-in-time recovery and disaster recovery workflows

Quality Notes

  • Excellent documentation structure with clear section hierarchy and logical grouping by capability (tools, APIs, features)
  • Strong emphasis on fetching current docs from authoritative source (neon.com) rather than relying on stale training data — best practice for rapidly evolving platforms
  • Comprehensive coverage of Neon's major features (branching, autoscaling, read replicas, pooling) with actionable key points
  • Well-documented reference links for each major topic; agents can immediately fetch detailed guidance
  • Strong emphasis on context-aware tool selection (e.g., choosing connection methods based on runtime constraints)
  • Includes key points and trade-offs (e.g., cold-start penalties for scale-to-zero, branch restore window limits) that help agents give realistic advice
  • Clear guidance on when to use CLI vs REST API vs SDK approaches
  • Minor: 'Finding the Right Page' section assumes agents can parse llms.txt index — could include a brief example of index format
  • Minor: No explicit error handling guidance for API rate limits or transient failures when fetching docs or using Admin API
Model: claude-haiku-4-5-20251001Analyzed: Apr 20, 2026

Reviews

Add this skill to your library to leave a review.

No reviews yet

Be the first to share your experience.

Version History

v1.1

Content updated

2026-04-20

Latest
v1.0

Seeded from github.com/neondatabase/agent-skills

2026-03-16

Add neondatabase/neon-postgres to your library

Command Palette

Search for a command to run...