senior-backend · borghei — skill for Claude Code: REST APIs and PostgreSQL
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.
LicenseRef-MIT-Commons-Clause 300 installs ★ 1,183 updated 2026-11-08
npx skills add borghei/Claude-Skills --skill senior-backend -a claude-codeWhat senior-backend 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.
What it helps with
- 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 for the agent
- Generate Express routes from
openapi.jsonintosrc/routes/ - Analyze
schema.sqlfor missing indexes and N+1 query patterns - Run a load test on
https://staging.example.comwith 20 concurrent clients and a 99% success gate
How to install senior-backend
1Skills CLI (Vercel)
npx skills add borghei/Claude-Skills --skill senior-backend -a claude-code2Manually: put the files in place
~/.claude/skills/senior-backend/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/senior-backend/
1Skills CLI (Vercel)
npx skills add borghei/Claude-Skills --skill senior-backend -a codex2Manually: put the files in place
.agents/skills/senior-backend/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add borghei/Claude-Skills --skill senior-backend -a cursor2Manually: put the files in place
.cursor/skills/senior-backend/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install borghei/Claude-Skills engineering/senior-backend/SKILL.md2Manually: put the files in place
.github/skills/senior-backend/SKILL.md1Skills CLI (Vercel)
npx skills add borghei/Claude-Skills --skill senior-backend -a gemini-cli2Platform CLI
gemini skills install https://github.com/borghei/Claude-Skills --path engineering/senior-backendManually: put the files in place
.devin/skills/senior-backend/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add borghei/Claude-Skills --skill senior-backend -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about senior-backend
How do I install senior-backend in Claude Code?
Run npx skills add borghei/Claude-Skills --skill senior-backend -a claude-code, then open ~/.claude/skills/senior-backend/SKILL.md.
What does senior-backend do?
It generates route handlers and types from an OpenAPI spec, identifies slow queries and missing indexes in PostgreSQL, creates migrations with rollbacks, and runs load tests measuring latency percentiles and throughput.
Which frameworks does it support?
Express, Fastify, and Koa. Pass your choice via the --framework flag when you call api_scaffolder.py.
Similar skills
All skills for Backend and APIs →senior-backend by other authors comes first.