🗄️ Free Remote Databases for Learning — Complete Guide
April 2026
📋 Quick Summary
When moving from localhost to a remote database, you replace the entire connection string in your .env file. Your code stays the same—only the environment variable changes. This lets your app stay online even when your computer is off.
🔄 How to Update Your .env File
Before (Local)
DATABASE_URL="postgresql://postgres:pwd@localhost:5432/postgres"
After (Remote - Neon Example)
DATABASE_URL="postgresql://user:password@ep-cool-name-123456.us-east-2.aws.neon.tech/neondb?sslmode=require"
⚠️ Key Points:
- The free tier includes 100 projects, 100 CU-hours/project, 0.5 GB storage per branch, and 5 GB of egress (Neon)
- Restart your server after changing
.env(environment variables load at startup) - Most remote databases require SSL (
?sslmode=requirefor Postgres,?ssl-mode=REQUIREDfor MySQL) - Add
.envto.gitignore— never commit credentials!
1. 🐘 Free PostgreSQL (Best Match for Your Current Setup)
🥇 Neon — ⭐⭐⭐⭐⭐ (Best for pure DB learning)
Website: neon.tech • No credit card required ✅
After being acquired by Databricks in May 2025, the platform announced significant pricing reductions—compute costs dropped 15-25% across all tiers, storage pricing fell from $1.75 to $0.35 per GB-month, and the free plan doubled its compute allowance from 50 to 100 CU-hours per month.
Free Tier (2026):
- 100 projects, 100 CU-hours per project per month, 0.5 GB storage per branch, and 5 GB of egress
- No credit card required, never expires, commercial use allowed
| ✅ Pros | ❌ Cons |
|---|---|
| Database branching (Git-like for schema experiments) | 0.5 GB storage limit per branch |
| Free plan doubled to 100 CU-hours per month | Cold starts ~400-750ms after inactivity |
| 100 free projects | Database-only (no built-in auth/storage) |
| Scale-to-zero (zero cost when idle) | |
| Works with all ORMs (Prisma, Drizzle, TypeORM) |
Connection String:
# Pooled (recommended for serverless/many connections)
DATABASE_URL="postgresql://user:password@ep-xxx-pooler.us-east-2.aws.neon.tech/neondb?sslmode=require"
🥈 Supabase — ⭐⭐⭐⭐ (Best for full-stack learning)
Website: supabase.com • No credit card required ✅
The Supabase free tier in 2026 provides 2 projects, 500 MB database storage, 5 GB database egress, 50,000 monthly active users for authentication, 1 GB file storage, 5 GB storage egress, and 500,000 edge function invocations per month.
Free Tier (2026):
- Free projects pause after one week of inactivity, and you're limited to two active projects
- No credit card required to get started
| ✅ Pros | ❌ Cons |
|---|---|
| Full platform: Auth + Storage + Realtime + Edge Functions | Free projects pause after one week of inactivity |
| 500 MB database storage, 1 GB file storage, 50,000 MAUs | Only 2 free active projects |
| Excellent dashboard & documentation | No backups, no SLAs on free plan |
| Real-time WebSocket subscriptions built-in |
Connection Strings:
# Direct connection (IPv6)
DATABASE_URL="postgresql://postgres:[YOUR-PASSWORD]@db.xxxx.supabase.co:5432/postgres"
# Pooled (recommended for serverless)
DATABASE_URL="postgres://postgres:[YOUR-PASSWORD]@db.xxxx.supabase.co:6543/postgres"
💡 Tip: Free projects are automatically paused after one week of inactivity. When a project is paused, it doesn't count toward your two-project limit, but you'll need to manually unpause it when you want to use it again.
🥉 Aiven PostgreSQL — ⭐⭐⭐⭐
Website: aiven.io • No credit card required ✅
Free tier includes a single node with 1GB RAM, 5GB storage, and 1 CPU.
| ✅ Pros | ❌ Cons |
|---|---|
| Dedicated VM — no noisy neighbors | Connection limit (~20 max) |
| Daily backups + monitoring included | Only 1 free service per account |
| Free plans available at no cost indefinitely, but will be automatically powered off if they aren't actively used | Smaller free tier than Neon/Supabase |
Connection String:
DATABASE_URL="postgresql://avnadmin:password@pg-xxx.aivencloud.com:12345/defaultdb?sslmode=require"
📊 PostgreSQL Quick Comparison
| Feature | 🥇 Neon | 🥈 Supabase | 🥉 Aiven |
|---|---|---|---|
| Rating | ⭐⭐⭐⭐⭐ | ⭐⭐⭐⭐ | ⭐⭐⭐⭐ |
| Free Storage | 0.5 GB/branch | 500 MB | 5 GB |
| Credit Card | ❌ Not needed | ❌ Not needed | ❌ Not needed |
| Projects | 100 | 2 | 1 |
| Inactivity Sleep | Scale-to-zero | Pauses after 7 days | May power down |
| DB Branching | ✅ Best-in-class | ⚠️ Limited | ❌ No |
| Auth/Storage | ❌ DB only | ✅ Full platform | ❌ DB only |
| Best For | Pure DB learning + branching | Full-stack apps | Classic managed DB |
🏆 Recommendation: Use Neon for the cleanest Postgres learning experience with database branching. Use Supabase if you want to learn Auth, Storage, and Realtime in one platform.
2. 🐬 Free MySQL
🥇 Aiven for MySQL — ⭐⭐⭐⭐
Same dedicated VM model as their Postgres. No credit card needed, available at no cost indefinitely.
Connection String:
DATABASE_URL="mysql://username:password@mysql-xxx.aivencloud.com:12345/defaultdb?ssl-mode=REQUIRED"
🥈 TiDB Cloud Serverless — ⭐⭐⭐⭐
MySQL-compatible distributed NewSQL database with generous free quota.
Connection String:
DATABASE_URL="mysql://user:password@gateway01.us-east-1.prod.aws.tidbcloud.com:4000/mydb?ssl-mode=REQUIRED"
⚠️ Note: PlanetScale no longer offers a free tier (removed in 2024).
3. 🪟 Free MS SQL Server
🥇 Azure SQL Database — Free Offer — ⭐⭐⭐⭐
Official Microsoft path for cloud SQL learning. Up to 10 serverless databases with 32 GB storage each.
| ✅ Pros | ❌ Cons |
|---|---|
| Official Microsoft SQL Server-compatible | Requires free Azure/Microsoft account |
| 32 GB storage per database | Azure sign-up typically requires a credit/debit card for verification |
| Up to 10 free databases | 100K vCore seconds/month compute limit |
Connection (for Node.js mssql driver):
DB_SERVER="yourserver.database.windows.net"
DB_PORT=1433
DB_NAME="yourdb"
DB_USER="youruser"
DB_PASSWORD="yourpassword"
DB_ENCRYPT=true
🥈 SQL Server Express (Local Only) — ⭐⭐⭐
100% free, no account needed, but local only—not remote.
4. 🍃 Free MongoDB
🥇 MongoDB Atlas M0 — ⭐⭐⭐⭐⭐
Website: mongodb.com/atlas • No credit card required ✅
MongoDB Atlas M0 is a permanently free shared cluster with 512 MB storage, 100 max connections, and no time limit.
Free Tier (2026):
- Atlas's free tier includes 512 MB of storage, 32MB of sort memory, and up to 100 operations per second. The free tier is a great starting point to learn about MongoDB and explore its capabilities in a fully managed cloud environment
- No credit cards are required to provision a cluster, and you can use it to explore and learn more about MongoDB Atlas
| ✅ Pros | ❌ Cons |
|---|---|
| Free forever, no credit card | Only 1 free cluster per project |
| 512 MB storage, never expires | Shared vCPU/RAM (variable performance) |
| Works with Mongoose & official driver | Can auto-pause after 60 days of zero connections |
| Excellent dashboard, UI metrics & docs | No backups on free tier |
| Available on AWS, GCP, Azure | 100 max connections |
Connection String:
MONGODB_URI="mongodb+srv://username:password@cluster0.xxxxx.mongodb.net/myDatabase?retryWrites=true&w=majority"
5. 🚀 Free Redis
🥇 Upstash Redis — ⭐⭐⭐⭐⭐
Website: upstash.com • No credit card required ✅
Perfect for caching, sessions, rate limiting.
Free Tier (2026):
- 256 MB storage + 500K commands/month
- Pay-per-request (zero cost when idle)
- HTTP/REST API (works in serverless/edge)
Connection (using Upstash SDK):
import { Redis } from '@upstash/redis';
const redis = Redis.fromEnv();
6. 🪶 Free SQLite-Based (Edge/Lightweight)
🥇 Turso — ⭐⭐⭐⭐⭐
Website: turso.tech • No credit card required ✅
The free tier includes 5GB total storage, 100 databases, 100 monthly active databases, and 500 million row reads per month.
Free Tier (2026):
- Turso supports up to 100 databases on the free tier. The Developer plan at $4.99/month unlocks unlimited databases and 9GB storage
- No credit card required
| ✅ Pros | ❌ Cons |
|---|---|
| 100 databases free (500M row reads/month) | SQLite semantics ≠ Postgres |
| 5 GB total storage | Not all Postgres features available |
| Lightning fast, edge-distributed | Different mental model |
| No cold starts—databases stay responsive |
Connection (using libSQL client):
DATABASE_URL="libsql://[your-database-url].turso.io"
TURSO_AUTH_TOKEN="your-auth-token"
7. 🌟 Other Popular Free Options
| Provider | Type | Rating | Free Tier | Best For |
|---|---|---|---|---|
| CockroachDB | Distributed SQL | ⭐⭐⭐⭐ | 50M RUs + 10 GiB storage | High-availability SQL learning |
| Firebase Firestore | NoSQL Document DB | ⭐⭐⭐⭐ | Free Spark plan | Real-time apps, Google ecosystem |
| Cloudflare D1 | SQLite (Edge) | ⭐⭐⭐⭐ | 5M rows read/day, 100k writes/day | Serverless edge apps |
| AWS RDS Free Tier | MySQL / PostgreSQL | ⭐⭐⭐ | 750 hrs/month (12 months only) | AWS ecosystem learning |
🏆 Final Recommendations
| Your Goal | Best Choice ⭐ | Runner-Up |
|---|---|---|
Replace your Postgres localhost | Neon ⭐⭐⭐⭐⭐ | Supabase ⭐⭐⭐⭐ |
| Full-stack (DB + Auth + Storage) | Supabase ⭐⭐⭐⭐ | Firebase ⭐⭐⭐⭐ |
| Learn MySQL | Aiven ⭐⭐⭐⭐ | TiDB Cloud ⭐⭐⭐⭐ |
| Learn MS SQL | Azure SQL Free ⭐⭐⭐⭐ | SQL Server Express ⭐⭐⭐ |
| Learn MongoDB / NoSQL | MongoDB Atlas M0 ⭐⭐⭐⭐⭐ | — |
| Learn Redis / Caching | Upstash ⭐⭐⭐⭐⭐ | — |
| Lightweight / Edge SQLite | Turso ⭐⭐⭐⭐⭐ | Cloudflare D1 ⭐⭐⭐⭐ |
🚀 Quickest Path: Your Exact Next Steps
For your current Postgres setup:
- Sign up at neon.tech or supabase.com (GitHub login is fastest)
- Create a project/database in the dashboard
- Copy the connection string provided
- Update your
.env:
# ❌ BEFORE (local)
DATABASE_URL="postgresql://postgres:pwd@localhost:5432/postgres"
# ✅ AFTER — Option A: Neon (recommended)
DATABASE_URL="postgresql://user:password@ep-xxx-pooler.us-east-2.aws.neon.tech/neondb?sslmode=require"
# ✅ AFTER — Option B: Supabase
DATABASE_URL="postgresql://postgres:YourPassword@db.abcdefghij.supabase.co:6543/postgres"
- Restart your Node/Express server
- Test the connection — your app should now use the remote database!
That's it — zero code changes needed! 🎉
✅ Final Safety Checklist
| Item | Action |
|---|---|
| SSL Mode | Append ?sslmode=require to Postgres URLs (most dashboards do this automatically) |
| IP Whitelisting | If connection fails, allow 0.0.0.0/0 in provider dashboard (learning only—tighten for production) |
.gitignore | Ensure .env is in .gitignore — never commit credentials to GitHub! |
| Connection Pooling | For serverless/many connections, use pooled URL (Neon -pooler, Supabase port 6543) |
| Inactivity (Supabase) | Set up a cron ping every few days to prevent 7-day auto-pause |
| ORM Compatibility | Prisma, Drizzle, TypeORM all accept these DATABASE_URL strings directly |
📝 Star Rating Summary
- ⭐⭐⭐⭐⭐ (5 stars - Best): Neon, MongoDB Atlas, Upstash, Turso
- ⭐⭐⭐⭐ (4 stars - Good): Supabase, Aiven, TiDB Cloud, Azure SQL, CockroachDB, Firebase, Cloudflare D1
- ⭐⭐⭐ (3 stars - Decent): AWS RDS Free Tier, SQL Server Express
🎯 TL;DR
- For your Postgres app: Start with Neon (⭐⭐⭐⭐⭐) for database branching magic, or Supabase (⭐⭐⭐⭐) for full-stack features
- For MongoDB: Atlas M0 (⭐⭐⭐⭐⭐) is the gold standard
- For Redis/Caching: Upstash (⭐⭐⭐⭐⭐) is perfect for serverless
- For Lightweight/Edge: Turso (⭐⭐⭐⭐⭐) is incredibly generous
All recommendations are free forever (no credit card required) and perfect for learning. Just copy the connection string, update .env, restart your server, and you're live! 🚀