Neon

Overview

Neon provides managed PostgreSQL. shipkit can use its connection string directly.

Quick start

1) Create project and database

1. Sign up on Neon.
2. Create a project and database in the Neon console.

2) Get the connection string

1. Open Connection Details.
2. Copy the Pooled connection string (recommended for production).

3) Configure environment variables

DATABASE_URL=your_neon_connection_string
DB_PROVIDER=neon

4) Apply schema

pnpm db:push

Or use migrations:

pnpm db:generate
pnpm db:migrate

5) Manage data

Use the Neon console, or run locally:

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

• Neon website
• Neon docs
• Neon console