Back to Knowledge
Updated Sep 2026

Choosing Your Database

Your app needs a place to remember things. Which database

Database

An organized collection of structured information, or data, typically stored electronically in a computer system.

"Like a giant, super-organized filing cabinet where the app stores all its users, posts, and details."

should you pick? Here's an honest, current (September 2026) comparison, with free tiers checked against each vendor's pricing page, and a decision framework you can actually use.

1The Vibe Stack Pick

Neon Postgres

Vibe Stack

For vibe coding

Vibe Coding

Writing code by describing what you want in natural language and letting AI generate it. You guide the vibe; the AI writes the code.

"Like being an architect instead of a bricklayer. You design; the AI builds."

on Next.js and Vercel, we recommend Neon

Neon

Serverless PostgreSQL. It auto-scales, scales to zero when idle, branches like Git, and has a free tier (as of Sep 2026). You can provision it straight from the Vercel Marketplace. Perfect for vibe coding.

"Like PostgreSQL that wakes up when you need it and sleeps when you don't. Pay for what you use."

. It's plain PostgreSQL

PostgreSQL

A powerful, open-source relational database. Rock-solid, feature-rich, and the choice for serious production apps.

"Like the Toyota Camry of databases. Reliable, well-documented, handles anything you throw at it."

 with branching, scale-to-zero

Scale-to-Zero

A serverless feature where compute resources shut down completely when not in use, and spin up instantly when needed. You only pay for actual usage, not idle time.

"Like a light that automatically turns off when you leave the room and turns on when you enter. No wasted electricity."

, and an official MCP

MCP (Model Context Protocol)

An open standard for connecting AI apps to external tools and data (databases, GitHub, docs, browsers). Servers run locally over stdio or remotely over Streamable HTTP, and remote servers use OAuth 2.1 for sign-in. In Claude Code: `claude mcp add --transport http <name> <url>`.

"Like USB ports for AI. A universal way to plug in new capabilities."

 server, so Claude Code can inspect tables and draft migrations on a dev branch.

AI-Friendly

Official MCP server (use it on dev branches, not production)

Branching

Git-like database copies for previews and risky migrations

Scale-to-Zero

Compute sleeps when idle, so side projects stay cheap

Why it's the Vibe Stack default: It's just Postgres, so everything your AI assistant knows about SQL applies. You can outgrow the free tier without rewriting a single query.

2Getting a Database on Vercel in 2026

Vercel doesn't run its own Postgres or Redis anymore. Old tutorials that say "Vercel Postgres" or "Vercel KV" are out of date: databases now come from partners on the Vercel Marketplace (Neon for Postgres, Upstash for Redis, Supabase, and more). One command installs the integration, connects it to your linked project, and pulls the credentials into .env.local as environment variables

Environment Variable

A secret value stored outside your code, like API keys or passwords. Keeps sensitive info out of your codebase.

"Like a sticky note with the WiFi password — you know it, but you don't write it on the wall."

.

Terminal (inside your linked Vercel project)

# Postgres
vercel install neon

# Redis (caching, rate limiting, sessions)
vercel install upstash

# Postgres + auth + storage bundle
vercel install supabase

# Already installed? Re-sync env vars locally
vercel env pull

Prefer to keep billing with the vendor? Sign up directly (for example at neon.com) and paste the connection string into your Vercel project's env vars yourself. Both routes give you the same database. See the env vars guide for keeping those secrets safe.

3The Contenders

Free tiers as of September 2026. They change often, so click through to each pricing page before you commit.

Neon

Vibe Stack

Serverless Postgres with branching and scale-to-zero

Best For

  • Next.js apps deployed on Vercel
  • Side projects that sit idle a lot
  • Testing schema changes on a branch first
  • AI-assisted workflows (official MCP server)

Key Features

  • • Plain PostgreSQL
  • • Scale-to-zero after 5 min idle
  • • Copy-on-write database branches
  • • Built-in connection pooling
  • • One-command install via Vercel Marketplace

Free tier: 0.5 GB per project, 100 CU-hours per project, up to 100 projects, 10 branches

Paid entry plan (Launch) is usage-based. Current pricing ↗

Supabase

Postgres + Auth + Storage + Realtime in one dashboard

Best For

  • Apps that want auth + DB from one vendor
  • Realtime features (chat, live cursors)
  • File uploads next to your data
  • Fast MVPs with a friendly dashboard

Key Features

  • • PostgreSQL
  • • Built-in auth
  • • File storage
  • • Realtime subscriptions
  • • Row Level Security (RLS)

Free tier: 500 MB DB, 5 GB egress, 1 GB file storage, 50,000 MAU, 2 active projects

Free projects pause after 1 week of inactivity. Current pricing ↗

PlanetScale

Managed Postgres and MySQL (Vitess) for serious production

Best For

  • Production apps with a real budget
  • Teams already running MySQL/Vitess
  • Workloads that will need to scale out
  • Careful, non-blocking schema changes

Key Features

  • • Postgres or MySQL (Vitess)
  • • Branching workflow
  • • Non-blocking schema changes
  • • Horizontal sharding (Vitess)
  • • High-availability options

Free tier: No free tier. Paid plans only (the cheapest is a small non-HA Postgres instance).

Great product, wrong first stop for a weekend project. Current pricing ↗

Turso

Hosted SQLite (libSQL) with lots of small databases

Best For

  • One-database-per-user designs
  • Read-heavy apps
  • Folks who love SQLite
  • Local-first and embedded replicas

