database-engineer

Name: database-engineer
Availability: InStock
Author: motwakorb

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

Ready to run

npx skills add https://github.com/MotWakorb/claude-agent-dev-team --skill database-engineer-motwakorb

💬 Prompt for ChatGPT / Claude Chat▼

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.