PostgreSQL

Overview

shipkit supports standard PostgreSQL (self-hosted or any cloud provider).

Quick start

1) Prepare a database

1. Provision a PostgreSQL instance.
2. Create a database and a user with read/write access.
3. Ensure your deployment can reach the host.

2) Configure environment variables

DATABASE_URL=postgresql://user:password@host:5432/database
DB_PROVIDER=postgres

3) Apply schema

pnpm db:push

Or use migrations:

pnpm db:generate
pnpm db:migrate

4) Manage data

Use any PostgreSQL client (psql/DBeaver), or run:

pnpm db:studio

Customize

Modify schema

Schema lives in src/lib/db/schema.ts. After changes, run migrations again.

Adjust connection logic

Connection logic is in src/lib/db/index.ts. Update it if you need custom pool settings.

References

• PostgreSQL website
• PostgreSQL docs