Automate PostgreSQL & MySQL via SSH

# Set up and manage PostgreSQL and MySQL databases via SSH without manual work

This automation template simplifies the deployment and management of PostgreSQL and MySQL databases on remote servers. Using n8n and SSH, you can install, create, or delete databases in seconds by manually setting parameters. Ideal for DevOps engineers, system administrators, and developers who need fast, repeatable database provisioning.

## Who it´s for
- DevOps engineers automating database deployments
- System administrators managing multiple servers
- Developers requiring quick test environments

## What the automation does
- Allows manual trigger with action selection: install, create, or delete a database
- Determines DB type (PostgreSQL or MySQL) and runs the appropriate bash script via SSH
- Executes commands on a remote Linux server to configure access and enable remote connections
- Formats execution result with status and operation details

## What´s included
- Ready-to-use n8n workflow
- Trigger and conditional logic structure
- Integrations with SSH and remote Linux server
- Basic text instructions for launch and adaptation

## Requirements for setup
- SSH access to a remote server (host, port, username, private key)
- n8n instance (cloud or self-hosted)
- Pre-existing or deployable bash scripts on the target server

## Benefits and outcomes
- Reduces database setup time from minutes to seconds
- Eliminates human error in manual configuration
- Centralized control via n8n platform
- Scalable across multiple servers
- Ensures consistent and repeatable setups

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat