skills.rest
PAISHU-AI
PAISHU-AICOMMUNITY
Explore all skills by this author →
GitHub

database-pro

Guide SQL database schema design, migrations, indexing, and query optimization.

Updated Aug 23, 2026
Search Tags:#database design#query optimization#indexing#data integrity#transaction management
One-click install
npx skills add https://github.com/PAISHU-AI/PAI-zong-NB --skill database-pro
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-pro
Source: https://github.com/PAISHU-AI/PAI-zong-NB/tree/main/skills/26-database-pro
Command: npx skills add https://github.com/PAISHU-AI/PAI-zong-NB --skill database-pro

SYSTEM DOCUMENTATION & REQUIREMENTS

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

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.

Frequently Asked Questions about database-pro

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

FAQPage Schema
How do I optimize SQL query performance for a large PostgreSQL database?▼

To optimize SQL query performance, you need to design indexes based on your specific data access patterns and review query execution plans. This Skill provides guidance on indexing strategies and query tuning to improve database retrieval speed.

What's the best way to plan a database migration with rollback strategies?▼

Planning a database migration requires compatibility checks and defining clear rollback strategies to ensure data integrity. This Skill assists in planning and executing migrations safely across various SQL database engines and ORMs.

How do I define transaction boundaries and isolation levels in SQL?▼

Defining transaction boundaries and isolation levels in SQL involves specifying the start and end points of database operations to maintain consistency. This Skill assists in structuring transaction management to protect data integrity.

How to design a database schema with primary keys, foreign keys, and constraints?▼

Designing a database schema with constraints involves structuring primary and foreign keys, unique fields, and default values to enforce data integrity. This Skill supports comprehensive schema design across various SQL database technologies.

Does this database design guidance work with different SQL database engines and ORMs?▼

Yes, the database design guidance covers schema creation, indexing, and migration planning across various SQL database engines and ORMs. It provides generalized strategies for constraints, transactions, and query optimization.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced
nimadorostkarnimadorostkar
25

django

Optimize Django ORM queries and enforce database-level constraints.

Community
Advanced
Geralt1983Geralt1983
1

Database Designer

Design relational and NoSQL database schemas with normalization and indexing guidance.

Community
Advanced