database-review

Review database schemas, migration files, and query performance.

1|Updated Apr 29, 2026

Search Tags:#performance #schema design #database #migration #review

Ready to run

npx skills add https://github.com/sigmadigitalza/engineering-playbook --skill database-review-sigmadigitalza

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-review
Source: https://github.com/sigmadigitalza/engineering-playbook/tree/main/plugins/sigma-engineering/skills/database-review
Command: npx skills add https://github.com/sigmadigitalza/engineering-playbook --skill database-review-sigmadigitalza

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides in-depth reviews of database operations, ensuring schema, migrations, and performance are optimized for reliability and efficiency.

Core Features & Use Cases

Schema Design Review: Audits proposed schemas for correctness and efficiency.
Migration Review: Ensures migrations are safe for production deployment.
Performance Review: Identifies slow queries and suggests index optimizations.
Use Case: Use this Skill to review a migration file before deployment, ensuring it won't disrupt service.

Quick Start

Use the database-review skill to analyze the provided migration file for potential issues.

Frequently Asked Questions about database-review

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

FAQPage Schema

How do I check if a database migration is safe for production?▼

To check if a database migration is safe for production, you need a migration review that analyzes the file for operations that might lock tables or cause downtime. This ensures deployment reliability and prevents service disruptions.

What is database schema design review and when do I need it?▼

Database schema design review is an audit of your proposed data structures for correctness and efficiency. You need it when designing new tables to ensure your schema is optimized before implementation begins.

How do I optimize slow database queries?▼

To optimize slow database queries, perform a query performance review that identifies bottlenecks and suggests index optimizations. This process targets inefficient lookups and improves database retrieval speed.

Can I analyze a migration file for potential issues before deployment?▼

Yes, you can analyze a migration file for potential issues before deployment by running a database review. This examines the migration strategy to ensure it will not disrupt production services during execution.

What's the best way to review database operations for reliability?▼

The best way to review database operations for reliability is a comprehensive review covering schema, migrations, and performance. This ensures all aspects are optimized for efficiency and safe production deployment.

Why does my database migration disrupt service?▼

Your database migration disrupts service because it likely contains unsafe operations like large table locks. A migration review identifies these risky commands and suggests safer deployment strategies.