Supabase
Hosting & infrastructureAn open-source backend platform built on Postgres — database, auth, and storage in one.
Supabase is an open-source backend-as-a-service built around PostgreSQL. It bundles the database with authentication, file storage, and auto-generated APIs, and it can be self-hosted or used as a managed service.
Because it is Postgres underneath, pgvector is available — so the application database and the vector store for retrieval can be the same system.
Where it's ideally used
A strong fit for an AI app that needs a database, auth, and vector search together, with the option to self-host.
Where it doesn't fit
Less suited to workloads that have outgrown a single Postgres core or need specialized, separately scaled data stores.