slurpyb/api-engineer

Alembic — database migration tool for SQLAlchemy. Use when creating/running migrations, autogenerate, batch (SQLite) operations, branching, naming conventions, offline SQL generation, programmatic command invocation, or extending Alembic with custom operations and plugins.

Complete FastAPI knowledge combining official documentation and FastAPI codebase. Use when building FastAPI applications, defining routes and path operations, working with Pydantic models, handling dependencies and security, async patterns, testing, deployment, or any FastAPI feature.

Use this skill when working with HTTPX, a fully featured HTTP client for Python 3 with sync and async APIs. HTTPX provides a familiar requests-like interface with support for HTTP/1.1 and HTTP/2, connection pooling, streaming, proxies, custom transports, and comprehensive authentication and middleware capabilities.

Complete PostgreSQL knowledge combining official documentation and source code. Use when designing databases, writing queries, optimizing performance, or managing PostgreSQL instances. Covers SQL, data types, indexes, constraints, partitioning, concurrency (MVCC), JSON/JSONB, full-text search, schemas, privileges, row-level security, and replication.

Pydantic v2 — data validation and settings management using Python type hints. Use when defining models, validators, serializers, field constraints, or pydantic-settings configuration.

SQLModel — SQL databases in Python with type annotations, built on SQLAlchemy and Pydantic. Use when defining table models, relationships, queries (select/where/join), sessions, indexes, or FastAPI database integration.

Use when creating SQLModel database models, CRUD operations, queries with joins, or relationships. NOT when non-database operations, plain SQL, or unrelated data handling. Triggers: "SQLModel", "database model", "CRUD", "create/read/update/delete", "query", "ForeignKey", "relationship".

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.