skills.rest
weirdgme
weirdgmeCOMMUNITY
Explore all skills by this author →
𝕏@weirdgmeGitHub

Database Engineering

Guide PostgreSQL and MySQL administration with structured procedures for tuning, replication, backups, and migrations.

4|Updated Nov 1, 2025
Search Tags:#performance#indexing#database#PostgreSQL#backup#MySQL#replication
One-click install
npx skills add https://github.com/weirdgme/Claude-code-infrastructure-showcase --skill database-engineering
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Engineering
Source: https://github.com/weirdgme/Claude-code-infrastructure-showcase/tree/main/.claude/skills/database-engineering
Command: npx skills add https://github.com/weirdgme/Claude-code-infrastructure-showcase --skill database-engineering

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Teams often face bottlenecks managing PostgreSQL/MySQL at scale. This Skill provides structured guidance to simplify administration, optimization, and maintenance across databases.

Core Features & Use Cases

  • Best practices for installation, configuration, tuning, and maintenance across PostgreSQL and MySQL.
  • Use Cases: performance optimization, replication planning, backups, migrations, and configuration reviews across development to production.
  • Standardized procedures and references to keep databases healthy, scalable, and auditable.

Quick Start

Run the built-in database administration checklist against your environment to begin applying best practices, including checking max_connections, autovacuum settings, replication needs, and automated backup configurations.

Frequently Asked Questions about Database Engineering

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

FAQPage Schema
How do I tune PostgreSQL performance for high traffic workloads?▼

Plan PostgreSQL and MySQL replication by following standardized procedures for configuration and maintenance, ensuring databases remain healthy and scalable across development through production environments.

What is the best way to automate MySQL backups in production?▼

Automate MySQL backups using standard database tooling and documented procedures, running built-in administration checklists to verify automated backup configurations and keep databases auditable and healthy.

Can I use standard database tooling for PostgreSQL migrations, or do I need specialized software?▼

Relational database indexing for performance optimization involves applying best practices for configuration and tuning, using standardized procedures to address bottlenecks and keep PostgreSQL and MySQL databases scalable.

Why does PostgreSQL experience administrative bottlenecks at scale and how do I fix them?▼

PostgreSQL administrative bottlenecks at scale happen when configuration and maintenance lack structure; fix them by applying best practices for tuning, replication planning, backups, and configuration reviews using standardized procedures.

Related Skills

Explore More Software Engineering Skills→
ariesanhthuariesanhthu

postgres-expert

Optimize PostgreSQL queries, indexing, JSONB, partitioning, and replication.

Community
Advanced
louloulinlouloulin
19

database-migrator

Plan and execute zero-downtime database migrations across PostgreSQL, MySQL, and SQLite.

Community
Intermediate
sitharaj88sitharaj88
1

db-mysql

Generate MySQL schemas, queries, indexes, and tuning configurations.

Community
Advanced
MovchanetsMovchanets

database-admin

Plan and validate database administration workflows for cloud and self-managed environments.

Community
Advanced