Create MySQL table & insert test data

# Manually create MySQL table and insert test data via n8n

This automation template streamlines the initial setup of a MySQL database structure using n8n. Useful during project onboarding or integration testing.

## Who it´s for
- Developers initializing databases at project start
- Automation engineers testing n8n integrations with DBMS
- Administrators needing to deploy a test table in MySQL

## What the automation does
- Triggered manually via ´execute´ action
- Executes a raw SQL query to create a table in MySQL
- Prepares test data (id and name)
- Inserts the data into the newly created table
- All operations run sequentially using a single MySQL connection

## What´s included
- Ready-to-use n8n workflow
- Manual trigger logic and sequential execution flow
- Integration with MySQL via direct SQL queries
- Basic text instructions for launch and adaptation

## Requirements for setup
- Access to a MySQL instance with permissions to create tables and insert data
- n8n instance (cloud or self-hosted)
- MySQL credentials (host, port, username, password, database name)

## Benefits and outcomes
- Saves time on manual database schema setup
- Simplifies onboarding and integration testing
- Can be used in CI/CD pipelines or environment validation
- Ensures consistent table structure across team members

## 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