Database

Database configuration using PostgreSQL and Drizzle ORM in ShipKit

Database

ShipKit uses PostgreSQL as the database and Drizzle ORM for type-safe database operations.

Features

  • Type-safe queries
  • Automatic migrations
  • Schema validation
  • Connection pooling
  • Prepared statements
  • SQL security

Configuration

Add these environment variables to configure your database:

# Required
DATABASE_URL=postgresql://user:password@host:port/database

# Optional - For database naming prefix
DB_PREFIX=your_prefix

Database Setup

  1. Create a PostgreSQL database
  2. Set up the connection URL in your environment
  3. Run migrations: pnpm db:migrate
  4. Generate types: pnpm db:generate

Hosting Options

  • Neon - Serverless Postgres (Recommended)
  • Supabase - Open source Firebase alternative
  • Railway - Infrastructure platform
  • Self-hosted PostgreSQL

Resources