I Generated 41,000 Static Pages with Astro + AI in a Week — Here's the Architecture

Last month I shipped a programmatic SEO site that generates software comparison pages at scale. The site is called ShowdownHQ and it currently serves tens of thousands of "X vs Y for [audience]" comparison pages across note-taking tools, CRM platforms, project management software, and accounting tools. This is a technical breakdown of how the pipeline actually works. The Architecture The system has four components that run in sequence: Python (generate topics) → Python + LLM API (generate content) → Astro SSG (build static HTML) → Vercel (deploy) No database. No server-side rendering at request time. Everything is static HTML built at deploy time. Component 1: Topic Generation A Python script ( generate_topics.py ) reads two CSV files — a list of software tools and a list of buyer audiences — and outputs every valid combination as rows in a new CSV. import csv import itertools tools = [( " notion " , " Notion " ), ( " obsidian " , " Obsidian " ), ( " craft " , " Craft " ), ...] audienc