Standardize PostgreSQL database patterns with SQLAlchemy models and Alembic migrations.
npx skills add https://github.com/pepeccz/msi-a --skill msia-database
Please help me install this Agent Skill. Skill: msia-database Source: https://github.com/pepeccz/msi-a/tree/main/skills/msia-database Command: npx skills add https://github.com/pepeccz/msi-a --skill msia-database
MSI-a database component provides a complete PostgreSQL schema with 32 models, Alembic migrations, and a sophisticated seed system for tariff/element data.
Run the Alembic migrations and seeders to initialize the MSI-a database schema.
High-intent search queries and answers about installing and using this skill.
Structure SQLAlchemy models and Alembic migrations by standardizing 32 models with AsyncPG pooling, 34 migrations with rollback, and deterministic UUID v5 seeds to ensure idempotent data initialization across projects.
Deterministic UUID seeds use UUID v5 generation to create idempotent seed data, ensuring that running tariff and element seeders repeatedly produces identical database records without duplication or conflicts.
Yes, you need Alembic, SQLAlchemy, and AsyncPG installed in your codebase to run the async engine, apply the 34 migrations, and execute the deterministic seed workflows for the MSI-a database.
Model self-referential hierarchies and tier inheritance by using Element parent-child relationships with variants, TierElementInclusion, and conditional ElementRequiredField logic to manage complex tariff structures.
Implement a dual warning system using inline warnings paired with element_warning_associations across the SQLAlchemy models, enabling consistent alert tracking and validation for tariff elements within the database.
Yes, you can roll back Alembic migrations because the 34 migration scripts include rollback support, allowing you to safely revert the PostgreSQL schema changes if an update fails or introduces inconsistencies.
agusmdevConfigure async SQLAlchemy 2.0 engine, session factory, and get_db dependency for FastAPI with PostgreSQL.
komlukGuide relational database schema design, indexing, migrations, and query analysis.
BenidrissaBuild a FastAPI backend with async SQLAlchemy, Pydantic V2, and Celery tasks.
RyoOsakaGenerate and apply Drizzle ORM database migrations from TypeScript schema changes.
