Expert Database
ReJeCtAll/ExpertTeam-Codex
数据库优化专家入口。用于 Codex CLI 的 $expert-database 调用. An agent skill from ReJeCtAll/ExpertTeam-Codex.
Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote.
Install Replica Architect
$ npx skills add Jakeschincariol/replica-skill --skill replica-architect -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install Jakeschincariol/replica-skill replica-architect --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/Jakeschincariol/replica-skill.git skills-src && mkdir -p .claude/skills && cp -r skills-src/replica-architect .claude/skills/replica-architect && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "replica-architect" agent skill from https://github.com/Jakeschincariol/replica-skill/tree/main/replica-architect into .claude/skills/replica-architect/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "replica-architect", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/Jakeschincariol/replica-skill/tree/main/replica-architectType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add Jakeschincariol/replica-skill --skill replica-architect -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install Jakeschincariol/replica-skill replica-architect --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Jakeschincariol/replica-skill.git skills-src && mkdir -p .agents/skills && cp -r skills-src/replica-architect .agents/skills/replica-architect && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "replica-architect" agent skill from https://github.com/Jakeschincariol/replica-skill/tree/main/replica-architect into .agents/skills/replica-architect/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "replica-architect", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add Jakeschincariol/replica-skill --skill replica-architect -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install Jakeschincariol/replica-skill replica-architect --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Jakeschincariol/replica-skill.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/replica-architect .cursor/skills/replica-architect && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "replica-architect" agent skill from https://github.com/Jakeschincariol/replica-skill/tree/main/replica-architect into .cursor/skills/replica-architect/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "replica-architect", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/Jakeschincariol/replica-skill.git --path replica-architect--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add Jakeschincariol/replica-skill --skill replica-architect -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install Jakeschincariol/replica-skill replica-architect --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Jakeschincariol/replica-skill.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/replica-architect .gemini/skills/replica-architect && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "replica-architect" agent skill from https://github.com/Jakeschincariol/replica-skill/tree/main/replica-architect into .gemini/skills/replica-architect/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "replica-architect", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install Jakeschincariol/replica-skill replica-architectInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add Jakeschincariol/replica-skill --skill replica-architect -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/Jakeschincariol/replica-skill.git skills-src && mkdir -p .github/skills && cp -r skills-src/replica-architect .github/skills/replica-architect && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "replica-architect" agent skill from https://github.com/Jakeschincariol/replica-skill/tree/main/replica-architect into .github/skills/replica-architect/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "replica-architect", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add Jakeschincariol/replica-skill --skill replica-architect -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install Jakeschincariol/replica-skill replica-architect --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Jakeschincariol/replica-skill.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/replica-architect .opencode/skills/replica-architect && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "replica-architect" agent skill from https://github.com/Jakeschincariol/replica-skill/tree/main/replica-architect into .opencode/skills/replica-architect/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "replica-architect", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
replica-architect- GitHub stars
- 1.4k
- Token cost
- ~1.1k tokens
- SKILL.md length
- 498 words
- Files
- 2
- Skills in repo
- 11
- Repo updated
- First seen
- Licence
- MIT
At a glance
Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote.
- Works in 5 steps: the stack → the schema → the API → …
- The user says plan the clone
- SKILL.md covers Step 1: the stack, Step 2: the schema, Step 3: the API and Step 4: the parts that bite, plus 2 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Replica Architect is an agent skill from Jakeschincariol/replica-skill. Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote. Picks boring, managed tech, turns the inferred data model into real SQL with indexes and access rules, lists every route by flow, and orders the build as a thin vertical slice first. Use when the user says "plan the clone", "what stack should I use", "design the database", "write the schema", "plan the API", "architecture for my version of X", or after /replica-recon finishes.
Its SKILL.md is about 1.1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `architecture.md`).
It sits in Databases, covering Database schema design and SQL. It works with SQL and Supabase. The repository describes itself as: Eleven free Claude skills that clone any app: reverse-engineer it, rebuild it, test it for bugs, then fix what its users hate. Free, MIT. The licence is MIT.
When your agent uses it
- The user says plan the clone
- What stack should I use
- Design the database
- Write the schema
Example prompts
- “plan the clone”
- “what stack should I use”
- “design the database”
- “/replica-architect”
Workflow steps
5 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit 77c9436. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are sql).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Replica Architect loads about 1.1k tokens when it runs. Until then it costs about 124 tokens; SKILL.md has 498 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from Jakeschincariol/replica-skill at commit 77c9436, republished under its MIT licence (© Jakeschincariol). 498 words, ~1,147 tokens.
Download SKILL.mdSave it as
.claude/skills/replica-architect/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- replica-architect
- description
- Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote. Picks boring, managed tech, turns the inferred data model into real SQL with indexes and access rules, lists every route by flow, and orders the build as a thin vertical slice first. Use when the user says "plan the clone", "what stack should I use", "design the database", "write the schema", "plan the API", "architecture for my version of X", or after /replica-recon finishes.
replica-architect
Reads replica/recon.md and replica/features.csv. Writes
replica/architecture.md (template: architecture.md in this folder).
If there is no recon map, stop and run /replica-recon first. Planning a
clone from memory of what an app does is how you miss half of it.
Step 1: the stack
Use what the user already knows if they have a stack. Otherwise the default, because every part is managed, documented and cheap at zero users:
| layer | default | swap for |
|---|---|---|
| web app | Next.js (App Router) + TypeScript | Remix, SvelteKit, Rails |
| styling | Tailwind, tokens from replica-design | CSS modules |
| mobile | Expo (React Native) | SwiftUI, Kotlin |
| database | Postgres on Supabase or Neon | PlanetScale, SQLite (Turso) |
| ORM | Drizzle or Prisma | raw SQL |
| auth | Supabase Auth or Auth.js | Clerk |
| payments | Stripe Checkout + Billing | Lemon Squeezy, Paddle |
| Resend or Postmark | SES | |
| jobs | Vercel Cron, Inngest or Trigger.dev | a worker on Fly |
| files | Supabase Storage or Cloudflare R2 | S3 |
| hosting | Vercel | Netlify, Fly, Render |
Write each choice with one line of why. One database. No microservices. The clone does not need the original's architecture, it needs the original's features.
Step 2: the schema
Turn the inferred data model into SQL. For every table:
id uuid primary key default gen_random_uuid(),created_at,updated_at- an owner column (
user_idororg_id) on everything a user owns - foreign keys with an
on deleterule decided, not defaulted - indexes on every foreign key and every column you filter or sort by
- enums or check constraints for status fields
- times as
timestamptz, always, stored in UTC - money as integer cents plus a currency column
- access rules: Postgres row level security on Supabase, or one authorisation check per query in the data layer. Write which.
Example, for a booking app:
create table bookings (
id uuid primary key default gen_random_uuid(),
event_type_id uuid not null references event_types(id) on delete cascade,
host_id uuid not null references users(id) on delete cascade,
start_at timestamptz not null,
end_at timestamptz not null,
guest_name text not null,
guest_email text not null,
guest_timezone text not null,
status text not null default 'confirmed'
check (status in ('confirmed','cancelled','rescheduled')),
answers jsonb not null default '{}',
created_at timestamptz not null default now(),
constraint no_zero_length check (end_at > start_at)
);
create index on bookings (host_id, start_at);Then the hard constraints the recon found. Two guests booking the same slot is a database problem (an exclusion constraint or a unique index), not a UI problem.
Show full SKILL.md (192 more words)Show less
Step 3: the API
One table per flow from the recon map. For every route or server action:
method path | what it does | who can call it | input | output | flow
Plus webhooks in (Stripe, calendar providers) and out, and background jobs (reminders, sync, cleanup) with their schedule.
Only official, public APIs with the user's own keys. Never the original app's private endpoints, even if they are visible in a browser.
Step 4: the parts that bite
Write a line on each that applies: time zones and daylight saving, idempotency (webhooks arrive twice), race conditions, rate limits, file size limits, search, realtime, offline, email deliverability, multi-tenancy, GDPR deletion.
Step 5: build order
- Vertical slice. The core loop end to end, ugly: sign up, do the one thing, see the result. Proves the stack.
- Must-haves from
features.csv, by area. - Should-haves, then could-haves.
- The fixes replica-entrepreneur finds, once it has run.
Each milestone lists its screens (S-IDs), tables and routes.
Output
replica/architecture.md, the SQL in replica/schema.sql or as the first
migration, and a summary: stack in one line, table count, route count, the
three riskiest parts, and the next step: /replica-design.
© Jakeschincariol, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 1 other file in replica-architect of Jakeschincariol/replica-skill.
- SKILL.md
- architecture.md
Open the folder on GitHubat commit 77c9436
Compare with similar skills
Replica Architect next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Replica Architect this skillJakeschincariol/replica-skill | 1.4k | — | ~1.1k | Automated safety check: Pass | MIT | |
| Expert DatabaseReJeCtAll/ExpertTeam-Codex | 113 | — | ~692 | Automated safety check: Pass | MIT | |
| Memstack Security Rls Guardiancwinvestments/memstack | 423 | — | ~3.4k | Automated safety check: Pass | Proprietary | |
| Firebaseericrisco/rsc-harness | 180 | — | ~3.3k | Automated safety check: Pass | MIT | |
| Supabase Admincuriositech/some_claude_skills | 244 | — | ~1.9k | Automated safety check: Notes | MIT | |
| Supabase Postgres Best Practicessupabase/agent-skills | 2.7k | 24 repos | ~808 | Automated safety check: Pass | MIT |
Similar skills
Memstack Security Rls Guardian
cwinvestments/memstack
A skill your agent uses when creating or altering database tables in Supabase or PostgreSQL projects.
Firebase
ericrisco/rsc-harness
A skill your agent uses when building on Firebase — Firestore data modeling, Security Rules, Auth and custom claims, Cloud Functions, Storage, modular Web/Admin SDK imports — including symptoms like…
Supabase Admin
curiositech/some_claude_skills
Supabase administration, RLS policies, migrations, and schema design.
- Official
Supabase Postgres Best Practices
supabase/agent-skills
Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries.
- Official
Safe SQL Execution
supabase/supabase
A skill your agent uses whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix…
More from Jakeschincariol/replica-skill
All 11 skills in this repoReplica Brand
Jakeschincariol/replica-skill
Names and rebrands an app clone so it is the user's own: name candidates with the trademark, domain, store and handle checks to run, a new palette checked for contrast, a logo brief, a voice guide…
Replica Deploy
Jakeschincariol/replica-skill
Ships an app clone live on the user's own domain: a preflight gate (tests green, parity must-haves done, rebrand sweep clean, listing linted, legal pages up), production database and env vars, the…
Replica Design
Jakeschincariol/replica-skill
Rebuilds an app's design system for a clone: colour roles, type scale, spacing, radius, shadows and every component with its states, as design tokens plus component specs, with original assets…
Replica Diff
Jakeschincariol/replica-skill
Compares an app clone against the original: a feature parity score from the feature matrix (weighted by must, should, could) with the missing list in build order, plus a screenshot layout diff that…
Replica Entrepreneur
Jakeschincariol/replica-skill
Researches the app being cloned and reads what its real users say in public reviews (App Store, Google Play, G2, Capterra, Trustpilot, Reddit, Hacker News, its own feature-request board), then ranks…
Replica Launch
Jakeschincariol/replica-skill
Writes the launch for an app clone: the landing page built on the positioning angle, pricing set against the original's public pricing and its users' complaints, and the App Store and Google Play…
Related
Categories
Questions about Replica Architect
What does Replica Architect do?
Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote. Replica Architect is an agent skill from Jakeschincariol/replica-skill. Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote.
When should I use Replica Architect?
Replica Architect fits situations like: the user says plan the clone; what stack should I use; design the database; write the schema.
How do I install Replica Architect in Claude Code?
Run `npx skills add Jakeschincariol/replica-skill --skill replica-architect -a claude-code`. Or copy the skill folder (replica-architect in Jakeschincariol/replica-skill) into .claude/skills/replica-architect in your project. Claude Code loads it when a task matches its description.
How do I install Replica Architect in Codex?
Run `npx skills add Jakeschincariol/replica-skill --skill replica-architect -a codex`. Or copy the skill folder (replica-architect in Jakeschincariol/replica-skill) into .agents/skills/replica-architect in your project. Codex loads it when a task matches its description.
Can I use Replica Architect in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add Jakeschincariol/replica-skill --skill replica-architect -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/replica-architect, .gemini/skills/replica-architect, .github/skills/replica-architect and .opencode/skills/replica-architect in your project.
What does Replica Architect need to run?
SKILL.md names no scripts, command-line tools or credentials: Replica Architect is instructions for the agent only.
Does Replica Architect access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Replica Architect safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Replica Architect use?
Replica Architect is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Replica Architect use?
About 1.1k tokens (SKILL.md is roughly 4.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Replica Architect?
Skills that share tags, products or a category with Replica Architect: Expert Database (ReJeCtAll/ExpertTeam-Codex, 113 stars), Memstack Security Rls Guardian (cwinvestments/memstack, 423 stars), Firebase (ericrisco/rsc-harness, 180 stars) and Supabase Admin (curiositech/some_claude_skills, 244 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Replica Architect?
Jakeschincariol (a GitHub user) maintains it in Jakeschincariol/replica-skill, which has 1,432 GitHub stars. The repository holds 11 skills in this directory. The repository was last updated on October 3, 2026.
Source: Jakeschincariol/replica-skill on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.