How to vibe codeSeats.aero

Prerequisites

• Node.jsfree

  Runtime for the TypeScript backend ingestion workers and web frontend

• GitHubfree

  Source code control and GitHub Actions for running scheduled ingestion crons

AI coding tools

• Claude Code

  Best-in-class coding agent for scaffolding multi-file database schemas, scraper clients, and API routes

• Cursor

  IDE for iterative UI work on the table views, filters, and dashboard components

Build guide

1. 01Database Schema & Project Setup

   Initialize the Next.js project with Tailwind CSS, configure better-auth, and set up the Neon Postgres database schema for routes, flights, and alerts.

   Initialize a new Next.js project using TypeScript and Tailwind CSS. Configure better-auth with email/password authentication. Connect the app to a Neon serverless Postgres instance using Drizzle ORM. Create the database tables: `routes` (id, origin_airport, destination_airport, airline), `award_flights` (id, route_id, date, cabin_class, mileage_cost, taxes, remaining_seats, updated_at), and `user_alerts` (id, user_id, origin, destination, max_miles, active). Ensure indexes are placed on origin, destination, and date fields for rapid query performance. Write initial migration scripts and test database connectivity.

   ⧉copy promptopen in Claude CodeCopen in Codexopen in Cursor

2. 02Ingestion Worker Pipeline

   Build resilient Node.js background worker scripts to fetch and normalize award space data from sample airline endpoints, inserting or updating records efficiently.

   Build a TypeScript background worker module designed to run on Railway via scheduled cron jobs. Implement an ingestion client that targets mock or sample airline award endpoints (or a target test loyalty program). The worker must parse responses, handle HTTP rate limits and exponential backoff retry logic, and perform batch upsert operations into the `award_flights` table in Neon Postgres without causing database table locks. Include structured error logging with Winston or Sentry.

   ⧉copy promptopen in Claude CodeCopen in Codexopen in Cursor

3. 03Search Interface & Filtering Dashboard

   Develop a high-speed, dense tabular search interface in Next.js optimized for fast data rendering, filtering by route, cabin class, date range, and mileage cost.

   Create a responsive search dashboard page in Next.js styled with Tailwind CSS, mimicking a fast data-dense table view. Implement search input controls for origin airports, destination airports, date pickers, cabin class dropdowns (Economy, Premium Economy, Business, First), and maximum mileage sliders. Build server-side pagination and sorting endpoints that query the `award_flights` table efficiently using the indexes created in Step 1. Ensure sub-second response times for typical query filters.

   ⧉copy promptopen in Claude CodeCopen in Codexopen in Cursor

4. 04Alert Engine & Notifications

   Implement the alert management system that checks incoming ingested flight inventory against user criteria and dispatches email/SMS notifications via Resend and Twilio.

   Build an alert evaluation processor that runs after each successful ingestion batch. The processor must query active records in `user_alerts`, match them against newly discovered or updated `award_flights` entries, and trigger notifications when criteria are met. Integrate the Resend API for sending transactional email alerts and the Twilio API for dispatching SMS notifications. Create a user-facing dashboard page allowing users to view, create, and delete their saved availability alerts.

   ⧉copy promptopen in Claude CodeCopen in Codexopen in Cursor

5. 05Developer JSON API & Pro Tier Access Control

   Add API token authentication endpoints for developer access and gate extended booking window data behind a subscription check.

   Implement a protected JSON API route under `/api/v1/search` that authenticates requests using Bearer tokens stored in a new `api_tokens` table linked to users. Enforce access control so that free tier users are restricted to searching flight dates within a 60-day window from the current date, while Pro users with active subscription status can query up to 360 days in advance. Add mock Stripe webhook handler endpoints to update user subscription status upon successful checkout events.

   ⧉copy promptopen in Claude CodeCopen in Codexopen in Cursor

Cost vs paying for Seats.aero