Set Up Database

ColdConvert requires a PostgreSQL database to store your leads and campaign data. Choose between Vercel Postgres or Neon.

Set Up Vercel Postgres →Next: Configure Email

Overview

ColdConvert stores all your data in a PostgreSQL database, including leads, campaigns, email templates, and analytics. Both Vercel Postgres and Neon offer generous free tiers perfect for getting started.

Why PostgreSQL?
PostgreSQL is the most reliable and feature-rich database for storing structured data like leads and campaigns. It's also fully supported by Prisma, which ColdConvert uses for database operations.

Option 1: Vercel Postgres (Recommended)

Vercel Postgres seamlessly integrates with your Vercel deployment and offers the easiest setup experience.

🚀 Vercel Postgres Benefits

Free Tier Includes:

  • • 60 hours compute per month
  • • 256MB storage
  • • Automatic backups
  • • Easy environment variable setup

Perfect For:

  • • Getting started quickly
  • • Small to medium campaigns
  • • Seamless Vercel integration
  • • Automatic scaling
1.Go to vercel.com/storage/postgres
2.Sign in with your Vercel account (or create one)
3.Click "Create Database"
4.Choose a name for your database (e.g., "coldconvert-db")
5.Select a region close to your target audience
6.Click "Create" to set up your database
Vercel Postgres Created!
Once created, Vercel will automatically handle the connection string and environment variables for you.

Option 2: Neon Database

Neon is a serverless PostgreSQL service with excellent performance and branching capabilities.

⚡ Neon Benefits

Free Tier Includes:

  • • 3GB storage
  • • Branching support
  • • Auto-scaling
  • • Point-in-time recovery

Perfect For:

  • • Development and testing
  • • Larger datasets
  • • Advanced features
  • • Cost optimization
1.Go to neon.tech and sign up
2.Create a new project
3.Choose a project name (e.g., "coldconvert")
4.Select a region close to your target audience
5.Click "Create Project"
6.Go to Dashboard > Connection Details
Neon Setup Complete!
Neon will provide you with connection details that you'll need to configure manually in Vercel.

Get Your Connection String

For Vercel Postgres:

1. Go to your Vercel dashboard

2. Navigate to Storage > Postgres

3. Click on your database

4. Copy the connection string

5. Save it for the environment variables tutorial

For Neon:

1. Go to your Neon dashboard

2. Click on your project

3. Go to Connection Details

4. Copy the connection string

5. Save it for the environment variables tutorial

Connection String Format
# Vercel Postgres format:
postgresql://username:password@host:port/database

# Neon format:
postgresql://username:password@host/database?sslmode=require

# Save this connection string - you'll need it in the next tutorial
Keep Your Connection String Secure
Your database connection string contains sensitive information. Never share it publicly or commit it to version control.

Next Tutorial

Configure Email Service

Now that you have your database set up, let's configure Resend to handle email delivery for your campaigns.

Continue to Email Setup →View All Tutorials

On this page