---

name: database description: Database management commands and the bin/run utility for executing Ruby scripts against specific event databases. Use when the user needs to query, manipulate, or run scripts against existing databases without starting a Rails server.

Database Management

Standard Database Commands

Copy# Prepare database (creates and runs migrations)
bin/rails db:prepare

# Run migrations
bin/rails db:migrate

# Load seed data
bin/rails db:seed

# Load fixtures (for test data)
bin/rails db:fixtures:load

Running Scripts Against Existing Databases

The bin/run command allows you to execute Ruby scripts against any database in the project.

Basic Usage

Copy# Run a script file against a specific database
bin/run db/2025-boston.sqlite3 path/to/script.rb

# Evaluate Ruby code directly against a database
bin/run db/2025-boston.sqlite3 -e "puts Event.current.name"

# Run against test database (automatically loads fixtures)
bin/run test -e "puts Person.count"

Common Query Examples

Copy# Count heats
bin/run db/2025-boston.sqlite3 -e "Heat.count"

# Get all student names
bin/run db/2025-boston.sqlite3 -e "Person.where(type: 'Student').pluck(:name)"

# List studios with person counts
bin/run db/2025-boston.sqlite3 -e "Studio.all.map { |s| [s.name, s.people.count] }"

How bin/run Works

The script automatically sets up:

• RAILS_APP_DB environment variable from database filename
• RAILS_STORAGE path for Active Storage files
• For test database: runs db:prepare and loads fixtures

This allows you to query and manipulate any event database without starting a full Rails server.