home/categories/sql-databases/panaversity-agentfactory-docs-skills-archive-rare-building-with-sqlmodel-async-skill-md
sql-databasesdatabases

building-with-sqlmodel-async

Use when building async database layers with SQLModel and PostgreSQL. Triggers include async session management, create_async_engine, SQLModel relationships, CRUD operations with async/await, N+1 prevention with selectinload, JSONB columns, self-referential models, or Alembic async migrations. NOT when using sync SQLAlchemy (use sync patterns) or raw SQL (use SQLModel ORM).

panaversity
maintainer
panaversity
Updated 1/19/2026
Stars
109
Forks
95
quick start

Installation and usage

Use when building async database layers with SQLModel and PostgreSQL. Triggers include async session management, create_async_engine, SQLModel relationships, CRUD operations with async/await, N+1 prevention with selectinload, JSONB columns, self-referential models, or Alembic async migrations. NOT when using sync SQLAlchemy (use sync patterns) or raw SQL (use SQLModel ORM).

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use building-with-sqlmodel-async