Agent skill · software engineering · aiskillstore
python-database-patterns
SQLAlchemy and database patterns for Python. Triggers on: sqlalchemy, database, orm, migration, alembic, async database, connection pool, repository pattern, unit of work.
Why this skill is useful
Provides specific SQLAlchemy patterns and async integration examples that the AI wouldn't reliably generate on its own.
What it needs
Requires python installed locally. About 2k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Python Database Patterns SQLAlchemy 2.0 and database best practices. SQLAlchemy 2.0 Basics Async SQLAlchemy Model Relationships Common Query Patterns FastAPI Integration Quick Reference Operation SQLAlchemy 2.0 Style ----------- --------------------- Select all select(User) Filter .where(User.id == 1) First .scalaroneornone() All .scalars().all() Count select(func.count(User.id)) Join .join(Post) Eager load .options(selectinload(User.posts)) Additional Resources ./references/sqlalchemy-async.md - Async patterns, session management ./references/connection-pooling.md - Pool configuration, health checks ./references/transactions.md - Transaction patterns, isolation levels ./references/migrations.md - Alembic setup, migration strategies Assets ./assets/alembic.ini.template - Alembic configuration template --- See Also Prerequisites: python-typing-patterns - Mapped types and annotations python-async-patterns - Async database sessions Related Skills: python-fastapi-patterns - Dependency injection for DB sessions python-pytest-patterns - Database fixtures and testing
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/python-database-patterns