Stats
Actions
Tags
From george-setup
Use for any server-side API or data persistence work. Triggers on REST endpoints, GraphQL resolvers, DataLoader, Node.js, Express, Fastify, API design, pagination, filtering, sorting, databases, SQL, PostgreSQL, indexes, EXPLAIN ANALYZE, query optimization, Prisma, Drizzle, TypeORM, SQLAlchemy, ORM, N+1 queries, migrations, Alembic, schema design, data modeling, normalization, JWT, OAuth, authentication, authorization, rate limiting, Redis, caching, message queues, BullMQ, Kafka, RabbitMQ, webhooks, idempotency, signatures, microservices, multi-tenant, row-level security.
How this skill is triggered — by the user, by Claude, or both
Slash command
/george-setup:backend-dataThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Layer 2 domain skill for all server-side development and data persistence. Routes to reference files and Layer 3 atomic skills by task type.
Layer 2 domain skill for all server-side development and data persistence. Routes to reference files and Layer 3 atomic skills by task type.
| Task Pattern | Reference | Layer 3 Skills |
|---|---|---|
| REST API design, URL structure, status codes | references/rest-graphql.md | — |
| GraphQL schema, resolvers, DataLoader | references/rest-graphql.md | — |
| Node.js, Express, Fastify, middleware | references/nodejs-patterns.md | — |
| SQL optimization, EXPLAIN, query tuning | references/sql-optimization.md | — |
| ORM (Prisma, Drizzle, TypeORM, SQLAlchemy) | references/orm-patterns.md | — |
| API auth, JWT, OAuth, rate limiting | references/api-security.md | security-deep, auth-clerk |
| Microservices, message queues, Kafka, RabbitMQ | references/microservices.md | — |
| Database migrations, schema changes | references/migrations.md | — |
| Data modeling, normalization, schema design | references/data-modeling.md | — |
| Webhooks, signatures, idempotency | references/webhooks.md | — |
Activate for any task involving:
Service-to-service, high throughput? → gRPC
Flexible client queries, nested data? → GraphQL
Simple CRUD, broad tooling? → REST (default)
Default → PostgreSQL (JSONB, full-text search, pgvector)
Embedded/local-first → SQLite (WAL mode)
Caching/sessions → Redis
Document store, evolving schema → MongoDB
AWS-native, single-digit ms → DynamoDB
TypeScript, great DX? → Prisma (schema-first)
TypeScript, SQL-like syntax? → Drizzle (lighter)
Python? → SQLAlchemy
Complex raw SQL needs? → Drop to query builder
npx claudepluginhub george11642/george-plugins --plugin george-setupSkill for defining database schemas, REST/GraphQL endpoints, server-side validation, authentication, and backend logic with Node.js, Prisma, and PostgreSQL.
Provides patterns for backend API design with REST conventions, SQL database schemas and queries, JWT authentication, Redis caching, and rate limiting.
Guides backend tasks like REST/GraphQL API design, database query optimization, authentication, microservices building, code review, migrations, and load testing across detected stacks.