Docs · Migratrix
Documentation

Get Migratrix running fast

Learn the core workflow for installing agents, connecting environments, reviewing migrations, and promoting database changes safely.

What Is Migratrix?

Migratrix is a database DevOps platform for safely promoting schema and data changes across environments.

  • Explorer: browse, read, and run controlled edits with environment-aware permissions.
  • Migration Flow: define DEV to QA to PROD pipelines with approval gates and audit history.
  • Compare and Transfer: compare schemas, detect drift, and move data across or within engines.

Key Concepts

  • Workspace: the container for environments, connections, users, and roles.
  • Environment: a stage such as DEV, QA, or PROD with its own access rules.
  • Flow: the route a change takes between environments, including approvals.
  • Migration: a SQL change set with status, audit, and rollback metadata.
  • Agent: the runtime deployed in your network that connects securely to your databases.

For the full list of supported database engines, see Supported databases and versions.

Supported databases and versions

Server compatibility follows each vendor's guidance; use current, supported database releases where possible.

Database Typical targets
Amazon Redshift Redshift (PostgreSQL-compatible wire protocol)
Apache Cassandra Cassandra 3.x / 4.x clusters
ClickHouse ClickHouse server (TCP)
CockroachDB CockroachDB (PostgreSQL wire)
Databricks SQL Databricks SQL Warehouse / clusters (ODBC; Simba ODBC driver on the agent host)
DuckDB Embedded DuckDB files
Google BigQuery BigQuery projects and datasets
MariaDB MariaDB 10.3+ (MySQL protocol)
Microsoft SQL Server SQL Server 2012+, Azure SQL
MongoDB MongoDB 4.2+
MySQL MySQL 5.7+, 8.x
Oracle Database Oracle 12c onward
PostgreSQL PostgreSQL 12+
Snowflake Snowflake accounts
SQLite SQLite 3 file databases
TiDB TiDB (MySQL protocol)
YugabyteDB YugabyteDB YSQL (PostgreSQL wire)

Install the Agent

The Agent authenticates using a workspace Agent token. You can provide it via command line or the MIGRATRIX_API_KEY environment variable.

Docker

docker run -d \
  --name migratrix-agent \
  --restart unless-stopped \
  -e MIGRATRIX_API_KEY="<your_agent_api_key_or_jwt>" \
  -e MIGRATRIX_DIR=/data/migratrix \
  -p 4002:4002 \
  -v migratrix-agent-data:/data/migratrix \
  ghcr.io/code-fighter-labs/migratrix-agent:latest

macOS

brew tap code-fighter-labs/tap
brew install migratrix-agent
migratrix-agent --apiKey "<your_agent_api_key_or_jwt>"

Linux

curl -sSL https://github.com/code-fighter-labs/homebrew-tap/releases/latest/download/install.sh | sh
migratrix-agent --apiKey "<your_agent_api_key_or_jwt>"

Windows

iwr https://github.com/code-fighter-labs/homebrew-tap/releases/latest/download/install.ps1 | iex
migratrix-agent --apiKey "<your_agent_api_key_or_jwt>"

Networking and HTTPS

Migratrix separates how the Agent listens from how clients reach it:

  • BindAddress: where the Agent listens on the host, such as http://0.0.0.0:4002.
  • PublicUrl: the externally reachable address used by the browser and web app, such as https://agent.company.com.

If the Migratrix web app is loaded over HTTPS, browsers will block connections to an HTTP agent. For production, set PublicUrl to an HTTPS address.

For localhost development, mkcert can be used to generate browser-trusted certificates for https://localhost:4002.

Connect Databases and Environments

  1. Create or join a workspace.
  2. Install an Agent in the network closest to the databases you want to manage.
  3. Add connections for each environment such as DEV, QA, and PROD.
  4. Assign environment-specific roles for admins, approvers, developers, and viewers.
  5. Create one or more migration flows that reflect your promotion path.

Credentials remain on the Agent machine and are not stored on the Migratrix platform.

GitOps Workflow

Migratrix fits into a SQL-in-Git workflow while keeping execution and approvals close to the database delivery process.

  1. Write a migration in Migratrix or sync one from GitHub or GitLab.
  2. Review schema diff, impact analysis, and generated rollback details.
  3. Open or update the pull request tied to the migration.
  4. Merge the change and let the configured flow promote it through environments with approvals.
  5. Track every step in the audit log and use rollback if recovery is needed.

Explorer

Explorer lets teams browse tables, preview rows, inspect schema objects, and run SQL with safeguards aligned to each environment.

  • Read-only defaults in production.
  • Environment-aware RBAC.
  • Audited reads and writes.
  • AI-assisted query generation from natural language prompts.

Migration Flows

Flows model the path from lower environments to production. Each stage can enforce its own approval policy, execution rules, and rollback behavior.

  • Single-step or multi-stage flows.
  • Approval gates for QA and production.
  • Generated rollback scripts.
  • Execution history, live logs, and audit metadata.

Compare and Sync

Compare and Sync is designed for schema drift detection and controlled alignment between environments.

  • Schema diff across supported engines.
  • Object-level visibility for tables, indexes, constraints, views, and more.
  • Generated sync scripts to align target to source.
  • Optional data comparison to inspect inserted, updated, and deleted rows.

Data Transfer

Migratrix supports same-type and cross-type transfers with batching, retries, and scheduling. This is useful for refreshes, sync jobs, and operational movement between environments.

Approvals, Audit, and Safety

  • Every migration carries a traceable execution record.
  • Approval decisions are tied to users, timestamps, and environments.
  • Risk analysis flags destructive or suspicious SQL patterns before execution.
  • Rollback readiness helps teams recover faster from bad deployments.

Need Help?

If you need help with onboarding, network topology, or enterprise rollout planning, use the contact form or email sales@migratrix.com.