// Template · DevOps

Flyway Schema Migration

Apply versioned SQL migrations to any database as part of a Putki workflow. Verifies the connection first, then runs all pending Flyway scripts in order — no standalone Flyway installation needed, no manual steps.

Uses

Flyway Migrate

DevOps Database Migrations 1 workflow · 3 actions Apache Hop

Download .hpl

Apache Hop pipeline
Created Jan 23, 2026
Putki 2026.03+

Pipeline

start

Special

check-connection

CheckDbConnections

Putki

migrate

Flyway

migration-success

WriteToLog

How it works

This template applies versioned SQL migrations to a database as part of a Putki workflow — no standalone Flyway installation needed. Flyway tracks which scripts have already been applied and only runs the pending ones, so you can run this workflow on every deployment without risk of re-applying migrations.

Verify the database connection

Before running any SQL, the workflow checks that the target database is reachable. If the connection fails, the workflow stops immediately — so a network issue or misconfiguration never leaves your schema in a partial state.

Apply pending migrations

The Putki Flyway Migrate action reads all SQL files from the configured folder, checks the flyway_schema_history table, and applies only the scripts that haven't run yet — in version order. Already-applied scripts are never re-executed.

Continue your workflow

Once migrations are applied successfully, the workflow logs a confirmation and passes control to the next action. Connect a pipeline here to immediately use the updated schema — for example, loading data into a newly created table.

What you need

Putki subscription

Access to the Flyway Migrate plugin, included in all Putki tiers. No standalone Flyway installation required.

SQL migration files

Versioned SQL scripts following Flyway's naming convention: V1__create_table.sql, V2__add_column.sql, etc. Stored in a folder accessible to Putki.

A Hop database connection

A configured Hop metadata database connection pointing to your target database. Supports PostgreSQL, MySQL, Oracle, SQL Server and any database with a compatible JDBC driver.