# senior-backend

senior-backend — a skill for designing and optimizing Node.js REST APIs on PostgreSQL. Generates routes from OpenAPI specs, analyzes schemas and indexes, runs load tests with a CI gate.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 300 installs · ★ 1183 repo stars
- Author: borghei
- License: LicenseRef-MIT-Commons-Clause · policy=link-only · description only; the file stays with the author
- Source: https://github.com/borghei/Claude-Skills/tree/HEAD/engineering/senior-backend/SKILL.md
- Updated: 2026-11-08
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/borghei-senior-backend

## What it does

Available on Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, and OpenCode. Includes three Python utilities: `api_scaffolder.py` builds route handlers, Zod validators, and TypeScript types for Express, Fastify, or Koa from an OpenAPI spec; `database_migration_tool.py` detects missing indexes, N+1 risks, and generates migrations with rollback scripts; `api_load_tester.py` runs HTTP tests with latency percentiles (P50/P90/P95/P99) and can gate CI via the `--min-success` flag.

Requires Python 3; PyYAML is optional, needed only for flow-style YAML in OpenAPI. Before your first run, confirm the framework (Express, Fastify, Koa), where your API contract lives (OpenAPI file or endpoint list), and whether you need schema analysis or migration generation. Run load tests only on systems you own or have permission to test; the tool sends real traffic.

## Requirements
- Works with: PostgreSQL

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill senior-backend -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/senior-backend/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/senior-backend/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill senior-backend -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/senior-backend/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill senior-backend -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/senior-backend/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install borghei/Claude-Skills engineering/senior-backend/SKILL.md
```

2. **Manually: put the files in place**
- File: `.github/skills/senior-backend/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill senior-backend -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/borghei/Claude-Skills --path engineering/senior-backend
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/senior-backend/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill senior-backend -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/borghei/Claude-Skills/tree/HEAD/engineering/senior-backend/SKILL.md

## When to use it
- generate route handlers and validators from an OpenAPI spec
- find missing indexes and N+1 risks in PostgreSQL
- create migrations with tested rollback scripts
- run load tests with latency percentile reports
- harden an API for production with security patterns

## Example prompts
- Generate Express routes from `openapi.json` into `src/routes/`
- Analyze `schema.sql` for missing indexes and N+1 query patterns
- Run a load test on `https://staging.example.com` with 20 concurrent clients and a 99% success gate

## Similar
- [nodejs-backend](https://affpapa.org/en/nevibecode/skills/bobmatnyc-nodejs-backend.md) — skill · 307 installs
- [backend-dev-guidelines](https://affpapa.org/en/nevibecode/skills/backend-dev-guidelines.md) — skill · 1800 installs
- [backend-development](https://affpapa.org/en/nevibecode/skills/moizibnyousaf-backend-development.md) — skill · 876 installs
- [nodejs-backend-patterns](https://affpapa.org/en/nevibecode/skills/nodejs-backend-patterns.md) — skill · 48535 installs
- [nodejs-express-server](https://affpapa.org/en/nevibecode/skills/nodejs-express-server.md) — skill · 3300 installs
- [node-specialist](https://affpapa.org/en/nevibecode/agents/node-specialist.md) — subagent · ★ 26718 repo stars

## Other versions with the same name
- [senior-backend · alirezarezvani](https://affpapa.org/en/nevibecode/skills/senior-backend.md) — 1674 installs

From the same set: [borghei/claude-skills](https://affpapa.org/en/nevibecode/by/borghei/claude-skills.md) — 120 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
