skills.rest
MotWakorb
MotWakorbCOMMUNITY
Explore all skills by this author →
GitHub

database-engineer

Apply schema design, migrations, indexing, and backup strategies for PostgreSQL databases.

2|Updated Apr 19, 2026
Search Tags:#indexing#database#postgresql#migrations#data-integrity#query-performance#schema-design
One-click install
npx skills add https://github.com/MotWakorb/claude-agent-dev-team --skill database-engineer-motwakorb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-engineer
Source: https://github.com/MotWakorb/claude-agent-dev-team/tree/main/database-engineer
Command: npx skills add https://github.com/MotWakorb/claude-agent-dev-team --skill database-engineer-motwakorb

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database integrity and performance issues are addressed by this skill, ensuring consistent schema, safe migrations, and optimized queries.

Core Features & Use Cases

  • Data integrity enforcement with constraints, normalization, and transactional guarantees
  • Performance design with indexing strategies, pagination, and query plan analysis
  • Migration safety practices including reversible migrations and zero-downtime techniques
  • Data modeling and schema design guidance for PostgreSQL and multi-database setups
  • Backup, replication, and recovery planning to maintain resilience

Quick Start

Run EXPLAIN ANALYZE on a representative query against your dataset to verify performance.

Frequently Asked Questions about database-engineer

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

FAQPage Schema
How do I optimize slow PostgreSQL query performance?▼

To optimize PostgreSQL query performance, run EXPLAIN ANALYZE on representative queries to verify execution plans. This skill applies indexing strategies and query plan analysis to resolve bottlenecks and ensure fast database operations.

What is the best way to execute zero-downtime database migrations?▼

Zero-downtime database migrations require reversible migration scripts and explicit safety guardrails. This skill provides migration safety practices to apply schema changes without disrupting active database operations.

How do I enforce data integrity in a relational database schema?▼

Data integrity in a relational database is enforced using constraints, normalization, and transactional guarantees. This skill guides schema design to maintain consistent data across PostgreSQL and multi-database environments.

Can I apply this schema design and indexing approach to multi-database setups?▼

Yes, you can apply this schema design and indexing approach to multi-database setups. It handles data modeling, replication, and backup strategies across PostgreSQL and other relational database environments.

Why do I need to run EXPLAIN ANALYZE before deploying schema changes?▼

You need to run EXPLAIN ANALYZE before deploying schema changes to rigorously validate query performance. This verification step prevents unexpected bottlenecks and ensures indexing strategies actually improve execution plans.

How do I plan database backup and replication for disaster recovery?▼

Planning database backup and replication for disaster recovery involves configuring resilience strategies to maintain data availability. This skill provides backup and recovery planning to protect data integrity during failures.

Related Skills

Explore More Software Engineering Skills→
jeremylongshorejeremylongshore
2.6k

analyzing-query-performance

Analyze EXPLAIN plans and query metrics to identify database bottlenecks.

Community
Intermediate
zinohomezinohome
1

db-performance-watchlist

Monitor database performance with slow query detection and resource alerts.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
tuyenhttuyenht

NoSQL Patterns

Provide expert patterns for optimizing MongoDB, Redis, and DynamoDB databases.

Community
Intermediate