database-management

Monitor Azure PostgreSQL health, connections, backups, and database sizes.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/3horizons/agentic-devops-platform --skill database-management-3horizons
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-management
Source: https://github.com/3horizons/agentic-devops-platform/tree/main/.github/skills/database-management
Command: npx skills add https://github.com/3horizons/agentic-devops-platform --skill database-management-3horizons

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you manage and monitor your databases, ensuring their health, connectivity, and performance.

Core Features & Use Cases

  • Database Health Checks: Verify the operational status of your databases.
  • Connection Verification: Ensure applications can connect to the database.
  • Performance Monitoring: Track key performance indicators like size and active connections.
  • Backup Status: Confirm that backups are being performed correctly.
  • Use Case: A developer needs to quickly check if the PostgreSQL database is running and accepting connections before deploying a new feature.

Quick Start

Check the health and connection status of the Azure PostgreSQL database named 'my-db' in resource group 'my-rg'.

Frequently Asked Questions about database-management

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

FAQPage Schema
How do I check Azure PostgreSQL database health and connection status?

Check Azure PostgreSQL database health by listing server details, verifying firewall rules, testing connections, and monitoring database size. This Skill performs operational status checks to ensure your PostgreSQL instances are running and accepting connections.

What's the best way to monitor PostgreSQL table sizes and active connections?

Monitor PostgreSQL table sizes and active connections by running health checks that track key performance indicators. This Skill queries your instances to report current database size and operational metrics for performance monitoring.

Do I need Azure CLI and psql client to manage PostgreSQL instances?

Yes, you need Azure CLI and psql client with appropriate credentials to manage PostgreSQL instances. This Skill requires both tools to execute server listing, connection testing, and backup retention verification tasks.

How do I verify backup retention and firewall rules for Azure PostgreSQL?

Verify backup retention and firewall rules for Azure PostgreSQL by querying server details through Azure CLI. This Skill checks backup configurations and network access rules to confirm databases are secured and recoverable.

Can I use this database management Skill for general PostgreSQL instances or only Azure?

You can use this database management Skill for both Azure PostgreSQL and general PostgreSQL instances. It performs health monitoring, connection verification, and size tracking across standard PostgreSQL deployments requiring psql client access.

Why does testing database connection fail before deploying new features?

Testing database connection may fail due to firewall rules blocking access or incorrect credentials. This Skill verifies connection parameters and firewall configurations to ensure applications can reach PostgreSQL before deployment.