NeonDB Serverless - PostgreSQL for Modern Apps

When to use this skill

• Setting up serverless Postgres databases
• Implementing database branching for previews
• Configuring connection pooling for serverless
• Optimizing database for cold starts
• Using Prisma or Drizzle ORM with Neon
• Implementing automated database migrations
• Scaling databases without manual intervention
• Building Next.js apps with Postgres on Vercel
• Creating preview databases per Git branch
• Implementing instant database rollbacks
• Using Postgres in serverless functions
• Optimizing connection management for edge functions

When to use this skill

• Using NeonDB serverless PostgreSQL, implementing connection pooling, or building edge-compatible database apps.
• When working on related tasks or features
• During development that requires this expertise

Use when: Using NeonDB serverless PostgreSQL, implementing connection pooling, or building edge-compatible database apps.

Key Patterns

Connection Pooling (Critical!)

```typescript import { Pool } from '@neondatabase/serverless';

const pool = new Pool({ connectionString: process.env.DATABASE_URL });

export async function query(text: string, params: any[]) { const client = await pool.connect(); try { return await client.query(text, params); } finally { client.release(); } } ```

Edge Runtime Compatible

```typescript import { neon } from '@neondatabase/serverless';

const sql = neon(process.env.DATABASE_URL!);

export const runtime = 'edge';

export async function GET() { const users = await sqlSELECT * FROM users; return Response.json(users); } ```

Resources

• NeonDB Docs