skills.rest
jeffabailey
jeffabaileyCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

review-data

Analyze database schema design, migration safety, and query correctness with evidence.

3|Updated Feb 21, 2026
Search Tags:#schema design#database migration#data integrity#data quality#data pipeline#query analysis
One-click install
npx skills add https://github.com/jeffabailey/skills --skill review-data
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: review-data
Source: https://github.com/jeffabailey/skills/tree/main/src/review-data
Command: npx skills add https://github.com/jeffabailey/skills --skill review-data

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps you identify and fix critical issues in your database schemas, migrations, queries, and data pipelines, preventing data loss, corruption, and incorrect analysis.

Core Features & Use Cases

  • Schema Design Audit: Evaluates table structures, column types, and constraints for best practices.
  • Migration Safety Checks: Assesses the risk of your database migration scripts causing downtime or data loss.
  • Query Correctness Analysis: Reviews SQL queries and ORM patterns for logical errors and performance pitfalls.
  • Pipeline Quality Assessment: Examines data pipelines for idempotency, error handling, and monitoring.
  • Use Case: Before deploying a new feature that modifies your core user data, run this Skill to ensure your schema changes are safe, your migrations won't break production, and your queries are correct.

Quick Start

Use the review-data skill to analyze the database schema and migration files in the current project.

Frequently Asked Questions about review-data

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

FAQPage Schema
How do I check if my database schema design follows best practices?▼

Database schema design audits evaluate table structures, column types, and constraints, producing fitness scores from 1-10 with file:line evidence to highlight structural weaknesses and ensure data integrity.

What is the best way to assess database migration safety before deploying?▼

Assess database migration safety by analyzing migration scripts for risks of downtime or data loss, producing a fitness score with specific file and line evidence to ensure production stability.

How does query correctness analysis identify logical errors in SQL?▼

Query correctness analysis reviews SQL queries and ORM patterns to detect logical errors and performance pitfalls, scoring correctness from 1-10 and providing file:line evidence for identified issues.

Can I use this to examine data pipelines for idempotency and error handling?▼

Yes, data pipeline quality assessment examines pipelines specifically for idempotency, error handling, and monitoring, generating a fitness score with file:line evidence to ensure pipeline reliability.

Does this data review process check query performance or schema correctness?▼

This data review process specifically checks schema correctness, migration safety, and data integrity, distinguishing itself from performance reviews by focusing on whether the schema and queries are fundamentally correct.

Related Skills

Explore More Software Engineering Skills→
zhangzhang-111-izhangzhang-111-i
2

database-designer

Analyzes SQL/JSON schemas and generates optimized migration scripts.

Community
Advanced
RyoOsakaRyoOsaka

migration

Generate and apply Drizzle ORM database migrations from TypeScript schema changes.

Community
Intermediate
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
hiddink-aihiddink-ai
1

alembic-best-practices

Standardize SQLAlchemy database migrations with safe schema evolution patterns.

Official
Advanced