preferences-schema-versioning
CommunityEvolve data schemas safely.
Software Engineering#type safety#postgresql#database migration#code generation#duckdb#sqlmesh#schema versioning
Authorcameronraysmith
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenge of evolving data schemas over time without disrupting existing applications or data integrity, ensuring smooth transitions during development and deployment.
Core Features & Use Cases
- Declarative Migrations: Manages database schema changes using declarative SQL files.
- Cross-Database Compatibility: Supports PostgreSQL and DuckDB through transpilation.
- Type-Safe Code Generation: Generates language-specific data models and query functions (Python, TypeScript, Go) from schema definitions.
- Use Case: When adding a new field to a
userstable, this Skill helps you safely migrate the existing database, generate updated Pydantic models for your Python application, and ensure all new queries are type-checked against the new schema.
Quick Start
Use the preferences-schema-versioning skill to generate type-safe Python models from the database migrations in the migrations/ directory.
Dependency Matrix
Required Modules
None requiredComponents
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: preferences-schema-versioning Download link: https://github.com/cameronraysmith/vanixiets/archive/main.zip#preferences-schema-versioning Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.