mcpField
H
happiness-dashboard

happiness-dashboard

github.com/rebyteai-templateData & databases1750 installsUpdated 19w ago
Repository

About happiness-dashboard

An interactive happiness data dashboard template built with Evidence, where SQL queries in Markdown produce visualizations. It is for project developers building a static site from CSV data, processed with embedded DuckDB.

Key features

  1. 01Write SQL queries in Markdown
  2. 02Create visualizations with Evidence
  3. 03Process data using embedded DuckDB
  4. 04Load current and historical data from CSV
  5. 05Build a static site

Use cases

  1. 01Presenting current-year happiness data
  2. 02Comparing historical happiness records
  3. 03Building a static data dashboard from CSV files

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/rebyteai-template/rebyte-skills --skill happiness-dashboard

After installing, type/happiness-dashboardin Claude Code to confirm it loaded.

Details

From the project README

Happiness Dashboard

An interactive data dashboard using Evidence framework - write SQL queries in markdown to create visualizations.

Tech Stack

  • Framework: Evidence
  • Database: DuckDB (embedded)
  • Frontend: Svelte
  • Package Manager: pnpm
  • Output: build directory
  • Dev Port: 3000

Setup

1. Clone the Template
git clone --depth 1 https://github.com/Eng0AI/happiness-dashboard-template.git .

If the directory is not empty:

git clone --depth 1 https://github.com/Eng0AI/happiness-dashboard-template.git _temp_template
mv _temp_template/* _temp_template/.* . 2>/dev/null || true
rm -rf _temp_template
2. Remove Git History (Optional)
rm -rf .git
git init
3. Install Dependencies
pnpm install
4. Process Data Sources
pnpm run sources

Build

pnpm run build

Generates static site in build/ directory.

Deploy

Vercel (Recommended)
vercel pull --yes -t $VERCEL_TOKEN
vercel build --prod -t $VERCEL_TOKEN
vercel deploy --prebuilt --prod --yes -t $VERCEL_TOKEN

Important: Deploy from project root, not build/ directory.

Netlify
netlify deploy --prod --dir=build

Data Sources

CSV files in sources/happiness_score/:

  • hs2024.csv - Current year happiness data
  • hsArchive.csv - Historical happiness data

Notes

  • Use pnpm (not npm) - .npmrc has shamefully-hoist=true for Evidence compatibility
  • Build locally - Vercel/Netlify build can timeout due to DuckDB compilation (40+ min)
  • Uses CSV files, no database setup needed
  • Never run pnpm run dev in VM environment

Comments

Markdown supported