skills.rest
figulazmi
figulazmiCOMMUNITY
Explore all skills by this author →
GitHub

Backend Database Expert

Design database schemas and migration plans for PostgreSQL, MySQL, and ORMs.

Updated Apr 11, 2026
Search Tags:#database#optimization#migration#sql#orm#zero-downtime
One-click install
npx skills add https://github.com/figulazmi/token-monitor --skill backend-database-expert-figulazmi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Backend Database Expert
Source: https://github.com/figulazmi/token-monitor/tree/main/.agents/skills/backend-database-expert
Command: npx skills add https://github.com/figulazmi/token-monitor --skill backend-database-expert-figulazmi

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides expert guidance for designing robust database schemas, optimizing queries, and planning safe migrations across ORMs, helping teams reduce downtime and improve data integrity.

Core Features & Use Cases

  • Database design guidance for scalable schemas and data normalization.
  • SQL optimization patterns, index strategies, and migration planning with rollback and zero-downtime considerations.
  • ORM migration support across Sequelize, TypeORM, and Prisma, including cross-database migrations and data transformations.
  • Use cases: migrating a production schema with minimal downtime, optimizing complex queries, and safely evolving data models.

Quick Start

Add a new nullable column 'middle_name' to a users table with a zero-downtime migration plan and validate via a safe rollback.

Frequently Asked Questions about Backend Database Expert

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

FAQPage Schema
How do I plan a zero-downtime database migration for a production schema?▼

Zero-downtime database migrations require adding nullable columns, backfilling data asynchronously, and applying validation steps with rollback strategies to ensure safe schema evolution without disrupting production environments.

What is the best way to optimize SQL queries and indexes for PostgreSQL and MySQL?▼

Optimizing SQL queries requires applying SQL optimization patterns and index strategies to reduce query latency and improve data integrity across PostgreSQL and MySQL databases.

Does this database migration approach work with ORMs like TypeORM, Sequelize, and Prisma?▼

Yes, this database migration approach supports ORMs like TypeORM, Sequelize, and Prisma, providing cross-database migration and data transformation capabilities while maintaining compatibility across diverse environments.

How do I design robust database schemas with proper data normalization?▼

Designing robust database schemas with proper data normalization requires following expert guidance for building scalable schemas that enforce data integrity hardening and structured schema evolution across diverse environments.

What are the limitations of performing ORM migrations without a rollback strategy?▼

Performing ORM migrations without a rollback strategy risks failing to ensure data integrity and safe schema evolution, potentially causing irreversible data loss and breaking compatibility during cross-database migrations in production.

Related Skills

Explore More Software Engineering Skills→
WesleySmitsWesleySmits
6

managing-database-schemas

Analyze database schemas and generate improvement recommendations for Prisma, TypeORM, or Drizzle.

Community
Advanced
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced
frankxaifrankxai
7

database-migrations

Manage database schema evolution with Prisma and Drizzle ORM.

Community
Advanced
Fantasia1999Fantasia1999

database-designer

Analyzes SQL DDL schemas and generates zero-downtime migration scripts.

Community
Advanced