Supabase or plain Postgres on your host: which database for a new SaaS?

Supabase is Postgres plus sign-in, storage and a dashboard. Postgres on your host is one less account. How to choose for a first product.

They are the same database underneath

Supabase is built on Postgres. Whatever you choose, your data sits in Postgres tables and your coding tool writes ordinary SQL. The choice is about what comes around the database, and how many accounts you want to manage.

What plain Postgres on your host gives you

Some hosts, Railway among them, can create a Postgres database inside the same project as your app. The connection string appears as a variable, the app reads it, and you are done.

What Supabase gives you

Supabase wraps Postgres with the things many apps need next.

The cost of the extras

Extras are also things to configure correctly. Row level security is powerful, and a missing rule can expose a table to anyone with your public key. If an AI writes your code, ask it to list every table and the rule that protects it, and test with a second account that should not see the data.

You also add one more account, one more set of keys and one more dashboard to the product.

Questions that decide it

What does not change

Changing later

Because both are Postgres, moving between them is an export and an import. The harder part is sign-in: if users live in Supabase Auth, moving them to another system takes planning. Decide sign-in with more care than you decide the database.

How Shipyard handles the choice

When you pick a stack in Shipyard you choose Postgres on the host or Supabase, and separately whether sign-in is built into the app or handled by Supabase Auth. At launch it creates the database in your own account, stores the connection details as variables on the host, and tells your coding tool in the build prompt which database and sign-in method to write for.

Launch in an hour, not a weekend

Shipyard connects your accounts once, then sets up the domain, hosting, database, email and payments for every new product.

See how it works

Read next

Supabase or plain Postgres on your host: which database for a new SaaS? – Shipyard