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.md for centralized REST route composition patterns
• references/node-lambda-pattern.md for Lambda defaults and environment wiring
• references/importer-pattern.md for importing existing AWS resources into the stack
• references/response-pattern.md for controller and middleware response conventions
• references/sql-drizzle-pattern.md for Drizzle schema, repository, and DatabaseContext guidance
• references/auth-pattern.md for Cognito authorizer, scopes, and handler-level group authorization
• references/runtime-composition-pattern.md for src/app.ts singleton wiring and dependency aggregation
• references/middleware-pattern.md for reusable Middy middleware such as auth, validation, HTTP error handling, and Powertools logger injection
• references/services-pattern.md for logger, storage, notification, and mapper service design
• references/utilities-pattern.md for RestResult, error types, status codes, cursor helpers, and related utilities
• references/schedule-pattern.md for EventBridge-triggered scheduled Lambda jobs