skills.rest
takemo101
takemo101COMMUNITY
Explore all skills by this author →
GitHub

database-reviewer

Reviews SQL migrations, Prisma schemas, and entity TypeScript files for design, performance, safety, and consistency.

Updated Jan 8, 2026
Search Tags:#performance#database#schema#migration#review#dba
One-click install
npx skills add https://github.com/takemo101/compose-workflow --skill database-reviewer-takemo101
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-reviewer
Source: https://github.com/takemo101/compose-workflow/tree/main/.pi/skills/database-reviewer
Command: npx skills add https://github.com/takemo101/compose-workflow --skill database-reviewer-takemo101

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill ensures the quality, performance, and safety of your database schemas and migration scripts, preventing costly errors and performance bottlenecks.

Core Features & Use Cases

  • Schema Design Review: Analyzes data types, normalization, and constraints for robust database structures.
  • Performance Optimization: Identifies missing indexes and potential query inefficiencies.
  • Migration Safety: Assesses downtime risks, rollback strategies, and potential data loss during schema changes.
  • Use Case: Before deploying a new feature that modifies the user table, use this Skill to review the proposed migration script and schema changes, ensuring it won't cause performance degradation or data corruption.

Quick Start

Review the database schema and migration files for potential issues.

Frequently Asked Questions about database-reviewer

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

FAQPage Schema
How do I review database migration scripts for downtime risks?▼

Reviewing database migration scripts for downtime risks involves assessing rollback strategies, potential data loss, and locking behaviors. This Skill evaluates SQL migration files against strict criteria to ensure schema changes are safe to deploy without performance degradation.

What is the best way to check Prisma schema definitions for performance issues?▼

Checking Prisma schema definitions for performance requires analyzing data types, constraints, and indexing strategies. This Skill reviews entity definitions and identifies missing indexes or potential query inefficiencies to optimize database structures before deployment.

Can I use an automated DBA review for TypeScript entity files?▼

Yes, you can perform an automated DBA review on TypeScript entity files. This Skill targets TypeScript entity definitions alongside SQL and Prisma schemas, checking them against defined criteria for design consistency, indexing, and naming conventions.

How does a point-based system work for database schema review?▼

A point-based system for database schema review evaluates specific aspects like indexing, locking, and rollback strategies against strict pass/fail criteria. This Skill uses this mechanism to quantify design, performance, and safety issues within your migration scripts and schemas.

When do I need to review database schemas for locking and rollback strategies?▼

You need to review database schemas for locking and rollback strategies before deploying schema changes that modify critical tables like the user table. This ensures migrations do not cause performance bottlenecks, data corruption, or unintended locking conflicts during production deployment.

Related Skills

Explore More Software Engineering Skills→
FiventsFivents

project-analyzer

Analyze the ONE-ID codebase to extract architecture, data models, and operational flows.

Official
Advanced
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced
mozillamozilla
10

sql-test-generator

Generate BigQuery SQL unit test fixtures with YAML inputs and outputs.

Official
Basic
linenoizelinenoize
1

db

Generate rollback-aware database migration files and validate schema changes.

Community
Advanced