Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add borghei/Claude-Skills --skill senior-backend -a claude-code
Open on GitHub

What 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.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

How to install senior-backend

1Skills CLI (Vercel)

npx skills add borghei/Claude-Skills --skill senior-backend -a claude-code

2Manually: put the files in place

~/.claude/skills/senior-backend/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/senior-backend/

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.

senior-backend Alireza Rezvani senior-backend scaffolds backend APIs, detects database bottlenecks, and runs load tests. Useful when designing Express routes, optimizing PostgreSQL, or preparing for production. CX Codex +1 1,674installs nodejs-backend bobmatnyc The nodejs-backend skill guides TypeScript backend work with Express or Fastify. Use it for REST APIs, routing, middleware, validation, and database integration. CX Codex +1 307installs backend-dev-guidelines sickn33 backend-dev-guidelines is a Claude Code skill that guides backend work. It activates for routes, controllers, services, Express middleware, and Prisma access. CX Codex +1 1,800installs backend-development MoizIbnYousaf backend-development — a skill that gives your agent conventions for REST APIs, database schemas and microservice patterns. Useful when backend code should stay consistent across sessions. CX Codex +1 876installs nodejs-backend-patterns Seth Hobson nodejs-backend-patterns tells the agent how to build Express and Fastify servers: middleware, error handling, auth, database integration. CX Codex +1 48,535installs nodejs-express-server aj-geddes nodejs-express-server is a Claude Code skill for building Express.js servers with routes, middleware, and authentication. It activates for REST API work and request handling. CX Codex +1 3,300installs node-specialist VoltAgent Community node-specialist is a Claude Code subagent for building, analyzing, and debugging Node.js server applications. Invoke it for API, CLI, microservice, or background task work. CX Codex ★ 26,718repo stars

From the same set120

The whole set →
operations-manager The operations-manager skill reviews operational processes, capacity needs, and vendor performance. Use it to structure a DMAIC project or plan a workflow change. CX Codex +1 324installs senior-fullstack senior-fullstack — a skill for Claude Code scaffolds production-ready fullstack web applications and runs static code quality audits. Generates project structures when starting an MVP or checking code before review. CX Codex +1 322installs senior-mobile senior-mobile — a mobile development skill that runs in Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, and OpenCode. CX Codex +1 316installs marketing-analyst marketing-analyst equips your coding assistant to evaluate campaign performance, test multi-touch attribution, and rebalance channel spend using ROI metrics. CX Codex +1 312installs sales-operations sales-operations — a skill for sales analytics: builds pipeline reports, designs territories, models quotas, and architectures compensation plans. Use it to audit CRM data quality or set evidence-based targets across your team. CX Codex +1 286installs agile-coach Agile coaching skill for Claude Code, Codex, and Cursor that guides framework adoption and team facilitation. Evaluates organizational maturity levels and tracks delivery metrics. CX Codex +1 270installs design-system-lead design-system-lead guides agents through building multi-tier design tokens, component architecture, and cross-platform export pipelines. CX Codex +1 262installs cmo-advisor cmo-advisor guides marketing strategy, demand generation, lead scoring, and revenue alignment. Use it when a plan needs clear inputs, channels, and metrics. CX Codex +1 261installs

Project sponsors

Companies that keep this analytics open