On this page
Menu
Supabase is a open source Firebase alternative built on the Postgres database.
Edit db/postgresql/schema.prisma to add directUrl = env("DIRECT_DATABASE_URL")
Create a project on Supabase with a given name in a region close to where you will be hosting your Umami project.
Get the database connection string from the Settings > Database page, then scroll to the bottom for the Connection Pooling section and copy the Connection string.
Add DATABASE_URL
and DIRECT_DATABASE_URL
to your .env
file:
DATABASE_URL=postgres://[db-user].[project-ref]:[db-password]@aws-0-[aws-region].pooler.supabase.com:6543/[db-name]?pgbouncer=true&connection_limit=1
DIRECT_DATABASE_URL=postgres://postgres.[my-supabase-project-id]:[db-password]@aws-0-[aws-region].pooler.supabase.com:5432/postgres
You should now be able to build and start Umami (npm run build
followed by npm start
).
Follow the Getting started guide starting from the Login step and be sure to change the default password.