skills.rest
linenoize
linenoizeCOMMUNITY
Explore all skills by this author →
GitHub

db

Generate rollback-aware database migration files and validate schema changes.

1|Updated May 18, 2026
Search Tags:#indexing#rollback#database#migrations#schema#orm
One-click install
npx skills add https://github.com/linenoize/topia --skill db-linenoize
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db
Source: https://github.com/linenoize/topia/tree/main/skills/db
Command: npx skills add https://github.com/linenoize/topia --skill db-linenoize

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill prevents risky database changes from reaching production by reviewing schema diffs, identifying breaking changes, and generating migrations with rollback paths.

Core Features & Use Cases

  • Migration Generation: Creates up and down migration scripts for common ORM and raw SQL workflows.
  • Breaking Change Detection: Flags destructive schema edits such as dropped columns, renamed tables, and unsafe not null additions.
  • Index and Query Safety: Recommends missing indexes and scans SQL for parameterization issues before deployment.
  • Use Case: When a table schema changes, it can produce the migration plan, warn about user-impacting changes, and document the rollout and rollback steps.

Quick Start

Ask the db skill to review your schema changes, generate a safe migration plan, and report any breaking changes or missing indexes.

Frequently Asked Questions about db

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

FAQPage Schema
How do I generate safe database migrations with rollback paths?▼

Safe database migrations are generated by analyzing schema diffs and creating paired up and down migration scripts with rollback verification. This process validates schema changes and ensures rollback paths are safe before deployment.

What breaking schema changes should I detect before deploying database migrations?▼

Breaking schema changes to detect include dropped columns, renamed tables, and unsafe not null additions. Identifying these destructive schema edits prevents risky database changes from impacting production environments during migrations.

Can I use this migration generation tool with both ORM and raw SQL workflows?▼

Migration generation supports both ORM and raw SQL workflows through automatic ORM detection. It produces syntax-safe SQL and validated migration scripts compatible with your specific database workflow configuration.

How does index analysis improve database migration safety?▼

Index analysis improves database migration safety by recommending missing indexes and scanning SQL for parameterization issues before deployment. This query safety validation catches potential performance and injection risks early.

What is the best way to validate schema changes before a database deployment?▼

Validating schema changes before database deployment requires classifying breaking changes, generating rollback-aware migrations, and verifying SQL syntax safety. This comprehensive validation documents rollout steps while preventing destructive schema edits.

Related Skills

Explore More Software Engineering Skills→
qauth-labsqauth-labs
23

schema

Define PostgreSQL schema rules for QAuth user and credential models.

Official
Basic
cwinvestmentscwinvestments
412

migration-planner

Generate database schema migration scripts with rollback strategies.

Community
Advanced
MileniumTickMileniumTick

drizzle-orm

Enable type-safe SQL querying in TypeScript with zero runtime overhead.

Community
Advanced
ntaksh42ntaksh42
1

database-migration-generator

Generate SQL and TypeORM database migration scripts with rollback support.

Community
Intermediate