You must already have an existing database in Postgres for Grafana. Run CREATE DATABASE grafana in psql to make the database. Then, start up an instance of Grafana pointed to the new database. Grafana ...

But we use a custom server where both dev and prod are run from ./app, and so we determine that from environment variables. if the database will be SQLite (default development DB) or PostgreSQL ...

Just like the first option, Beekeeper Studio is a free, open-source, cross-platform, SQL editor and database manager. It supports various databases such as MySQL, SQLite, SQL Server, and PostgreSQL.