PostgreSQL

Local PostgreSQL via the official Docker image (tag 18) plus a DATABASE_URL that matches Prisma's documented postgresql:// form. Pair with the existing prisma component for the ORM.

Copy the files below, or open this folder on GitHub. Each file is stamped with a limited-use licence, generator and date. SHA-256 is of the published catalog bytes, before the stamp.

id: postgres
stack: Next.js
version: 1.0.0
compatibility: nextjs >=16 <17 · react >=19 <20
requires: nextjs-base
env vars: DATABASE_URL, POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB

Verified passing · daily buildIntegrity sha256:754f92e815e73f9d…

Files (2)

docker-compose.yml · sha256:754f92e815e73f9d…

// Licensed by BotKelp — https://www.botkelp.com

# Official image: https://hub.docker.com/_/postgres
# Verified 2026-09-06 — Hub lists 18 / 18.6 as current stable, port 5432,
# env POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB.
# Compose shape follows the Hub example (services.db.image + environment).
# Pair DATABASE_URL with Prisma:
# https://www.prisma.io/docs/prisma-orm/quickstart/postgresql

services:
  db:
    image: postgres:18
    restart: always
    shm_size: 128mb
    ports:
      - "5432:5432"
    environment:
      POSTGRES_USER: <%= projectName.replace(/[^a-zA-Z0-9]/g, '') || 'app' %>
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: <%= projectName.replace(/[^a-zA-Z0-9]/g, '') || 'app' %>
    volumes:
      - pgdata:/var/lib/postgresql/data

volumes:
  pgdata: