skills.rest
xinbenlv
xinbenlvCOMMUNITY
Explore all skills by this author →
Website𝕏@ZainanZhouGitHub

codereview-data

Review database migrations, models, repositories, and queries for safety and integrity.

8|Updated Jan 14, 2026
Search Tags:#rollback#database#migrations#queries#data-integrity#analyze
One-click install
npx skills add https://github.com/xinbenlv/codereview-skills --skill codereview-data
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: codereview-data
Source: https://github.com/xinbenlv/codereview-skills/tree/main/skills/codereview-data
Command: npx skills add https://github.com/xinbenlv/codereview-skills --skill codereview-data

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps software teams ensure database changes are safe, reversible, and data-consistent during code reviews and migrations.

Core Features & Use Cases

  • Migration Safety: Review rollback strategies and backfill plans to avoid production incidents.
  • Query Analysis: Identify potential performance and safety issues in data access.
  • Data Integrity: Validate constraints, relations, and transactional boundaries across schemas.

Quick Start

Provide a migration snippet or schema change to receive a safety assessment and actionable recommendations.

Frequently Asked Questions about codereview-data

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

FAQPage Schema
How do I check database migration safety before deploying schema changes?▼

Database migration safety is verified by analyzing rollback strategies and backfill plans to prevent production incidents. This process enforces transactional boundaries and constraint checks across codebases to ensure data consistency and reversibility during schema updates.

What is the best way to review database queries for potential data integrity issues?▼

Reviewing database queries for data integrity involves analyzing data access patterns to identify performance and safety issues. This approach validates constraints, relations, and transactional boundaries across production schemas to maintain consistent data persistence.

How do I ensure rollback feasibility when modifying database models and repositories?▼

Rollback feasibility is ensured by analyzing migration operations and enforcing reversal strategies during code reviews. This validates that schema changes and model updates maintain data integrity and can safely revert if production issues occur.

Can I use automated analysis to review backfill planning for large database migrations?▼

Automated analysis reviews backfill planning by assessing migration snippets and schema changes for safety. It evaluates transactional boundaries and constraint checks to ensure data consistency when applying large data updates across production schemas.

When do I need to validate transactional boundaries in database code reviews?▼

Transactional boundaries need validation during database code reviews when queries and models modify data persistence. Checking these boundaries ensures data integrity and prevents partial updates from corrupting relations across production schemas.

Related Skills

Explore More Software Engineering Skills→
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
rodrigobranasrodrigobranas
1

drizzle-safe-migrations

Plan and execute Drizzle migrations with data backfills and rollback notes.

Community
Advanced
AskTinNguyenAskTinNguyen

github-credential-hardening

Detect and remediate GitHub credential leakage in code and configuration.

Community
Advanced
pacphipacphi
6

database-testing

Validate database schemas, data integrity, migrations, and ACID properties.

Community
Intermediate