skills.rest
slantview
slantviewCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-admin

Manage PostgreSQL database setup, backups, replication, monitoring, and user permissions.

1|1|Updated Aug 5, 2025
Search Tags:#performance#monitoring#security#database#backup#replication#administration
One-click install
npx skills add https://github.com/slantview/claude --skill database-admin-slantview
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-admin
Source: https://github.com/slantview/claude/tree/main/skills/database-admin
Command: npx skills add https://github.com/slantview/claude --skill database-admin-slantview

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the complexities of managing database operations, ensuring data integrity, security, and performance.

Core Features & Use Cases

  • Database Management: Handles operations like setup, maintenance, and user permissions.
  • Data Protection: Implements robust backup, replication, and disaster recovery strategies.
  • Performance Optimization: Monitors and tunes databases for optimal speed and efficiency.
  • Use Case: Proactively set up a new PostgreSQL database with automated daily backups, user role management, and performance monitoring alerts.

Quick Start

Use the database-admin skill to set up a new PostgreSQL database with daily backups and user permissions.

Frequently Asked Questions about database-admin

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

FAQPage Schema
How do I automate database backups and disaster recovery for PostgreSQL?▼

Automating database backups and disaster recovery involves setting up robust replication and scheduled backup scripts to ensure data integrity and operational reliability. This approach enables proactive monitoring and regular testing of recovery readiness for PostgreSQL instances.

What is the best way to monitor database performance and tune for optimal speed?▼

Monitoring database performance requires tracking key database metrics and tuning queries to maintain optimal speed and efficiency. This process ensures operational reliability by proactively identifying bottlenecks and automating alerts for critical performance thresholds.

How do I manage user permissions and security for database administration?▼

Managing user permissions and database security requires implementing role-based access controls and adhering to administration best practices. This ensures data integrity by restricting unauthorized access while maintaining operational reliability across database operations.

Can I set up database replication and automated daily backups simultaneously?▼

Yes, setting up database replication alongside automated daily backups is a core feature of comprehensive database operations. This combination ensures disaster recovery readiness and data integrity by maintaining synchronized copies and historical backup snapshots.

Related Skills

Explore More Software Engineering Skills→
phuetzphuetz
30

terraform-ansible

Provision cloud infrastructure with Terraform and configure it using Ansible playbooks.

Community
Advanced
majesticlabs-devmajesticlabs-dev
47

litestream-advanced-patterns

Configure Litestream streaming backups for Rails 8+ SQLite databases to S3-compatible storage.

Official
Advanced
ikenibornikeniborn
6

monitoring-troubleshooting

Collect health data, logs, and metrics to diagnose multi-service Docker Compose deployments.

Community
Advanced
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate