Agent-Skills.md

Agent Skills: Seed Database

Seed the DynamoDB database with sample data for development and testing. Populates galleries, inquiries, and admin tables. Use when setting up local dev environment or resetting test data. WARNING - never run in production.

UncategorizedID: forever-efficient/pitfal-solutions-website/db-seed

Install this agent skill to your local

pnpm dlx add-skill https://github.com/forever-efficient/pitfal-solutions-website/tree/HEAD/.claude/skills/db-seed

Skill Files

Browse the full folder contents for db-seed.

Download Skill

Loading file tree…

.claude/skills/db-seed/SKILL.md

Skill Metadata

Name
db-seed
Description
Seed the DynamoDB database with sample data for development and testing. Populates galleries, inquiries, and admin tables. Use when setting up local dev environment or resetting test data. WARNING - never run in production.

Seed Database

Populate DynamoDB tables with sample data for development/testing.

WARNING

This skill modifies database data. ALWAYS verify the environment before proceeding.

Pre-checks

  1. Verify environment (NEVER run in production!):

    echo "Current AWS Profile: $AWS_PROFILE"
aws sts get-caller-identity --profile pitfal

  2. Confirm with user before proceeding

Seed Commands

Seed All Tables (Recommended Order)

# 1. Seed admin users and settings first
aws dynamodb batch-write-item \
  --request-items file://scripts/seed-admin.json \
  --profile pitfal

# 2. Seed galleries and images
aws dynamodb batch-write-item \
  --request-items file://scripts/seed-galleries.json \
  --profile pitfal

# 3. Seed sample inquiries
aws dynamodb batch-write-item \
  --request-items file://scripts/seed-inquiries.json \
  --profile pitfal

Seed Individual Tables

Admin Users & Settings

aws dynamodb batch-write-item \
  --request-items file://scripts/seed-admin.json \
  --profile pitfal

Galleries & Images

aws dynamodb batch-write-item \
  --request-items file://scripts/seed-galleries.json \
  --profile pitfal

Inquiries

aws dynamodb batch-write-item \
  --request-items file://scripts/seed-inquiries.json \
  --profile pitfal

Verify Seeding

# Count items in galleries table
aws dynamodb scan \
  --table-name pitfal-galleries \
  --select COUNT \
  --profile pitfal

# Count items in inquiries table
aws dynamodb scan \
  --table-name pitfal-inquiries \
  --select COUNT \
  --profile pitfal

# Count items in admin table
aws dynamodb scan \
  --table-name pitfal-admin \
  --select COUNT \
  --profile pitfal

Seed Data Contents

| File | Contents | |------|----------| | seed-admin.json | Admin user, site settings, services, testimonials, FAQs | | seed-galleries.json | Sample galleries (brand, portrait, event) with images | | seed-inquiries.json | Sample booking inquiries in various statuses |

Default Admin Credentials

  • Username: admin
  • Password: admin123 (change immediately in production!)
  • Note: Password hash in seed file is bcrypt with cost factor 12

Clear Data (Development Only)

To remove all seed data:

# This is destructive - confirm before running
aws dynamodb delete-table --table-name pitfal-galleries --profile pitfal
aws dynamodb delete-table --table-name pitfal-inquiries --profile pitfal
aws dynamodb delete-table --table-name pitfal-admin --profile pitfal
# Then re-run terraform apply to recreate tables