Add PostgreSQL to your Next.js app

Create a PostgreSQL database for this Next.js app on Rowsafe Cloud and connect it with DATABASE_URL in .env.

Your agent picks a size, tells you the price and waits for your yes. Then it creates the server as you and, once it's ready (5 to 10 minutes), puts DATABASE_URL in .env. Through the Claude Code or Codex plugin, you create the login in the dashboard instead and paste it in: the password is made in your browser.

First time? Connect Rowsafe to your agent once.

rowsafe cloud create shop-db --wait
rowsafe env --on shop-db

rowsafe cloud create shows the price and asks first. rowsafe env makes the password on your computer, writes DATABASE_URL to .env and adds .env to .gitignore. Rowsafe never sees it.

import { Pool } from "pg";

// One pool, kept across hot reloads in development.
const g = globalThis as unknown as { pool?: Pool };
export const db = (g.pool ??= new Pool({ connectionString: process.env.DATABASE_URL }));

import { db } from "@/lib/db";

export default async function Page() {
  const { rows } = await db.query("SELECT id, title FROM posts ORDER BY id DESC LIMIT 10");
  return <ul>{rows.map((p) => <li key={p.id}>{p.title}</li>)}</ul>;
}

npm install pg @types/pg. In .env, change sslmode=require to sslmode=verify-full: the server's certificate is then checked too. Next.js loads .env by itself. Use the pool in server code only. Prisma and Drizzle take the same DATABASE_URL.

Rowsafe backs up every change, encrypted on the server with a key only you have, so you can restore to any second. Every week it restores a backup to prove it works. Restore a copy, bring back deleted rows or rewind the whole database, in one click. Before a risky change, save a Mark (rowsafe mark), or let your agent save one.

From $0.014 an hour, never more than $10 a month.