{
  "id": "stack-profile:fastapi-postgres",
  "_kind": "StackProfile",
  "_file": "domain/stack-profiles/stack-profiles-additional.yaml",
  "_cluster": "domain",
  "attributes": {
    "displayName": "FastAPI + SQLAlchemy + PostgreSQL",
    "description": "Python API stack: FastAPI as the ASGI web framework, SQLAlchemy as the\nORM with its declarative mapping and async engine (via asyncpg), and\nPostgreSQL as the primary data store. Pydantic models serve double\nduty as both request/response schemas and validation layer.\n\nAlembic handles database migrations. The stack is popular for\ndata-intensive REST and async APIs where Python's ecosystem (pandas,\nscikit-learn, Celery) needs to plug in alongside a web layer. Uvicorn\nor Gunicorn+Uvicorn workers serve the ASGI app. Deployment targets\ninclude Docker on Railway, Fly.io, or GCP Cloud Run. pytest with\nhttpx and pytest-asyncio is the idiomatic testing setup.\n",
    "composes": [
      "language:python",
      "framework:fastapi",
      "library:sqlalchemy",
      "library:pydantic"
    ]
  },
  "outgoingEdges": [
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "language:python",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "framework:fastapi",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "library:sqlalchemy",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "library:pydantic",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "role:backend-engineer",
      "kind": "used_by_role"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "role:data-engineer",
      "kind": "used_by_role"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "role:ml-engineer",
      "kind": "used_by_role"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "domain:backend",
      "kind": "applies_to"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "domain:api-development",
      "kind": "applies_to"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "skill-area:backend-api-design",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "skill-area:backend-data-persistence",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "skill-area:python-data-pipelines",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:fastapi-postgres",
      "to": "skill-area:data-validation-sanitization",
      "kind": "requires_skill_area"
    }
  ],
  "incomingEdges": []
}