Neon PostgreSQL in InferenceX

Use this skill for database work in this repository. InferenceX runs on Vercel and uses Neon as PostgreSQL; do not introduce Neon Auth, Object Storage, Functions, AI Gateway, an ORM, or new infrastructure unless the user asks.

Start with the repository

Read the relevant local documentation before changing code:

• docs/index.md
• docs/architecture.md for the API and cache boundaries
• docs/data-pipeline.md for ingestion and schema flow
• docs/collectivex.md for the separate CollectiveX database

Existing database code lives in packages/db/. Reuse its connection helpers, tagged SQL patterns, migrations, and scripts instead of creating a parallel client or configuration layer.

Connections and credentials

• Main read path: DATABASE_READONLY_URL
• Main administrative writes: DATABASE_WRITE_URL
• CollectiveX read path: DATABASE_COLLECTIVEX_READONLY_URL
• CollectiveX writes and migrations: DATABASE_COLLECTIVEX_WRITE_URL

Keep credentials in environment variables. Never print, commit, copy into source, or expose connection strings in logs or responses. Use the read-only connection for diagnostics and normal reads; use a write connection only when the requested task authorizes mutation.

The application uses @neondatabase/serverless for serverless reads and postgres for administrative or transaction-heavy scripts. Preserve that split unless runtime requirements clearly demand a change.

Schema and query changes

1. Inspect the current migration and query code before proposing a schema change.
2. Add an append-only migration; never rewrite a migration that may have already run.
3. Keep raw database rows in API responses unless a documented route is an explicit exception.
4. Make multi-step writes atomic and safe under concurrent Vercel requests.
5. Verify indexes and bounded query behavior for new filters or ordering.
6. Add focused query/migration tests and run the repository checks.

Useful commands:

bun run admin:db:migrate
bun run admin:db:migrate:collectivex
bun run admin:db:verify
bun run typecheck
bun run test:unit

Do not run migrations, destructive SQL, or production writes during a review or diagnostic request. For authorized schema work, prefer an isolated Neon branch and confirm the target before applying changes.

Current Neon documentation

Neon changes over time. For platform-specific behavior, verify against the official documentation index rather than relying on this compact skill:

• https://neon.com/docs/llms.txt
• https://neon.com/docs/connect/choose-connection
• https://neon.com/docs/serverless/serverless-driver
• https://neon.com/docs/introduction/branching