Neon DB Query Builder

Neon is a serverless PostgreSQL platform that separates storage and compute. It features branching (like Git branches for databases), autoscaling to zero when idle, and a serverless HTTP driver (@neondatabase/serverless) that works in edge runtimes like Cloudflare Workers and Vercel Edge Functions where TCP connections aren't available.

It's Neon's JavaScript/TypeScript driver that uses HTTP or WebSockets instead of TCP, making it compatible with serverless and edge runtimes. Use the neon() tagged template literal for simple queries, or neonConfig + Pool for connection pooling in long-running environments.

The neon() tagged template literal automatically parameterizes values for safety. Write: sql`SELECT * FROM users WHERE id = ${userId}` and the driver handles escaping. Never use string concatenation for user input — always use template literal interpolation or the $1, $2 positional parameters.

neon() uses HTTP for each query — best for serverless/edge functions with stateless, short-lived requests. Pool and Client use WebSockets and maintain connections — better for long-running Node.js servers or when you need transactions across multiple queries.

Yes. drizzle-orm/neon-http wraps the @neondatabase/serverless HTTP driver. You get type-safe queries with Drizzle's schema definition and query builder, combined with Neon's serverless/edge compatibility. Use drizzle-orm/neon-serverless for WebSocket-based connections with transaction support.

Neon branches are instant copies of your database (like git branches) created from a shared storage layer — no data copying needed. Create a branch for each PR or feature, test schema changes safely, then merge via SQL migrations. Use the Neon CLI: neonctl branches create --name feature/my-feature