skills.rest
GDSDN
GDSDNCOMMUNITY
Explore all skills by this author →
GitHub

db-dry-run

Validate SQL migration scripts in transactional rollback blocks.

3|Updated Feb 7, 2026
Search Tags:#database#postgresql#validation#migration#sql#dry-run
One-click install
npx skills add https://github.com/GDSDN/kord-aios --skill db-dry-run
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-dry-run
Source: https://github.com/GDSDN/kord-aios/tree/main/src/features/builtin-skills/kord-aios/database/db-dry-run
Command: npx skills add https://github.com/GDSDN/kord-aios --skill db-dry-run

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill prevents potential database corruption and downtime by validating SQL migration scripts in a safe, transactional environment before they are permanently applied.

Core Features & Use Cases

  • Syntax Validation: Checks for errors in SQL syntax and PostgreSQL compatibility.
  • Dependency Checking: Ensures that referenced tables, functions, and objects exist in the correct order.
  • Transaction Rollback: Executes migrations within a BEGIN...ROLLBACK block, ensuring no permanent changes are made during the dry-run.
  • Use Case: Before deploying a new feature that requires database schema changes, use this Skill to ensure the migration script is error-free and won't break the production database.

Quick Start

Run a dry-run of the migration script located at 'migrations/001_create_users_table.sql'.

Frequently Asked Questions about db-dry-run

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

FAQPage Schema
How do I validate SQL migration scripts without modifying the database?▼

Validate SQL migration scripts safely by executing them within a transactional BEGIN...ROLLBACK block that catches syntax, ordering, and constraint errors before permanent application to the database.

What does a database dry run check for in PostgreSQL migrations?▼

A database dry run checks PostgreSQL migrations for SQL syntax errors, dependency ordering issues, and constraint violations, ensuring referenced tables and objects exist before you apply schema changes.

Can I run database migration validation automatically or does it require manual review?▼

Database migration validation supports both interactive and autonomous modes for error detection and reporting, allowing you to catch schema migration issues automatically or review them manually.

When should I use a transaction rollback to test database schema changes?▼

Use a transaction rollback to test database schema changes before deploying new features, ensuring your migration script is error-free and will not cause database corruption or downtime.

Related Skills

Explore More Software Engineering Skills→
ahiendzahiendz
3

comparing-database-schemas

Compare PostgreSQL or MySQL schemas and generate transactional migration scripts.

Community
Advanced
manhthien2005manhthien2005

db-migrate

Generate and validate Drizzle Postgres migrations for FixNow schema changes.

Community
Advanced
ponkotuyponkotuy
3

release

Automate GitHub release creation, version tagging, and deployment status reporting.

Community
Advanced
Holo00Holo00
6

database-changes

Generate idempotent SQL migrations for IdeaForge database schema changes.

Community
Intermediate