cdk-rest-api-postgres
Purpose
Use this skill to design and implement Postgres-backed REST APIs on AWS in a way that fits the target repository.
Treat Postgres plus Drizzle as the default persistence model. When the repository already has compatible constructs and runtime patterns, extend them. When those pieces do not exist, use the references in this skill as portable patterns to generate an equivalent structure.
Portable references live in references/. Load only the patterns needed for the task:
references/rest-api-pattern.mdfor centralized REST route composition patternsreferences/node-lambda-pattern.mdfor Lambda defaults and environment wiringreferences/importer-pattern.mdfor importing existing AWS resources into the stackreferences/response-pattern.mdfor controller and middleware response conventionsreferences/sql-drizzle-pattern.mdfor Drizzle schema, repository, andDatabaseContextguidancereferences/auth-pattern.mdfor Cognito authorizer, scopes, and handler-level group authorizationreferences/runtime-composition-pattern.mdforsrc/app.tssingleton wiring and dependency aggregationreferences/middleware-pattern.mdfor reusable Middy middleware such as auth, validation, HTTP error handling, and Powertools logger injectionreferences/services-pattern.mdfor logger, storage, notification, and mapper service designreferences/utilities-pattern.mdforRestResult, error types, status codes, cursor helpers, and related utilitiesreferences/schedule-pattern.mdfor EventBridge-triggered scheduled Lambda jobs
More from stack-shifter/skills
spec-workflow
Drives a spec-first workflow where the spec is the locked source of truth and implementation runs through plan mode. Use whenever the user wants a feature spec drafted with explicit clarification questions, locked requirements in `docs/specs`, or a "do the next chunk then check in" implementation loop.
26expressjs-rest-api
Designs and implements REST APIs using Express 5 with TypeScript, following the target repository's patterns first. Use this whenever the user wants to add or modify Express routes, controllers, middleware, validation, authentication, repositories, services, or runtime composition — even if they only ask for "a route", "a controller", "a handler", "validation", or "some middleware".
3cdk-rest-api
Designs and implements REST APIs on AWS using the target repository's CDK patterns first. Use this whenever the user wants to add or modify API Gateway REST endpoints, Lambda handlers, Cognito auth, middleware, request models, reusable CDK constructs, runtime composition, scheduled jobs, or repository-backed CRUD routes, even if they only ask for "an endpoint", "a handler", "some CDK wiring", or "an API route".
1dynamodb-design
Designs DynamoDB data models from access patterns first. Use this whenever the user needs help modeling a DynamoDB schema, choosing between single-table and multi-table design, defining partition and sort keys, GSIs, item collections, one-to-many or many-to-many relationships, filtering, sorting, uniqueness, TTL, pagination, or deciding whether DynamoDB is even the right fit for the workload.
1cdk-rest-api-dynamodb
Designs and implements REST APIs on AWS using the target repository's CDK patterns first, with AWS Lambda handlers and DynamoDB as the primary datastore. Use this whenever the user wants to add or modify API Gateway REST endpoints, Lambda handlers, Cognito auth, request models, reusable CDK constructs, or DynamoDB-backed CRUD routes, even if they only ask for "an endpoint", "a handler", "a table", or "some CDK wiring".
1