skills.rest
gouravsingh311
gouravsingh311COMMUNITY
Explore all skills by this author →
GitHub

DB migrations and schema changes

Automate Alembic database migrations for SQLite and Postgres environments.

Updated Apr 2, 2026
Search Tags:#database#migrations#sqlite#alembic#postgres#schema-change
One-click install
npx skills add https://github.com/gouravsingh311/splice-app --skill db-migrations-and-schema-changes-gouravsingh311
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: DB migrations and schema changes
Source: https://github.com/gouravsingh311/splice-app/tree/main/.codex/skills/db-migrations-schema-changes
Command: npx skills add https://github.com/gouravsingh311/splice-app --skill db-migrations-and-schema-changes-gouravsingh311

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Streamline and standardize database migrations and schema changes for the letta-cloud core app using Alembic, uv, and just, with seamless switching between SQLite and Postgres.

Core Features & Use Cases

  • Automated migration lifecycle: generate, review, and apply Alembic revisions for core schemas.
  • Environment-aware migrations: toggle between SQLite and Postgres via LETTA_PG_URI and local dev setups.
  • ORM-aligned changes and safe data backfills: coordinate model updates with migrations and optional data migrations.
  • Troubleshooting and recovery: guidance to diagnose and fix migration failures across environments.

Quick Start

Prepare the environment and run the Alembic-based migrations workflow to autogenerate and apply revisions.

Frequently Asked Questions about DB migrations and schema changes

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Alembic migrations for both SQLite and Postgres?▼

Automate Alembic migrations by toggling between SQLite and Postgres via LETTA_PG_URI, then use uv and just to autogenerate, apply, and verify schema revisions across local and CI environments.

What's the best way to manage database schema changes with Alembic?▼

Manage database schema changes by coordinating ORM model updates with Alembic to autogenerate revisions, review them, and apply safe data backfills for core schemas.

How do I switch between SQLite and Postgres for local database migrations?▼

Switch between SQLite and Postgres for database migrations by configuring the LETTA_PG_URI environment variable, enabling environment-aware workflow switching for local development and CI.

Do I need uv and just to run Alembic database migrations?▼

Yes, uv and just are required to enforce the environment-aware workflow that automates Alembic migration generation, application, and verification for SQLite and Postgres databases.

How do I troubleshoot and recover from Alembic migration failures?▼

Troubleshoot and recover from Alembic migration failures by following environment-aware guidance to diagnose and fix revision application errors across SQLite and Postgres setups.

Related Skills

Explore More Software Engineering Skills→
sarthchawlasarthchawla

DB migrations and schema changes

Automate Alembic migrations and schema changes for letta-cloud across SQLite and Postgres.

Community
Advanced
bswrundquistbswrundquist

alembic

Manage database schema migrations with Alembic and SQLAlchemy.

Community
Intermediate
oornneryoornnery

sqlmodel

Coordinate SQLModel persistence with async sessions, relationships, and Alembic migrations.

Community
Advanced
wmeintswmeints

Backend Migrations

Generate reversible database schema migrations with Alembic, Django, Flyway, or Liquibase.

Community
Intermediate