Data Seeding

In one line: Idempotent seed scripts provision production essentials in every environment and add realistic demo data in non-prod. prod gets essentials only, pprd is never seeded (it receives anonymised prod data), and dev/test get full demo fixtures.

Seed scripts provision production essentials in every environment and add realistic demo data in non-production environments for development, testing, and stakeholder demos. Seeds are idempotent — running twice produces the same result (upsert, not duplicate insert).

Seeding by Environment

Tab Title
Tab Title
Tab Title
Tab Title

Seeded: Branch, categories, services, settings, membership tiers, customer tags.Purpose: Production bootstrap — real data added by staff.

pprd is never seeded. It receives real (anonymized) data via nightly Neon branch reset from prod. See Git Workflow for the replication process.

Commands

# Seed everything for current environment (reads APP_ENV)
bun run scripts/seed.ts

# Seed specific modules
bun run scripts/seed.ts --only=services,staff,offers

# Reset and reseed (TRUNCATES all data first — dev/test only)
bun run scripts/seed.ts --reset

# Seed production essentials (safe — upserts only, no demo data)
bun run scripts/seed-prod.ts

Safety guard: --reset is blocked on prod — the script checks APP_ENV and exits with an error if you try.

Seed Execution Order

Dependencies matter — FK constraints require specific insertion order:

 branch
 system_setting
 service_category
 service
 spa_membership_tier
 customer_tag
 user (staff)
 user (customers)          ← dev/test only
 customer_tag_assignment
offer + offer_service
booking + booking_service
invoice + invoice_item
spa_membership
loyalty_account + loyalty_transaction
lead + lead_note
notification

Production Essentials

These are seeded in all environments including production.

Branch

The Rayasandra branch is the primary branch. A second branch (Marathahalli) is seeded with status: 'opens_soon' for future expansion.

Service Categories (10)

Category	Type
Haircut & Styling	salon
Hair Colouring / Treatment	salon
Facial & Skincare	salon
Waxing	salon
Manicure & Pedicure	salon
Makeup Services	salon
Hair SPA & Head Therapies	salon
Standard SPA Service	spa
Premium SPA Service	spa
VVIP SPA Service	spa

SPA Services (23)

Three tiers of SPA services, each available in 60-minute and 90-minute durations:

Standard SPA: Swedish Therapy, Thai Therapy, Aroma Therapy
Premium SPA: Lomi Lomi Spa, Balinese Therapy, Deep Tissue Therapy
VVIP SPA: Hot Stone Massage, Kerala Potli Massage, Synchronic Massage, Body Polish Massage, Body Scrub & Cleansing (4 variants)

Salon Services (~40)

Covering all 7 salon categories: haircuts, colouring/treatments, facials, waxing, manicure/pedicure, makeup, and hair spa.

Membership Tiers

Tier	Hours	Price	Validity
Silver	8 hours	₹10,000	90 days
Gold	15 hours	₹15,000	90 days
Platinum	Custom	Custom	90 days

System Settings

Key-value pairs stored in the system_setting table:

Customer Tags

VIP, Frequent Visitor, Inactive 60d+, Bridal, No-Show Risk, SPA Member, Referred

Demo Data (Dev & Test Only)

Demo Staff (8 users — all roles covered)

Name	Role	Designation
Siddharth Fernandes	developer	—
Roshini Verma	owner	—
Kavitha Nair	manager	—
Divya Sharma	receptionist	—
Anjali Reddy	staff	stylist (Senior — Bridal, Keratin)
Priya Menon	staff	stylist
Meera Iyer	staff	therapist (Senior — Deep tissue, Hot stone)
Lakshmi Krishnan	staff	therapist

Demo Customers (15 in dev, 5 in test)

Realistic Indian women’s names — target demographic. All demo emails use @demo.test domain — never accidentally sent real emails. Acquisition source coverage is intentional: organic root, GMB deep-link, in-store QR, and converted Meta ad leads are all represented.

Demo Bookings — All Statuses Represented

Status	Count	Notes
`pending`	2	Awaiting receptionist confirmation
`confirmed`	2	Upcoming appointments
`completed`	3	Past bookings with invoices
`cancelled`	1	Customer-cancelled
`rejected`	1	Staff unavailable
`no_show`	1	Customer didn’t arrive
`completed` (membership)	1	₹0 membership session

Demo Memberships

Active Gold — 5 hours used, 10 hours remaining
Active Silver — almost expired (7 days left), 2 hours remaining
Expired Gold — 6 hours forfeited (for testing expiry UI)

Verify Seed

After seeding, run the verification script to check row counts and FK integrity:

bun run scripts/verify-seed.ts

This checks that all expected tables have the correct row counts and that no FK constraints are violated.

Overview

Product

Features

Engineering

System design

Engineering standards

API reference

Application surface

Platform

Quality & security

Operations

Reference

Data Seeding

Data Seeding

Seeding by Environment

Commands

Seed Execution Order

Production Essentials

Branch

Service Categories (10)

SPA Services (23)

Salon Services (~40)

Membership Tiers

System Settings

Customer Tags

Demo Data (Dev & Test Only)

Demo Staff (8 users — all roles covered)

Demo Customers (15 in dev, 5 in test)

Demo Bookings — All Statuses Represented

Demo Memberships

Verify Seed

​Data Seeding

​Seeding by Environment

​Commands

​Seed Execution Order

​Production Essentials

​Branch

​Service Categories (10)

​SPA Services (23)

​Salon Services (~40)

​Membership Tiers

​System Settings

​Customer Tags

​Demo Data (Dev & Test Only)

​Demo Staff (8 users — all roles covered)

​Demo Customers (15 in dev, 5 in test)

​Demo Bookings — All Statuses Represented

​Demo Memberships

​Verify Seed

Data Seeding

Seeding by Environment

Commands

Seed Execution Order

Production Essentials

Branch

Service Categories (10)

SPA Services (23)

Salon Services (~40)

Membership Tiers

System Settings

Customer Tags

Demo Data (Dev & Test Only)

Demo Staff (8 users — all roles covered)

Demo Customers (15 in dev, 5 in test)

Demo Bookings — All Statuses Represented

Demo Memberships

Verify Seed