database-engineering

Design and optimize relational database schemas, indexes, and migrations.

Updated May 6, 2026

Search Tags:#performance #indexing #database #postgresql #migrations #schema #sql

Ready to run

npx skills add https://github.com/Abdullahmohammadaref/acar --skill database-engineering-abdullahmohammadaref

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-engineering
Source: https://github.com/Abdullahmohammadaref/acar/tree/main/.agents/skills/database-engineering
Command: npx skills add https://github.com/Abdullahmohammadaref/acar --skill database-engineering-abdullahmohammadaref

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Design and optimize relational databases with a disciplined framework covering schema design, indexing strategies, safe migrations, and performance tuning.

Core Features & Use Cases

Schema design and normalization guidance with recommended indexes
Safe migrations with reversible steps and zero-downtime patterns
Performance optimization using indexing, partitioning, and configuration tuning for OLTP and analytics

Quick Start

Analyze a production schema and propose a normalized design with appropriate indexes and a migration plan.

Frequently Asked Questions about database-engineering

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

FAQPage Schema

How do I design a normalized PostgreSQL schema with appropriate indexes?▼

Schema design applies normalization-first principles to structure relational tables, then recommends appropriate indexing strategies to optimize query performance and maintain data integrity.

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

Safe database migrations use reversible steps and zero-downtime patterns to apply schema changes without locking tables, ensuring production systems remain available during the deployment process.

How does EXPLAIN ANALYZE help with SQL performance tuning?▼

EXPLAIN ANALYZE measures actual SQL query execution times and scan methods, providing the careful performance measurement needed to identify bottlenecks and validate indexing or partitioning strategies.

Can I optimize analytics workloads and OLTP databases using the same indexing strategy?▼

OLTP and analytics workloads require different indexing and partitioning strategies, balancing transactional speed against analytical query throughput via configuration tuning tailored to the specific workload.

When do I need partitioning for database performance optimization?▼

Database performance optimization requires partitioning when managing large analytics workloads, splitting massive tables into smaller segments to improve query speed and maintain efficient data migrations.