skills.rest
sigmadigitalza
sigmadigitalzaOFFICIAL
Explore all skills by this author →
WebsiteGitHub

database-review

Review database schemas, migration files, and query performance.

1|Updated Apr 29, 2026
Search Tags:#performance#schema design#database#migration#review
One-click install
npx skills add https://github.com/sigmadigitalza/engineering-playbook --skill database-review-sigmadigitalza
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
tedtv1007-ctrltedtv1007-ctrl

postgresql-optimization

Analyze PostgreSQL execution plans and schema definitions to recommend query and index optimizations.

Community
Advanced
rdimasciordimascio

optimize-queries

Analyze EXPLAIN ANALYZE outputs and optimize Supabase PostgreSQL queries.

Community
Advanced
SamuelSahaSamuelSaha

CI/CD Pipeline Mastery

Automate CI/CD for web apps with GitHub Actions and Vercel.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

optimizing-sql-queries

Analyze SQL queries and generate index recommendations and query rewrites.

Community
Intermediate