What problem does it solve? Working with Neon serverless Postgres involves platform-specific decisions—pooled versus direct connections, branching workflows, autoscaling, scale-to-zero, and Neon-specific diagnostics—that generic Postgres knowledge does not cover. This Skill provides the operational guidance to set up, connect, migrate, troubleshoot, and extend a Neon database correctly. ## Core Features & Use Cases - Setup and Connection Guidance: Walks through selecting projects, obtaining connection strings, choosing pooled vs direct connections, and picking the right driver (node-postgres, @neondatabase/serverless) for Vercel, Cloudflare, and other runtimes. - Branching, Migrations, and Diagnostics: Covers copy-on-write branches, testing migrations on production-like branches with direct connections, and running read-only diagnostic checks via neon inspect db or the MCP inspect_database tool. - Lakebase Search: Implements semantic vector search with lakebase_vector, full-text BM25 search with lakebase_text, and hybrid search using Reciprocal Rank Fusion. - Use Case: A developer deploying a Next.js app on Vercel needs a Postgres database. Use this Skill to create a Neon project, store the pooled DATABASE_URL, run Drizzle migrations over the direct connection, and later diagnose slow queries with neon inspect db outliers. ## Quick Start Ask the AI to set up a Neon Postgres project, get the connection string into your .env file, and recommend the right driver for your deployment platform.
