DEV Community

Alex Spinov
Alex Spinov

Posted on

Neon Has a Free API — Serverless Postgres with Branching and Autoscaling

#postgres #database #serverless #webdev

What if Postgres scaled to zero when idle, branched like git, and cost nothing until you needed it?

Neon is serverless Postgres. It separates storage and compute, so your database scales automatically.

Why Neon

  • Scale to zero — no charges when your app is idle
  • Database branching — create a full copy of your database in seconds for testing
  • Autoscaling — compute scales up with load, scales down when quiet
  • Standard Postgres — works with any Postgres client, ORM, or tool
  • Free tier — 0.5 GB storage, always-available compute

Quick Start 

# Connect with any Postgres client
psql "postgres://user:pass@ep-cool-name-123456.us-east-2.aws.neon.tech/neondb"
Enter fullscreen mode Exit fullscreen mode 
// Or use in your app with any ORM
import { neon } from "@neondatabase/serverless";

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

const posts = await sql`SELECT * FROM posts WHERE published = true ORDER BY created_at DESC LIMIT 10`;
Enter fullscreen mode Exit fullscreen mode

Database Branching 

# Create a branch for your feature
neonctl branches create --name feature/new-schema

# Run migrations against the branch (not production!)
psql $BRANCH_URL -f migration.sql

# Test, verify, then merge schema changes to main
Enter fullscreen mode Exit fullscreen mode

Each branch is a copy-on-write clone — it takes seconds and uses almost no extra storage.

Serverless Driver 

import { neon } from "@neondatabase/serverless";

// Works in Vercel Edge Functions, Cloudflare Workers, Deno
// No persistent connections needed — HTTP-based queries
const sql = neon(process.env.DATABASE_URL);
const result = await sql`SELECT now()`;
Enter fullscreen mode Exit fullscreen mode

Real Use Case

A SaaS team ran RDS Postgres 24/7 for $200/month. Their staging database cost another $100/month. After migrating to Neon: production scaled to zero overnight (saving 40% compute), staging used a Neon branch (free). Monthly DB costs dropped from $300 to $45.

When to Use Neon

  • Serverless/edge applications (Vercel, Cloudflare)
  • Development workflows needing database branching
  • Cost-sensitive projects with variable traffic
  • Any project that needs Postgres without ops

Get Started

Visit neon.tech — free tier, no credit card, Postgres in 30 seconds.

Need custom data pipelines or scraping solutions? Check out my Apify actors or email me at spinov001@gmail.com for custom solutions.

Top comments (0)