msia-database

Community

SQLAlchemy + Alembic patterns for MSI-a DB

Authorpepeccz
Version1.0.0
Installs0

System Documentation

What problem does it solve?

MSI-a database component provides a complete PostgreSQL schema with 32 models, Alembic migrations, and a sophisticated seed system for tariff/element data.

Core Features & Use Cases

  • 32 SQLAlchemy Models: Complete schema for users, tariffs, RAG, cases, admin, monitoring
  • Fully Async: AsyncPG engine with connection pooling
  • Dual Warning System: Inline warnings with element_warning_associations
  • Deterministic UUID Seeding: UUID v5 for idempotent seeds
  • Tier Inheritance: TierElementInclusion and self-referential hierarchies
  • Self-Referential Hierarchy: Element parent-child relationships and variants
  • Conditional Fields: ElementRequiredField with conditional logic
  • Alembic Migrations: 34 migrations with rollback support
  • Seeds Architecture: Deterministic, idempotent seed data for tariffs/elements

Quick Start

Run the Alembic migrations and seeders to initialize the MSI-a database schema.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 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: msia-database
Download link: https://github.com/pepeccz/msi-a/archive/main.zip#msia-database

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 471,000+ vetted skills library on demand.