new-rails-project

• You need to bootstrap a new Rails project with the opinionated stack defined in this skill.
• The project should start with Rails, PostgreSQL, Inertia.js, React, Vite, Tailwind, Sidekiq, and Redis already planned together.
• You want setup guidance that covers project creation, conventions, testing, and verification for a fresh Rails app.

# Tech Stack
Set up the following tech stack:

• Rails ~8 with PostgreSQL - Server-side framework and database
• Inertia.js ~2.3 - Bridges Rails and React for SPA-like experience without API
• React ~19.2 - Frontend UI framework
• Vite ~5 - JavaScript bundler with HMR
• Tailwind CSS ~4 - Utility-first CSS framework
• Sidekiq 8 - Background job processing with scheduled jobs via sidekiq-scheduler
• Redis - Sessions, caching, and job queue

# Rails guidance

• Do not use Kamal or Docker
• Do not use Rails "solid_*" components/systems
• Development should generally match production settings where possible
• Use Redis for caching

# Database

• All tables use UUID primary keys (pgcrypto extension)
• Timestamps use timestamptz for timezone awareness
• JSONB columns for flexible metadata storage
• Comprehensive indexing strategy for performance
• Encrypted fields for sensitive data (OAuth tokens, API keys)