# Database Management

> Database operations and health monitoring

- Skill: `paulanunes85/database-management` (Agent Skill)
- Install (CLI): `npx skillmds@latest add paulanunes85/database-management`
- Raw SKILL.md: https://api.skillmd.com/api/skills/paulanunes85/database-management/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: paulanunes85 (https://skillmd.com/u/paulanunes85)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/paulanunes85/database-management

---


## When to Use
- Database health checks
- Connection verification
- Performance monitoring
- Backup status verification

## Prerequisites
- Azure CLI for Azure databases
- psql for PostgreSQL operations
- Appropriate database credentials

## Commands

### Azure PostgreSQL
```bash
# List PostgreSQL servers
az postgres flexible-server list -o table

# Show server details
az postgres flexible-server show --name <server> --resource-group <rg>

# Check firewall rules
az postgres flexible-server firewall-rule list --name <server> --resource-group <rg>

# Check backup retention
az postgres flexible-server show --name <server> --resource-group <rg> --query "backup"
```

### Connection Testing
```bash
# Test PostgreSQL connection
psql "host=<host> dbname=<db> user=<user> sslmode=require" -c "SELECT version();"

# Check active connections
psql -c "SELECT count(*) FROM pg_stat_activity WHERE state = 'active';"
```

### Health Monitoring
```bash
# Check database size
psql -c "SELECT pg_size_pretty(pg_database_size(current_database()));"

# Check table sizes
psql -c "SELECT schemaname, tablename, pg_size_pretty(pg_total_relation_size(schemaname||'.'||tablename))
         FROM pg_tables ORDER BY pg_total_relation_size(schemaname||'.'||tablename) DESC LIMIT 10;"
```

## Best Practices
1. Use private endpoints for database connectivity
2. Enable SSL/TLS for all connections
3. Configure automated backups
4. Monitor connection pool usage
5. Set up alerts for high CPU/memory

## Output Format
1. Command executed
2. Database status summary
3. Any issues detected
4. Recommendations

## Integration with Agents
Used by: @terraform, @sre, @test