Setting Up Free Website Analytics with Umami
Umami, as an open-source self-hosted web analytics solution, fully allows me to grasp the traffic data of my personal website. Its front-end display is simple and beautiful, providing clarity at a glance, which perfectly fits my needs.
After reviewing the official documentation, I decided to use PlanetScale + Vercel for setup.
Running on PlanetScale, Umami documentation
Running on Vercel, Umami documentation
PlanetScale Part
Register and log in through Github.
Using the free database plan is sufficient.
Create a database named umami-db.
View and obtain DATABASE_URL.
Connect -> Connect with Prisme
Open the PlanetScale Web Console.
Console -> Connect
Copy the statements from schema.mysql.sql and execute (to create the data table).
Vercel Part
After adding environment variables, redeploy.
| Name | Description | Example |
|---|---|---|
| DATABASE_URL | PlanetScale database connection address | mysql://xxx:xxx@xxxxx.cloud/umami-db?sslaccept=strict |
| HASH_SALT | Random custom string (can be anything) | xxxxxxxx |
| SKIP_DB_CHECK | Skip string check during deployment | 1 |
Umami Configuration
Log in using the default user admin and password umami.
Integrate the tracking code into the website.
Enable the sharing feature to share real-time data of the website.
