db

Generate and validate database schema migrations for ORMs and raw SQL.

82|23|Updated Feb 24, 2026
One-click install
npx skills add https://github.com/Rune-kit/rune --skill db-rune-kit
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db
Source: https://github.com/Rune-kit/rune/tree/main/skills/db
Command: npx skills add https://github.com/Rune-kit/rune --skill db-rune-kit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill prevents production incidents caused by database schema changes by automating migration file generation, detecting breaking changes, and ensuring query safety.

Core Features & Use Cases

  • Automated Migration Generation: Creates up and down migration scripts for various ORMs (Prisma, TypeORM, SQLAlchemy, etc.) and raw SQL.
  • Breaking Change Detection: Identifies risky schema modifications like adding NOT NULL columns without defaults or dropping tables.
  • Query Analysis: Scans for SQL injection vulnerabilities and recommends missing indexes for performance.
  • Use Case: Before deploying a new feature that modifies the user table, run this Skill to automatically generate the migration, flag a column rename as a breaking change requiring confirmation, and ensure the new avatar_url column is nullable.

Quick Start

Use the db skill to analyze schema changes in the current git diff and generate migration files.

Frequently Asked Questions about db

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

FAQPage Schema
How do I automate database schema migration and detect breaking changes?

Automating database schema migration detects breaking changes like dropping tables or adding NOT NULL columns without defaults. This process generates up and down migration scripts while identifying risky modifications to prevent production incidents before deployment.

How does SQL injection scanning work during database migration generation?

SQL injection scanning during migration generation analyzes raw SQL and ORM queries for security vulnerabilities. It inspects schema changes to identify unsafe query patterns and recommends missing indexes to enforce query safety and improve performance.

Does this database migration tool support Prisma, TypeORM, and SQLAlchemy?

Yes, database migration generation supports Prisma, TypeORM, SQLAlchemy, and raw SQL. It automatically creates up and down migration scripts tailored to the specific ORM framework used in your project.

What is the best way to enforce rollback script creation for schema migrations?

The best way to enforce rollback script creation is automating migration generation to produce paired up and down scripts. This ensures every schema modification includes a verified rollback path to prevent irreversible database changes.

Can I integrate schema validation as a pre-deploy gate in CI/CD pipelines?

Yes, schema validation integrates directly into CI/CD pipelines as a pre-deploy gate for database modifications. It analyzes git diffs to block deployments containing breaking schema changes or SQL injection risks.

Why do I need to flag column renames as breaking changes during schema migration?

You need to flag column renames as breaking changes because they can break existing application queries. Automated migration validation detects these risky modifications and requires explicit confirmation before proceeding with the schema update.