database-pro

What problem does it solve?

This Skill addresses the complexities of database design, migration, transaction management, indexing, query optimization, and data integrity for SQL databases and ORMs, enabling efficient schema design, migrations, index creation, constraints, query performance tuning, and data modeling across various database technologies.

Core Features & Use Cases

• Database Design: Supports schema design with constraints for primary and foreign keys, unique fields, and default values.
• Indexing & Query Optimization: Offers guidance on designing indexes based on access patterns and optimizing query performance.
• Transaction Management: Assists in defining transaction boundaries and isolation levels.
• Migration Planning: Provides guidance on planning and executing migrations with rollback strategies and compatibility checks.
• Use Case: A developer can use this Skill to design a new database schema, create indexes for a large dataset, or plan a migration from one database version to another.

Quick Start

Run the database-pro Skill to review the indexing and query performance for a PostgreSQL database.