vespertide

Generate typed migration plans from declarative JSON database schemas.

23|8|Updated Dec 9, 2025
One-click install
npx skills add https://github.com/dev-five-git/vespertide --skill vespertide
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: vespertide
Source: https://github.com/dev-five-git/vespertide/tree/main
Command: npx skills add https://github.com/dev-five-git/vespertide --skill vespertide

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables declarative database modeling by describing schemas in JSON and generating migration plans to manage changes across your migrations.

Core Features & Use Cases

  • Declarative JSON schema definitions for tables, columns, constraints, and ENUM types.
  • Diff-based migration planning that derives typed MigrationAction steps from model changes.
  • ORM export and multi-database support (PostgreSQL, MySQL, SQLite) for end-to-end workflows.
  • JSON Schema validation for IDE autocompletion and validation, plus optional migration previews.

Quick Start

  • vespertide init
  • vespertide new <name>
  • vespertide diff
  • vespertide sql
  • vespertide revision -m "create <name> table"

Frequently Asked Questions about vespertide

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

FAQPage Schema
How do I auto-generate database migration plans from JSON schemas?

Generating database migration plans from JSON schemas involves defining declarative models for tables, columns, and constraints, then diffing them against applied migrations to produce typed MigrationAction sequences and SQL.

What is declarative database modeling with JSON?

Declarative database modeling with JSON is the process of describing database schemas, including tables, columns, constraints, and ENUM types, in JSON format to validate schemas and automatically emit SQL for migrations.

Does this JSON schema migration approach support PostgreSQL, MySQL, and SQLite?

Yes, the JSON schema migration workflow supports PostgreSQL, MySQL, and SQLite, enabling end-to-end ORM export and multi-database workflows for declarative schema management.

How do I create and apply a new schema migration using a diff-based approach?

To create and apply a schema migration, initialize your project, define your JSON models, run a diff to generate typed MigrationAction steps, and use the revision command to apply the generated SQL.

Can I validate JSON database schemas and get IDE autocompletion?

Yes, JSON Schema validation provides IDE autocompletion and validation for your declarative database models, ensuring your table, column, and constraint definitions are correctly structured before migration planning.

What's the best way to diff database schemas for automatic migration generation?

The best way to diff database schemas for automatic migration generation is using a declarative JSON toolchain that compares your current model definitions against previously applied migrations to derive typed action sequences.