database-ops

Automate database administration tasks across PostgreSQL, MySQL, Redis, and MongoDB.

3|Updated Mar 5, 2026
One-click install
npx skills add https://github.com/bipinks/ghost-office --skill database-ops-bipinks
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-ops
Source: https://github.com/bipinks/ghost-office/tree/main/.claude/skills/database-ops
Command: npx skills add https://github.com/bipinks/ghost-office --skill database-ops-bipinks

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates database administration tasks including performance tuning, migrations, backup/restore, replication setup, index optimization, connection pooling, and maintenance windows across PostgreSQL, MySQL, Redis, and MongoDB. This reduces manual toil and risk in complex production environments by providing repeatable, auditable procedures.

Core Features & Use Cases

  • Performance tuning and configuration optimization for major databases (PostgreSQL, MySQL, Redis, MongoDB).
  • Zero-downtime migrations, safe schema changes, and backup/restore workflows.
  • Best practices for indexing, replication, monitoring, and maintenance scheduling in live systems.

Quick Start

Review the guide and apply recommended PostgreSQL or Redis tuning and zero-downtime migration patterns to your database cluster.

Frequently Asked Questions about database-ops

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

FAQPage Schema
How do I perform zero-downtime database migrations across PostgreSQL and MySQL?

Zero-downtime database migrations require repeatable, auditable procedures that apply safe schema changes without interrupting live operations. This approach handles migration workflows across PostgreSQL, MySQL, Redis, and MongoDB by automating change management and ensuring observable outcomes.

What is the best way to configure connection pooling and index optimization for production databases?

Connection pooling and index optimization are configured by applying performance tuning best practices to reduce manual toil. This approach targets PostgreSQL, MySQL, Redis, and MongoDB, ensuring reliable operational outcomes through repeatable, auditable maintenance procedures.

Does this database operations approach support backup and restore workflows for MongoDB and Redis?

Yes, backup and restore workflows are supported for MongoDB and Redis, alongside PostgreSQL and MySQL. This approach automates these tasks to reduce risk in complex production environments by providing reliable, repeatable procedures for data recovery and maintenance.

Can I automate replication setup and maintenance windows for live database clusters?

Replication setup and maintenance windows can be automated for live database clusters across PostgreSQL, MySQL, Redis, and MongoDB. This approach applies best-practice configuration to ensure safe change management and observable outcomes during operational maintenance.

When do I need automated database performance tuning instead of manual configuration?

Automated database performance tuning is needed in complex production environments where manual toil and risk are high. Applying repeatable, auditable procedures for configuration optimization across PostgreSQL, MySQL, Redis, and MongoDB ensures reliable, observable outcomes.