Supabase

Supabase is an open source backend for web and mobile applications, built around Postgres. Every project gets a dedicated Postgres database, and the rest of the platform is a set of services attached to it rather than a layer that hides it.

That decision is the reason to choose it. The database is a real Postgres instance, so SQL, extensions and the wider Postgres ecosystem all work as they normally do, and there is a SQL editor for running queries and mutations directly. REST and GraphQL APIs are generated automatically from the schema, the GraphQL side through a Postgres extension, so an API exists the moment a table does.

Auth handles email and password, phone and one-time codes, magic links for passwordless sign-in, and more than twenty social login providers. Access control is enforced with Postgres row-level security policies, which means the rules about who can read which row live in the database rather than in application code that has to remember to apply them. Authentication flows can be extended with serverless functions.