Does this require manual SSH configuration?

The skill utilizes pre-defined SSH commands to interact with the VPS, assuming the host machine has the necessary SSH keys to access the srv759970 instance.

Can I use this skill to restore a corrupted database?

Yes, it includes specific procedures for uploading backup files and performing restores via pg_restore, mongorestore, and RDB file handling.

Which database engines are supported by this skill?

This skill supports PostgreSQL, Redis, and MongoDB specifically configured as shared Docker containers on a Hostinger VPS.

Is it possible to monitor database performance in real-time?

Absolutely. The skill can check active connections, identify long-running queries in PostgreSQL, and monitor slow logs or memory usage in Redis.

How does the skill handle security and user management?

The skill provides commands for creating users, setting encrypted passwords, and granting specific database privileges to ensure secure access control.

Hostinger VPS Database Manager

Name: Hostinger VPS Database Manager
Author: theflysurfer

bytheflysurfer

データベース管理

Manages shared PostgreSQL, Redis, and MongoDB instances on Hostinger VPS infrastructure via Docker commands.

概要

The Hostinger VPS Database Manager skill provides a comprehensive toolkit for administrating shared database environments on the srv759970 Hostinger VPS. It enables developers to perform essential operations across PostgreSQL, Redis, and MongoDB, including database provisioning, user management, and performance monitoring. By automating complex Docker-exec and shell-based workflows, this skill simplifies routine maintenance, troubleshooting connection issues, and executing robust backup/restore strategies for multiple applications sharing the same infrastructure.

主な機能

Comprehensive user management and permission granting
Docker-specific troubleshooting and container health diagnostics
0 GitHub stars
Streamlined database backup and restoration workflows
Multi-engine support for PostgreSQL, Redis, and MongoDB instances
Real-time performance monitoring and long-running query termination

ユースケース

Performing automated or manual data snapshots before infrastructure updates
Provisioning new databases and users for WordPress or custom web applications
Diagnosing and resolving database connection errors in application containers

概要

主な機能

Comprehensive user management and permission granting
Docker-specific troubleshooting and container health diagnostics
0 GitHub stars
Streamlined database backup and restoration workflows
Multi-engine support for PostgreSQL, Redis, and MongoDB instances
Real-time performance monitoring and long-running query termination

ユースケース

Performing automated or manual data snapshots before infrastructure updates
Provisioning new databases and users for WordPress or custom web applications
Diagnosing and resolving database connection errors in application containers