skills.rest
Abdullahmohammadaref
AbdullahmohammadarefCOMMUNITY
Explore all skills by this author →
GitHub

database-engineering

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

Updated May 6, 2026
Search Tags:#performance#indexing#database#postgresql#migrations#schema#sql
One-click install
npx skills add https://github.com/Abdullahmohammadaref/acar --skill database-engineering-abdullahmohammadaref
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
DauQuangThanhDauQuangThanh
14

database-design

Design relational and NoSQL database schemas from business requirements.

Community
Advanced
christopherclemmonschristopherclemmons

postgresql

Design and optimize PostgreSQL schemas, queries, indexes, and migrations.

Community
Advanced
monobaselabsmonobaselabs

db-migrate

Generate and apply Drizzle ORM migrations for Bun-based services.

Official
Advanced
devCharuzudevCharuzu

database-designer

Design database schemas with normalization checks and ERD generation.

Community
Advanced