Withdata FileToDB imports YAML (*.yaml, *.yml) files into MySQL locally — one file into one table, several files into one table, or bulk import many files into many tables. 100% local, secure, and cross-platform.

YAML is a human-readable data serialization format.

Download Free Trial

Why Choose Withdata FileToDB as the YAML to MySQL Importer?

🔒 100% Local & Secure

Your YAML files and MySQL credentials are used only on your own computer. Nothing is uploaded to any cloud server.

⚡ Fast Streaming Import

Millions of rows within a minute. Large files are streamed with low memory usage.

📁 Batch & Merge

Import several YAML files into one MySQL table, or bulk import a whole folder into many tables.

🔄 Nested YAML → Table Columns

Nested mappings become address.city-style column names that can be mapped to table columns.

🗃 6 Load Modes + Auto Create Table

Append, Replace, Update, Upsert, Insert Ignore and Delete. The destination table can be created automatically from the source columns.

⏱ CLI & Scheduled Tasks

Save an import configuration and run it automatically from Windows Task Scheduler or crontab.

Full Feature Comparison

Feature	Supported details
Source file	Local YAML (`.yaml`, `.yml`), batch YAML, merged YAML
Destination database	MySQL (connect with host / port / user / password; SSL where the server supports it)
Load modes	`Append` · `Replace` · `Update` · `Upsert` · `Insert Ignore` · `Delete` — with a multi-column key for Update / Upsert
Import mode	One file into one table · several files into one table · bulk import into many tables
Running mode	GUI wizard · command line · scheduled tasks
Source options	Format-specific parsing for YAML, encoding
Destination options	Schema, table name, create table if missing, column mapping, update key, encoding
Platform	Windows, macOS, Linux (native, 64-bit)

All YAML to MySQL Import Options You Need

Import one YAML file into one MySQL table — step by step in the GUI wizard
Import several YAML files into a single MySQL table
Bulk import many YAML files into many MySQL tables
Insert new rows, or Update/Upsert existing rows using a multi-column key
Run the import from the command line, and schedule it as a scheduled task
All YAML tools and all MySQL tools

YAML to MySQL Import Notes

A top-level sequence of mappings is read as a table — each mapping becomes one row.
Nested mappings are flattened into dotted column names, e.g. address.city, address.zip.
Those column names can then be mapped to the columns of the destination table.
Both .yaml and .yml files are accepted; UTF-8 (with or without BOM) is detected automatically.
Not supported: anchors and aliases (& / *), tags (!!) and multi-document files (---).
Six load modes are available: Append (insert all rows), Replace (truncate then insert), Update, Upsert, Insert Ignore and Delete.
Update and Upsert can use a multi-column key to match existing rows.
The destination table can be created automatically from the source columns, or an existing table can be used.
The destination schema and table can be chosen, and source columns can be mapped to table columns.
The file encoding is detected automatically and can be overridden.

How to Import YAML into MySQL (4 Steps)

Open Withdata FileToDB and connect to your MySQL database (host, port, user, password).
Choose the YAML file to import (or a folder / list of files for batch importing).
Choose the destination schema and table — create it from the source columns if it does not exist — and pick the load mode (Append, Replace, Update, Upsert, Insert Ignore or Delete).
Check the preview and column mapping, then click Import. Save the configuration if you want to run it again from the command line.