I was on the "free" plan, just upgraded to Pro for that reason.

The only thing I really did was switch from HTTP connection to TCP, and when I redeployed, the data was gone, structure intact. It was test data anyways, but im trying to learn from my mistake so when make this prod ready, I dont make the same mistake.

This might be stupid but by any chance are you using a different database name? Migrations might have applied and it would look as though the data is missing

using the Railway CLI if you copy ssh command and enter it in your terminal you can list all databases with psql -l (iirc).

thanks for yoru help; this is what I see:

Wonderful, and in your connection string are you connecting to postgres or railway. Unsure what template0 and template1 are

the db_url end in /railway….let me try postgres

Yeah unsure if you connected to a different database in the main instance. It might not be the case and something might have gone wrong but it happens sometimes so worth checking.

Cool, I honestly think when I was messing with domainurl and domainpubluc_url I created a mess that I am trying to untangle

Well if that's the case and you havent made a manual backup or used the railway specific backup feature there is sadly nothing we can do to restore that data.
I wish I had a better answer but that is unfortunately the way it is.

I do not