sqlmodel

What problem does it solve?

The sqlmodel skill provides a structured, hands-on guide to building database-backed FastAPI applications with SQLModel, PostgreSQL, and SQLAlchemy. It helps teams design clean models, manage sessions, implement CRUD, run migrations with Alembic, and optimize performance.

Core Features & Use Cases

• Model-driven API development: define SQLModel models, relationships, and request/response schemas for FastAPI endpoints.
• Database operations: perform CRUD, complex queries, and migrations with a production-ready workflow.
• Testing and performance: test against SQLite or PostgreSQL, and apply pooling and indexing best practices for scalable apps.

Quick Start

Use the sqlmodel skill to scaffold a FastAPI project with a User model, a Post model, and a PostgreSQL database configuration; then run migrations and start the API server.