Happiness Dashboard

Name: Happiness Dashboard
Author: majiayu000

BSecurity

Evidence framework data dashboard with DuckDB. Write SQL in markdown to create visualizations.

666 stars
0 votes
0 copies
1 view
Added February 9, 2026

databashsqlgitdatabasefrontend

Security analysis

B89/100

highPerforms destructive filesystem operations
mediumInstalls packages at runtime which could introduce malicious dependencies

Pro shows the line behind each finding and how to fix it

Scanned February 12, 2026

npx -y skills add majiayu000/claude-skill-registry --skill happiness-dashboard --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Happiness Dashboard?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Happiness Dashboard

[![Security: B — Skills Directory](https://www.skillsdirectory.com/api/skills/majiayu000-happiness-dashboard/badge)](https://www.skillsdirectory.com/skills/majiayu000-happiness-dashboard)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro

SKILL.md

---
name: happiness-dashboard
description: Evidence framework data dashboard with DuckDB. Write SQL in markdown to create visualizations.
---

# 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

```bash
git clone --depth 1 https://github.com/Eng0AI/happiness-dashboard-template.git .
```

If the directory is not empty:

```bash
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)

```bash
rm -rf .git
git init
```

### 3. Install Dependencies

```bash
pnpm install
```

### 4. Process Data Sources

```bash
pnpm run sources
```

## Build

```bash
pnpm run build
```

Generates static site in `build/` directory.

## Deploy

### Vercel (Recommended)

```bash
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

```bash
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