skills.rest
qenex-ai
qenex-aiOFFICIAL
Explore all skills by this author →
GitHub

Database Operations

Manage database migrations, backups, and performance tuning for SQL databases.

Updated Aug 23, 2026
Search Tags:#performance#database#migrations#PostgreSQL#MySQL#backups#tuning
One-click install
npx skills add https://github.com/qenex-ai/devops-plugin --skill database-operations-qenex-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Operations
Source: https://github.com/qenex-ai/devops-plugin/tree/main/skills/database-operations
Command: npx skills add https://github.com/qenex-ai/devops-plugin --skill database-operations-qenex-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexity of managing database migrations, backups, replication, and performance tuning, reducing risk and manual toil.

Core Features & Use Cases

  • Migration planning and execution across PostgreSQL, MySQL, and other SQL databases.
  • Automated backups and recovery workflows, including point-in-time recovery.
  • Replication setup and read/write routing optimization for high availability.
  • Performance tuning guidance covering indexing, query optimization, and maintenance tasks.

Quick Start

Use this skill to create a sample migration, back up a database, and validate a restore in a staging environment.

Frequently Asked Questions about Database Operations

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

FAQPage Schema
How do I automate database backups and validate a restore in staging?▼

PostgreSQL and MySQL database migrations are supported through schema changes, replication setup, and migration workflows using SQL, CLI tools, and popular migration frameworks.

What is the best way to optimize database performance and indexing?▼

Replication setup and read/write routing optimization enable high availability by distributing database workloads, reducing risk and manual configuration toil.

Does this database operations approach work with both PostgreSQL and MySQL?▼

Database migrations, backups, and performance tuning require SQL knowledge and CLI tools to execute schema changes, recovery workflows, and maintenance tasks effectively.

How do I set up database replication and high availability routing?▼

Replication setup and read/write routing optimization enable high availability by distributing database workloads, reducing risk and manual configuration toil.

What do I need to execute database migrations and performance tuning?▼

Database migrations, backups, and performance tuning require SQL knowledge and CLI tools to execute schema changes, recovery workflows, and maintenance tasks effectively.

Related Skills

Explore More Software Engineering Skills→
belokonmbelokonm
8

sql-pro

Analyze and optimize SQL queries and schemas across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
Hack23Hack23
235

postgresql-operations

Orchestrate PostgreSQL migrations, tuning, backups, and monitoring with Liquibase.

Official
Advanced
gabi-agentgabi-agent

sql-toolkit

Automate database design, querying, migrations, and optimization across SQLite, PostgreSQL, and MySQL.

Community
Advanced
cffrankcffrank

d1-time-travel

Back up D1 databases and restore them with Time Travel bookmarks.

Community
Advanced