Metabase

Co-authored by

Hayden BleaselVercel

Matthew HefferonMetabase

While next-forge doesn't include BI tooling out of the box, you can easily add business intelligence and analytics to your app with Metabase.

Try it locally or in the cloud:

Overview

Metabase is an open-source business intelligence platform. You can use Metabase to ask questions about your data, or embed Metabase in your app to let your customers explore their data on their own.

Installing Metabase

Metabase provides an official Docker image via Docker Hub that can be used for deployments on any system that is running Docker. Here's a one-liner that will start a container running Metabase:

docker run -d --name metabase -p 3000:3000 metabase/metabase

For full installation instructions:

• Docker Documentation
• Jar File Documentation

Database Connection

By default, next-forge uses Neon as its database provider. Metabase works seamlessly with Postgres. To connect, you'll need:

• The hostname of the server where your database lives
• The port the database server uses
• The database name
• The username you use for the database
• The password you use for the database

You can find these details in your DATABASE_URL:

DATABASE_URL="postgresql://[username]:[password]@[hostname]:[port]/[database_name]?sslmode=require"

Then plug your database connection credentials into Metabase:

Metabase supports over 20 databases. For other database options, see Metabase Database Documentation.

Asking Questions and Building Dashboards

Once connected, you can start asking Questions and building Dashboards.