home / skills / bobmatnyc / claude-mpm-skills / digitalocean-managed-databases

digitalocean-managed-databases skill

safe

/toolchains/platforms/deployment/digitalocean-managed-databases

This skill helps you provision, secure, and scale DigitalOcean managed databases across engines with guided workflows and best practices.

npx playbooks add skill bobmatnyc/claude-mpm-skills --skill digitalocean-managed-databases

Review the files below or copy the command above to add this skill to your agents.

Files (2)

SKILL.md

3.1 KB

---
name: digitalocean-managed-databases
description: DigitalOcean Managed Databases for PostgreSQL, MySQL, Redis, MongoDB, Kafka, OpenSearch, and Valkey. Use when provisioning, scaling, or operating managed database clusters on DigitalOcean.
progressive_disclosure:
  entry_point:
    summary: "DigitalOcean Managed Databases for PostgreSQL, MySQL, Redis, MongoDB, Kafka, OpenSearch, and Valkey. Use when provisioning, scaling, or operating managed database clusters on DigitalOcean."
    when_to_use: "When working with version control, branches, or pull requests."
    quick_start: "1. Review the core concepts below. 2. Apply patterns to your use case. 3. Follow best practices for implementation."
---
# DigitalOcean Managed Databases Skill

---
progressive_disclosure:
  entry_point:
    summary: "Managed databases on DigitalOcean: PostgreSQL, MySQL, Redis, MongoDB, Kafka, OpenSearch, Valkey with managed backups and scaling."
    when_to_use:
      - "When provisioning managed database clusters"
      - "When scaling or migrating database workloads"
      - "When securing database access with VPC and credentials"
    quick_start:
      - "Choose a database engine and region"
      - "Create a cluster and users"
      - "Apply networking and access controls"
      - "Monitor usage and scale as needed"
  token_estimate:
    entry: 90-110
    full: 4200-5400
---

## Overview

DigitalOcean Managed Databases provide fully managed clusters so teams can avoid manual setup and maintenance.

**Supported engines**:
- PostgreSQL
- MySQL
- Redis
- MongoDB
- Kafka
- OpenSearch
- Valkey

## Provisioning Workflow

- Select engine, region, and cluster size.
- Create users and databases with required roles.
- Configure trusted sources and VPC networking.
- Retrieve connection strings and TLS settings.

## Operations and Scaling

- Scale nodes or storage as demand grows.
- Set maintenance windows to control upgrades.
- Review backups and restore points.

## Security Practices

- Use VPC for private connectivity.
- Rotate credentials and limit user privileges.
- Enforce TLS connections.

## Migration Planning

- Use engine-specific migration guides.
- Validate application connectivity before cutover.
- Plan rollback using snapshots or backups.

## Complementary Skills

When using this skill, consider these related skills (if deployed):

- **digitalocean-networking**: VPC, firewalls, and private access.
- **digitalocean-management**: Monitoring and alerting.
- **digitalocean-storage**: Backup and snapshot workflows.

*Note: Complementary skills are optional. This skill is fully functional without them.*

## Resources

**DigitalOcean Docs**:
- Managed Databases: https://docs.digitalocean.com/products/databases/
- PostgreSQL: https://docs.digitalocean.com/products/databases/postgresql/
- MySQL: https://docs.digitalocean.com/products/databases/mysql/
- Redis: https://docs.digitalocean.com/products/databases/redis/
- MongoDB: https://docs.digitalocean.com/products/databases/mongodb/
- Kafka: https://docs.digitalocean.com/products/databases/kafka/
- OpenSearch: https://docs.digitalocean.com/products/databases/opensearch/
- Valkey: https://docs.digitalocean.com/products/databases/valkey/

Overview

This skill manages DigitalOcean Managed Databases for PostgreSQL, MySQL, Redis, MongoDB, Kafka, OpenSearch, and Valkey. It helps provision clusters, configure secure access, manage backups, and scale compute or storage. Use it to streamline routine database operations and reduce manual maintenance overhead.

How this skill works

The skill guides you through selecting an engine, region, and cluster size, then creates users, databases, and network controls like VPC and trusted sources. It exposes steps to retrieve connection strings, enforce TLS, schedule maintenance windows, and manage automated backups and restores. Scaling actions for nodes and storage are available, along with migration planning and rollback options using snapshots.

When to use it

When provisioning new managed database clusters on DigitalOcean
When scaling node count or storage to meet demand
When configuring secure access via VPC, trusted sources, and TLS
When planning or executing engine-specific migrations and cutovers
When restoring from backups or validating point-in-time recovery

Best practices

Choose the appropriate engine and region based on latency and compliance needs
Create least-privilege users and rotate credentials regularly
Use VPC and firewall rules to restrict access to trusted sources
Schedule maintenance windows to control disruptive upgrades
Monitor metrics post-scale and test restores from backups before cutover

Example use cases

Provision a production PostgreSQL cluster with private VPC networking and read replicas
Scale a MySQL cluster vertically or add replicas during traffic growth
Create a Redis cluster for session caching with TLS and restricted access
Perform a MongoDB migration: snapshot, replicate, validate connectivity, and cut over
Restore a cluster from backup after a data corruption incident and validate rollback

FAQ

Which database engines are supported?

PostgreSQL, MySQL, Redis, MongoDB, Kafka, OpenSearch, and Valkey are supported.

How do I secure access to managed databases?

Use VPC for private connectivity, restrict trusted sources, enforce TLS, and apply least-privilege user roles.