neon-postgres

What problem does it solve?

Neon PostgreSQL serverless deployments can be complex to configure, scale, and integrate across modern app stacks. This Skill provides a guided approach to setting up Neon with serverless drivers, connection pooling, branching, and autoscaling to support scalable applications.

Core Features & Use Cases

• Serverless Driver: Use the Neon serverless client to execute HTTP-based queries efficiently from edge and serverless environments.
• Connection Pooling & Branching: Leverage HTTP-based pooling for transactional workloads and Neon branching to create isolated development environments without impacting main environments.
• Migrations & ORM Integration: Integrate with ORMs (e.g., Drizzle) and manage migrations with Neon workflows for safe schema changes.
• Best Practices & Performance: Guidance on choosing HTTP vs WebSocket pooling, and configuring connection strings for development, staging, and production.

Quick Start

1. Install the serverless driver: npm install @neondatabase/serverless
2. Set up your Neon project and obtain a connection string: Go to Neon console and copy your DATABASE_URL
3. Configure your environment: Set DATABASE_URL in your environment, then initialize sql: import { neon } from "@neondatabase/serverless"; const sql = neon(process.env.DATABASE_URL!);
4. Run queries: const users = await sqlSELECT * FROM users;