neon-postgres

SKILL.md

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

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.