Infrastructure

platform infrastructure deployment railway vercel cloudflare neon

Shared deployment infrastructure across all SpotCircuit apps.

Deployment Matrix

AppFrontendBackendDatabaseGenerated Sites
SpotCircuit WebsiteVercel---
Site BuilderVercelRailway-Cloudflare Pages (or Vercel)
GetRankedLocalVercelRailwayNeon PostgreSQL-
Clarity WikiGitHub Pages (Quartz)---

Railway Projects

Railway hosts Python/Flask backends. CLI installed (railway 4.8.0).

ProjectRepoLanguagePurpose
Site Builderspotcircuit/site-builderPythonFastAPI backend for site generation pipeline
getrankedlocalspotcircuit/getrankedlocalPythonFlask scraper for grid search Playwright
Agent Experts - Orchestratorspotcircuit/agent-expertsPythonPre-Paperclip orchestrator (deprecated)
Digitize-Invoicesspotcircuit/invoicedbPythonInvoice database with agentic AI workflows
tacspotcircuit/tac-8 (latest)PythonTAC project (5 iterations: tac-4 through tac-8)
valiant-creation??Unknown Railway project
dependable-expression??Unknown Railway project

Railway auto-deploys from standalone GitHub repos on push to main.

Full GitHub Repo Inventory (Docker-ready)

All of these have Dockerfiles and are Railway-deployable:

RepoLanguageDescription
spotcircuit/site-builderPythonGoogle Maps to React site in 60s
spotcircuit/getrankedlocalTypeScriptLocal SEO grid ranking + lead gen
spotcircuit/seosnapTypeScriptAI-powered SEO audit with Lighthouse + GPT-5
spotcircuit/TextPROPythonBackend services with AI Developer Workflow
spotcircuit/prior-auth-fastlanePythonHealthcare prior-auth SaaS MVP
spotcircuit/invoicedbPythonInvoice database with agentic AI
spotcircuit/service-marketplaceTypeScriptNext.js service marketplace platform
spotcircuit/leadfinderPythonLead finder (original)
spotcircuit/leadfinder_parallelPythonLead finder (parallel version)
spotcircuit/chopshopTypeScriptTBD
spotcircuit/parcelauditTypeScriptTBD
spotcircuit/velocityelectricTypeScriptTBD
spotcircuit/drcoinsTypeScriptTBD
spotcircuit/roofmasterTypeScriptTBD
spotcircuit/TruckingAIOTypeScriptTBD
spotcircuit/tac-4 through tac-8PythonTAC iterations

Vercel

Vercel hosts all Next.js/Vue frontends. Auto-deploys from GitHub.

ProjectRepo
spotcircuit.comspotcircuit/spotcircuit
Site Builder frontendspotcircuit/site-builder
getrankedlocal.comspotcircuit/getrankedlocal

Cloudflare Pages

Used by Site Builder to deploy generated React sites. Each generated site gets its own Cloudflare Pages project (auto-named site-{slug}-{jobid}).

Account-level project limit exists. The deployer auto-deletes the oldest project when limit is hit.

Requires: CLOUDFLARE_API_TOKEN, CLOUDFLARE_ACCOUNT_ID

Neon PostgreSQL

Serverless PostgreSQL used by GetRankedLocal.

TablePurpose
grid_searchesMain search records
grid_competitorsDiscovered businesses
grid_point_resultsRankings at each grid coordinate
competitor_summariesAggregated statistics
grid_cellsCell metadata with competition density
lead_collectionsMany-to-many lead organization
prospectsDetailed lead information

GitHub Pages

Hosts the Clarity Wiki via Quartz static site generator.

Paperclip

Local orchestration platform at localhost:3100. Manages 5 Claude Code agents.

  • Install: ~/.paperclip/
  • Start: npx paperclipai run
  • Embedded PostgreSQL on port 54329

See paperclip-integration for agent details.


Source: railway list, app expertise files | Filed: 2026-04-08