sqlalchemy-postgres

Community

Build robust SQLAlchemy + PostgreSQL DB layers.

Authorytqh
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides structured guidance for building production-ready database layers with SQLAlchemy 2.0, Pydantic, Alembic, and PostgreSQL, simplifying model design, migrations, and async data access.

Core Features & Use Cases

  • Setup a full database layer with async SQLAlchemy 2.0, PostgreSQL, and Alembic migrations.
  • Define models and Pydantic schemas with clear separation and type safety.
  • Implement the repository pattern and async CRUD operations for scalable data access.

Quick Start

Install and configure PostgreSQL, initialize Alembic, scaffold models and repositories, and wire the FastAPI dependency for async sessions.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sqlalchemy-postgres
Download link: https://github.com/ytqh/agent-skills/archive/main.zip#sqlalchemy-postgres

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.