neon-postgres

Installation

Summary

Comprehensive guides and best practices for Neon Serverless Postgres, covering setup, connection methods, authentication, and platform APIs.

Covers getting started, local development setup, connection method selection (TCP, HTTP, WebSocket), and driver installation for any language or framework
Includes Neon-specific features: autoscaling, branching (instant copy-on-write clones), scale-to-zero, instant restore, and read replicas
Provides CLI tooling (neonctl), TypeScript/Python SDKs, and REST API documentation for programmatic resource management and CI/CD automation
Guides on Neon Auth integration, connection pooling for serverless environments, IP allow lists, and logical replication workflows

SKILL.md

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:

npx skills add neondatabase/agent-skills --skill neon

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.

Setup Flow

1. Select the organization and project

Use the CLI (default) or MCP server to list organizations and projects. Let the user select an existing project or create a new one. Check the .neon file for an existing linked project or branch.

Related skills