skills.rest
imudak
imudakCOMMUNITY
Explore all skills by this author →
GitHub

database-administrator

Analyze query execution plans and optimize database performance.

Updated Aug 27, 2026
Search Tags:#security#database#backup#high availability#recovery#performance tuning#administration
One-click install
npx skills add https://github.com/imudak/claudemd-gen --skill database-administrator-imudak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-administrator
Source: https://github.com/imudak/claudemd-gen/tree/main/.claude/skills/database-administrator
Command: npx skills add https://github.com/imudak/claudemd-gen --skill database-administrator-imudak

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates complex database administration tasks, ensuring optimal performance, robust backup and recovery, and secure operations.

Core Features & Use Cases

  • Performance Tuning: Analyzes and optimizes slow queries, indexes, and database configurations.
  • Backup & Recovery: Implements and manages comprehensive backup strategies and disaster recovery plans.
  • High Availability: Configures replication, failover, and clustering for maximum uptime.
  • Security: Enforces access control, encryption, and auditing for data protection.
  • Use Case: A user needs to improve the slow performance of their PostgreSQL database. The skill can analyze slow queries, suggest index optimizations, and recommend configuration changes.

Quick Start

Use the database-administrator skill to optimize the performance of your PostgreSQL database.

Frequently Asked Questions about database-administrator

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

FAQPage Schema
How do I optimize slow queries and improve database performance tuning?▼

Database performance tuning analyzes query execution plans and recommends index optimizations and configuration changes to resolve slow queries. It evaluates database configurations to identify and fix performance bottlenecks across supported platforms.

What is the best way to implement database backup and disaster recovery plans?▼

Database backup and disaster recovery involves implementing comprehensive backup strategies and managing recovery procedures. It automates backup task management to ensure robust data protection and secure database operations.

How do I configure high availability and replication failover for maximum uptime?▼

High availability configuration sets up database replication, failover procedures, and clustering. Configuring replication and failover ensures maximum uptime and continuous database operations during system failures.

Can I use this database administration skill for both RDBMS and NoSQL platforms?▼

Yes, database administration capabilities support various RDBMS, NoSQL, NewSQL, and Data Warehouse platforms. It provides performance tuning, backup, recovery, and security management across these diverse database systems.

How does database security hardening and access control work?▼

Database security hardening enforces access control, encryption, and auditing for data protection. It manages security configurations through interactive dialogue to ensure secure database operations and compliance.

Why does my PostgreSQL database need index optimization and configuration changes?▼

PostgreSQL databases need index optimization and configuration changes when slow queries degrade application performance. Analyzing query execution plans identifies missing indexes and inefficient configurations causing the latency.

Related Skills

Explore More Software Engineering Skills→
interflownexinterflownex
2

alloydb-postgres-data

Access AlloyDB PostgreSQL metadata and execute custom SQL queries.

Community
Intermediate
masermediagroup-stackmasermediagroup-stack
1

security-hardening

Automate security hardening across OS, container, cloud, network, and database layers.

Community
Advanced
hotriluanhotriluan
3

databases

Design, query, and administer MongoDB and PostgreSQL databases.

Community
Intermediate
MovchanetsMovchanets

database-admin

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

Community
Advanced