Skip to main content

​
The problem

Setting up PostgreSQL infrastructure is slow. You need to provision servers, configure backups, manage scaling, and handle connection pooling. For each environment (dev, staging, production), you repeat the process.

​
The solution

Case.dev Databases gives you serverless PostgreSQL powered by Neon. Create a database project in seconds, get a connection string, and start building. No infrastructure to manage. The killer feature: branching. Create instant, isolated copies of your database for development, staging, or testing. Each branch is a full PostgreSQL instance with its own connection string. 
PROJECT: my-legal-app
├── main (production)
│   └── postgresql://[email protected]/neondb
├── staging (copy of main)
│   └── postgresql://[email protected]/neondb
└── feature-auth (copy of staging)
    └── postgresql://[email protected]/neondb

​
Quick start

import Casedev from 'casedev';
import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

const client = new Casedev({ apiKey: process.env.CASEDEV_API_KEY });

// 1. Create a database project
const project = await client.database.v1.projects.create({
  name: 'case-management-db',
  region: 'aws-us-east-1'
});

console.log(`Created project: ${project.id}`);

// 2. Get the connection string
const conn = await client.database.v1.projects.getConnection(project.id);

// 3. Connect with Drizzle ORM
const sql = postgres(conn.connectionUri);
const db = drizzle(sql);

// Ready to query
const users = await db.select().from(usersTable);

​
Key features

FeatureDescription
ServerlessAutomatic scaling, pay for what you use
BranchingInstant database clones for dev/staging
Connection poolingPgBouncer included, handles thousands of connections
Multi-region8 AWS regions worldwide
PostgreSQL 17Latest version with full feature support
EncryptedData encrypted at rest and in transit

​
Regions

Deploy your database close to your users:
RegionLocation
aws-us-east-1N. Virginia (default)
aws-us-east-2Ohio
aws-us-west-2Oregon
aws-eu-central-1Frankfurt
aws-eu-west-1Ireland
aws-eu-west-2London
aws-ap-southeast-1Singapore
aws-ap-southeast-2Sydney

​
Next steps

Projects

Create and manage database projects

Branches

Isolated environments for dev and staging

Connections

Connection strings and pooling options

Orbit Compute

Deploy applications that connect to your databases

Vaults

Store documents with vector search alongside your database