Hey there! We've found the following might help you get unblocked faster:

• 🧵 i am not able to access the database

• 🧵 Unable to Connect to PostgreSQL Database via Prisma (P1001 Error) In R-ECREATE Next JS App

• 🧵 NEED HELP NOW

• 🧵 Issue Connecting to Railway PostgreSQL via Prisma (CLI Works Fine)

If you find the answer from one of these, please let us know by solving the thread!

Hey there!
With prisma, DATABASE_URL refers to an env variable.
On your service (the fullstack-auth-boilerplate) did you set DATABASE_URL to the correct value?
That would be heading over to postgres and copying the DATABASE_URL field.
Your other option is using variable references${{Postgres.DATABASE_URL}}.

I did. I copy and paste from Postgres. Now I set DATABASE_URL to ${{Postgres.DATABASE_URL}} and test again. I got the same error

To verify, are you restarting the fullstack-auth-boilerplateafter setting the new value of DATABASE_URL?

I redeployed. Now trying restart

Well, the same error

Well redeploying is the same so all good there!

So I looked over the repo you provided, https://github.com/liangk/fullstack-auth-boilerplate, and I see you're using a docker compose file.
This part of the docs mentions that not all possible compose features are currently available on Railway https://docs.railway.com/guides/dockerfiles#docker-compose.
At a glance it looks like your services all reference the same volume which could be a cause of the issues.

I tried both {{Postgres.DATABASE_URL}} and {{DATABASE_URL}} and all response as empty string. I changed back to copy and paste the above string then made another PR. Suddenly all working. DB table created. Deploy log shows
Datasource "db": PostgreSQL database "railway", schema "public" at "maglev.proxy.rlwy.net:22488"

All good now. However, I still can't add a column to User table. So bad.
Anyway, thank you very much.