Key Features

  • • SQLite-compatible (libSQL)
  • • Many databases per account
  • • Embedded replicas
  • • Works with Drizzle

Free tier: 100 databases, 5 GB storage, 500M rows read and 10M rows written per month

SQLite dialect, not Postgres: some Postgres tutorials won't apply. Current pricing ↗

AWS RDS / Aurora

Managed Postgres and MySQL inside AWS

Best For

  • Infrastructure that already lives on AWS
  • Enterprise compliance requirements
  • VPC-private networking
  • Multi-AZ high availability

Key Features

  • • PostgreSQL, MySQL, MariaDB and more
  • • Automated backups
  • • Multi-AZ deployments
  • • Read replicas
  • • Deep AWS integration

Free tier: Credit-based: new accounts get $100 in credits at signup, plus up to $100 more as you explore (over 6 months)

More knobs, more responsibility. Set a billing alarm on day one. Current pricing ↗

Google Cloud SQL

Managed Postgres, MySQL and SQL Server on GCP

Best For

  • Apps running on Cloud Run
  • Teams already in Google Cloud
  • BigQuery-heavy analytics
  • High availability requirements

Key Features

  • • PostgreSQL, MySQL, SQL Server
  • • Automated backups and replication
  • • Point-in-time recovery
  • • GCP service integration

Free tier: New GCP customers get a $300 credit for 90 days (Free Trial)

Instances bill while running, even at zero traffic. Current pricing ↗

Firebase Firestore

Realtime NoSQL document database from Google

Best For

  • Mobile apps (iOS, Android, Flutter)
  • Realtime sync
  • Offline-first apps
  • Quick MVPs with auth included

Key Features

  • • NoSQL document store
  • • Realtime listeners
  • • Offline support
  • • Firebase Auth
  • • Google Cloud integration

Free tier: Free tier available; check Firebase pricing for current quotas

No joins. Model your data around how screens read it. Current pricing ↗

What about Redis?

Redis is a sidekick, not your main database. Use Upstash

Upstash

Serverless Redis with pay-per-request pricing and a free tier (as of Sep 2026). Great for caching, rate limiting, sessions, and queues, and available straight from the Vercel Marketplace.

"Like Redis that wakes up when you need it. Perfect for serverless apps that can't keep a connection open."

Redis (free tier: 256 MB data, 500K commands/month) for caching, rate limiting, and sessions, and keep your real records in Postgres.

4Decision Framework

Answer these four questions in order. The first yes wins.

  1. 1. Does your company already run on AWS or Google Cloud?

    Yes → use RDS/Aurora or Cloud SQL, where your networking, IAM, and billing already live. Pair it with the AWS or GCP guides.

  2. 2. Is it a mobile-first app that must work offline?

    Yes → Firebase Firestore (or Supabase if you'd rather stay relational). See the iOS setup guide.

  3. 3. Do you want auth, file storage, and realtime from the same vendor as your DB?

    Yes → Supabase. One dashboard, one bill, one SDK. Just remember free projects pause after a quiet week.

  4. 4. Everything else (most Next.js apps)

    → Neon, installed from the Vercel Marketplace, with Drizzle as your ORM and a separate auth library.

Pick PlanetScale when you have paying customers, a budget, and you want managed high availability, or your team already speaks MySQL/Vitess.

Pick Turso when you want many tiny databases (one per user or tenant) or you love SQLite.

Still torn? Pick Postgres. Neon, Supabase, PlanetScale Postgres, RDS, and Cloud SQL all speak it, so switching hosts later is a dump-and-restore, not a rewrite.

5Common Traps

Opening a new connection on every request

Serverless functions scale out to many instances. Each one opening its own Postgres connection can exhaust the limit fast.

Fix: Use your provider's pooled connection string (Neon's has -pooler in the hostname) or an HTTP driver like @neondatabase/serverless.

Assuming the free tier is always awake

Neon scales compute to zero after 5 minutes idle, so the first query after a nap is a little slower. Supabase free projects pause after a week of inactivity.

Fix: Fine for side projects. For a demo day, hit the app once beforehand, or move to a paid plan.

Picking a database because a 2023 tutorial did

Vercel Postgres and Vercel KV aren't Vercel products anymore. Vercel's storage page now lists Blob, Global Config, and Marketplace databases (Neon, Upstash, Supabase, and others).

Fix: If a tutorial imports @vercel/postgres or @vercel/kv, swap in the Neon or Upstash SDK instead.

Picking NoSQL because “schemas are scary”

Most apps are relational: users have orders, orders have items. Without joins you end up re-implementing them badly in code.

Fix: Start with Postgres and an ORM like Drizzle. Your AI assistant writes the schema; you review it.

Using a free database that expires

Some hosts' free Postgres is temporary. Render's free Postgres, for example, expires 30 days after creation.

Fix: Read the fine print before you put real user data anywhere.

6Quick Start Resources

Neon Playbook →

Branching, pooling, MCP, and Neon + Drizzle setup

Connect a Database →

Step-by-step: env vars, driver, first query

Design Your Schema →

Tables, relationships, and migrations

Vercel Storage Docs ↗

Marketplace databases, Blob, Global Config

Supabase Docs ↗

Official Supabase documentation

Firestore Docs ↗

Official Firestore documentation

Ready to choose?

Start with the Vibe Stack pick, then wire it up and design your first tables.

Start with NeonConnect a Database