add-endpoint-python

What problem does it solve?

Building backend endpoints often requires wiring routers, services, repositories, data models, migrations, and tests. This Skill eliminates manual boilerplate by generating a ready-to-use Python FastAPI endpoint scaffold that includes a router, a service layer, a repository, Pydantic v2 models, SQLAlchemy 2.x models, Alembic migrations, and pytest + testcontainers tests.

Core Features & Use Cases

• End-to-end scaffold: router, service, repository, models, and migrations for a new feature.
• Strong typing & validation: Pydantic v2 models for requests and responses; typed router handlers; money types with Decimal; PII protection with EncryptedStr.
• Testability & observability: unit tests for service logic and integration tests with testcontainers; audit log on mutations; idempotency support for safe retries.
• Use Case: Quickly prototyping a new API feature like creating a product or user action with complete persistence and auditing.

Quick Start

Provide the feature name and data model to generate a ready-to-use FastAPI endpoint scaffold.