DB Access

Runtime connections

The API builds runtime database URLs in apps/api/src/config.ts.

It supports:

• explicit POSTGRES_URL and REDIS_URL
• or separate host/user/password/port env variables

Local development

Start local services:

docker compose up -d db redis

Then run:

pnpm dev:api

Drizzle tooling

Useful root commands:

• pnpm db:generate:api
• pnpm db:migrate:api
• pnpm db:studio:api
• pnpm db:push:api
• pnpm db:pull:api

Direct PostgreSQL access

When POSTGRES_URL is set:

psql "$POSTGRES_URL"

When using split env values:

psql "postgres://$POSTGRES_USER:$POSTGRES_PASSWORD@$POSTGRES_HOST:$POSTGRES_PORT/$POSTGRES_DB"

Redis access

If REDIS_URL is set:

redis-cli -u "$REDIS_URL"

If using split env values:

redis-cli -h "$REDIS_HOST" -p "$REDIS_PORT" -a "$REDIS_PASSWORD"

Partitioned tables

The base SQL script creates the partitioned parent tables only.

Files:

• packages/database/src/utils/sql_scripts/create_items.sql
• packages/database/src/utils/sql_scripts/examples/create_items_partitions.example.sql
• packages/database/src/utils/sql_scripts/create_actions_events.sql
• packages/database/src/utils/sql_scripts/examples/create_actions_events_partitions.example.sql

Use the example files only as templates. Real item partitions should be created per network/domain, and real action/event partitions should be created per network/action.