Local Development with Neon

Setting up your development environment should be simple and fast. With Neon's modern approach to PostgreSQL, you get exactly that. Here's how to create the perfect setup for your applications.

Two ways to develop

When working with Neon, you can choose between:

1. Database branching
2. Local PostgreSQL

Let's explore both options to help you pick the right one.

Database branching

Imagine creating a complete copy of your database as easily as creating a Git branch. That's database branching with Neon – perfect for testing new features or updates without touching production data.

Why use it?

• Fast setup: Create new environments in ~1 second
• Zero cnfiguration: No local PostgreSQL installation required
• True isolation: Test changes without fear of breaking production
• Cost-efficient: Pay only for unique data and actual compute usage
• Team-friendly: Share database branches as easily as sharing Git branches
• Autoscaling: Resources scale to zero when you're not coding
• Data reset: Fresh start? Reset your branch to match production in seconds

Quickstart

1. Install the Neon CLI by following the guide here.

2. Connect your account

   neonctl auth

3. Create your branch

   neonctl branches create --name dev/your-name
   
   # Get your connection details
   neonctl connection-string dev/your-name

   note

   You can also create branches through the Neon Console by navigating to your project and clicking the "Branches" tab. This provides a visual interface for branch management and configuration

4. Set up your environment

   # .env.development
   DATABASE_URL='postgresql://[user]:[password]@[endpoint]/[dbname]'

5. Install dependencies

   Dependencies includes Neon's serverless driver and a WebSockets library.

   npm

   yarn

   pnpm

   npm install @neondatabase/serverless ws

6. Connect your app

   import { Pool, neon, neonConfig } from '@neondatabase/serverless';
   
   // Uncomment the following lines if you are on environments that do not support WebSocket, e.g, Node.js
   // import ws from 'ws';
   // neonConfig.webSocketConstructor = ws;
   
   export const pool = new Pool({ connectionString: process.env.DATABASE_URL });
   export const sql = neon(process.env.DATABASE_URL);

Tips and tricks

• Stay organized: Use prefixes like dev/feature-auth or dev/alice
• Reset data: Start fresh when needed:

  neon branches reset dev/your-name

• Feature work: Create dedicated branches:

  neon branches create --name dev/auth-system --parent main

Local PostgreSQL

Sometimes you need to work offline or want full control over your database. Here's how to set up a local instance that works perfectly with Neon.

Why use it?

• Full control: Your own PostgreSQL instance
• Offline work: Code without internet dependency
• Fast queries: Zero network latency
• Free development: Use your local resources

Setup steps

1. Install Dependencies

   npm

   yarn

   pnpm

   npm install @neondatabase/serverless ws

2. Set up via Docker Compose

   services:
     postgres:
       image: postgres:17
       command: '-d 1'
       volumes:
         - db_data:/var/lib/postgresql/data
       ports:
         - '5432:5432'
       environment:
         - POSTGRES_USER=postgres
         - POSTGRES_PASSWORD=postgres
         - POSTGRES_DB=main
       healthcheck:
       test: ['CMD-SHELL', 'pg_isready -U postgres']
       interval: 10s
       timeout: 5s
       retries: 5
   
     neon-proxy:
       image: ghcr.io/timowilhelm/local-neon-http-proxy:main
       environment:
         - PG_CONNECTION_STRING=postgres://postgres:postgres@postgres:5432/main
       ports:
         - '4444:4444'
       depends_on:
       postgres:
         condition: service_healthy
   
     volumes:
       db_data:

3. Set up your environment

   # .env.development
   DATABASE_URL='postgresql://postgres:postgres@localhost:5432/main'

4. Configure a connection

   import { neon, neonConfig, Pool } from '@neondatabase/serverless';
   import ws from 'ws';
   
   // Configuring Neon for local development
   if (process.env.NODE_ENV === 'development') {
     neonConfig.fetchEndpoint = (host) => {
       const [protocol, port] = host === 'db.localtest.me' ? ['http', 4444] : ['https', 443];
       return `${protocol}://${host}:${port}/sql`;
     };
     neonConfig.wsProxy = (host) => `${host}:4444/v1`;
     neonConfig.useSecureWebSocket = false;
     neonConfig.pipelineTLS = false;
     neonConfig.pipelineConnect = false;
     neonConfig.webSocketConstructor = ws;
   }
   
   const connectionString = process.env.DATABASE_URL;
   
   export const pool = new Pool({ connectionString });
   export const sql = neon(connectionString);

Choosing your development approach

Before choosing between cloud-hosted or local development, it's important to understand the benefits of each approach.

Cloud-hosted branches offer several compelling advantages:

Cost-efficient development

• Minimal storage costs: Branches are extremely cost-effective as you only pay for unique data changes
• Smart compute usage: Development happens on small, autosuspending computes (0.25 vCPU)
• Free Plan benefits: Even the Free Plan includes 5 compute hours on dev branches
  • This translates to 20 hours of development time on a 0.25 vCPU compute
  • One compute hour at 1 vCPU equals four hours at 0.25 vCPU

Developer-friendly features

• Instant deployment: Branches are created in seconds, just like Git branches
• Branch reset: Easily refresh your development data from the parent branch
• Zero maintenance: No need to manage local PostgreSQL installations

When to use each approach

Choose database branching when:

• You want instant development environments
• You need efficient resource utilization
• You're working with a team

Perfect for:

• Most development workflows
• Team environments
• Rapid prototyping
• Feature development
• Testing database changes

Consider local PostgreSQL when:

• Offline development is crucial
• You need zero network latency
• You require complete database control
• You have specific local testing requirements

Best practices for cloud-hosted development with Neon branching

Environment tips

• Keep development and production database branches separate
• Always Use clear branch naming
• Never commit credentials to a version control system

Resource tips

• Use auto-suspend for development branches
• Clean up unused branches
• Reset branches to match production when needed

Security tips

• Use separate development credentials
• Rotate credentials regularly
• Keep production credentials isolated

Start building

You're now ready to create a powerful development environment with Neon. Choose the approach that fits your team best and start building.