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
