database-administrator

Name: database-administrator
Availability: InStock
Author: imudak

Analyze query execution plans and optimize database performance.

Updated Aug 27, 2026

Search Tags:#security #database #backup #high availability #recovery #performance tuning #administration

Ready to run

npx skills add https://github.com/imudak/claudemd-gen --skill database-administrator-imudak

💬 Prompt for ChatGPT / Claude Chat▼

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.