Replica Architect

What it does

Reads replica/recon.md and replica/features.csv (produced by the companion /replica-recon skill) and writes replica/architecture.md plus replica/schema.sql.

• Stack selection: an opinionated table for web, mobile, database, ORM, auth, payments, email, jobs, file storage and hosting, each with a one-line rationale. One database, no microservices.
• Schema design: uuid primary keys, created_at/updated_at, owner columns, explicit on delete rules, indexes on every FK and filter/sort column, check constraints for status enums, timestamptz in UTC, money as integer cents + currency, and either Postgres RLS or an explicit per-query authorisation check.
• API design: one table per flow — method path | what it does | who can call it | input | output — plus inbound/outbound webhooks and scheduled background jobs.
• Sharp edges checklist: time zones and DST, webhook idempotency, race conditions, rate limits, search, realtime, offline, deliverability, multi-tenancy, GDPR deletion.
• Build order: a thin end-to-end vertical slice first, then must-haves, should-haves and could-haves, with screens, tables and routes per milestone.

Who it's for

• Indie hackers and founders rebuilding their own version of a familiar SaaS
• Junior-to-mid fullstack devs who stall at table design and endpoint inventories
• Small teams that want the shortest credible path to an MVP

Examples

1. "Design the database for my Calendly clone" → a bookings table with timestamptz columns and a DB-level constraint that prevents double-booking.
2. "What stack should I use?" → a defaults table (Next.js, Supabase, Stripe, Vercel) with swap options and one-line reasons.
3. Right after /replica-recon finishes → feature list reordered into milestones with the three riskiest parts called out.

Note: the skill explicitly forbids calling the original app's private endpoints and requires official public APIs with your own keys.

Read the instructions in this file and follow them to help me:
https://raw.githubusercontent.com/Jakeschincariol/replica-skill/HEAD/replica-architect/SKILL.md

What I want: (describe your task here)

Install the skill I found on Claude Skill Mart.
Copy the replica-architect folder from the GitHub repo Jakeschincariol/replica-skill into my ~/.claude/skills/replica-architect/.
When it's done, tell me in one line what this skill can do.