database

Automate database schema design and migration tracking across environments.

4|2|Updated Sep 17, 2025
One-click install
npx skills add https://github.com/SylphxAI/flow --skill database-sylphxai
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/SylphxAI/flow/tree/main/.claude/skills/database
Command: npx skills add https://github.com/SylphxAI/flow --skill database-sylphxai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database teams often contend with drift between environments, untracked migrations, and inconsistent schemas. This Skill provides a disciplined approach to schema design, migration versioning, and indexing decisions to keep databases aligned and maintainable.

Core Features & Use Cases

  • Schema design & versioning: Plan and evolve tables with tracked migrations, constraints, and relationships.
  • Migration governance: Ensure migrations are committed, reviewed, and reflected across development, staging, and production environments.
  • Index optimization and performance: Propose and validate indexes to maintain query performance as schemas evolve.
  • Use Case: When shipping a feature that touches several tables, generate a safe migration plan and verify environment parity.

Quick Start

Use the database skill to generate a new migration for adding a users table and verify it is committed and represented in CI.

Frequently Asked Questions about database

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

FAQPage Schema
How do I prevent database schema drift between development, staging, and production?

Schema drift occurs when environments diverge due to untracked changes. This Skill automates migration versioning and CI checks to enforce consistency, ensuring all schema changes are committed, reviewed, and applied deterministically across all environments.

What's the best way to version and track database migrations?

Migration versioning maintains a complete audit trail of schema changes. This Skill generates tracked migration files, validates them in CI, and ensures they're reflected consistently across environments so deployments remain predictable and rollback-safe.

How do I optimize database indexes as my schema evolves?

Index performance degrades as schemas change and data grows. This Skill proposes and validates indexes alongside schema migrations, maintaining query performance and preventing the performance regressions that typically accompany schema evolution.

Can I use this for managing schema changes across multiple environments?

Yes. This Skill is designed for multi-environment schema governance, enforcing that migrations are committed, reviewed, and reflected in development, staging, and production to eliminate environment parity issues and drift.

How do I generate a safe migration plan when shipping features that touch multiple tables?

Multi-table changes require coordinated migrations. This Skill generates migration plans that handle constraints and relationships across tables, verifies environment parity, and ensures the feature ships with consistent schema state everywhere.

Why should migrations be committed and reviewed in CI?

Committed, reviewed migrations create accountability and catch schema inconsistencies before deployment. This Skill enforces CI checks on migration files so breaking changes, missing constraints, and untracked drift are caught early.