UPchieve/server ? reverse-engineered prompt

Build me the backend for UPchieve, including the API server and the queue worker.

It should handle the app’s main endpoints, talk to the database, and serve the frontend build when it’s available, but keep in mind the frontend lives in a separate repo. I want the server to run locally with Docker, connect to Redis and PostgreSQL, and support the worker process for background jobs and recurring jobs. Please make sure the app can be started in dev mode, and that it plays nicely with Socket.IO for realtime features.

If anything is unclear, check the current docs online or look through the repo before filling in the gaps. I’d also like the setup to be easy to run with pnpm, with sensible defaults for local development and clear error handling when required services aren’t available.