Skip to content
Database

Connect MySQL to any app with two-way sync.

Two-way sync MySQL across all your CRMs, databases, data warehouses, EDI systems, and AI tools, with custom workflows tailored to your data.

  • SOC 2 and 6 other compliance frameworks
  • POC with real engineers in minutes
Setup guide: how Stacksync connects to MySQL

Adopted by fast-scaling companies moving mission-critical data in real time

Case study
Migrated from MuleSoft
Case study
Migrated from Celigo
Migrated from Heroku Connect
Migrated from Matillion
Case study
Migrated from Fivetran
Case study
Migrated from Celigo
Object catalog

What Stacksync syncs in MySQL.

These objects sync between MySQL and any connected system, with field-level mapping and conflict resolution. Custom fields are picked up from the live schema where MySQL exposes them.

Databases (Schemas)
Top-level namespaces that scope a sync's reads and writes.
Tables
The primary sync target; rows map to records in connected systems.
Views
Read-side projections used as outbound sync sources.
Columns
Field-level mapping targets with engine-typed values.
Primary and Unique Keys
Match keys for idempotent upserts and conflict handling.
JSON Columns
Validated semi-structured payloads for nested SaaS data.
Stored Procedures
Server-side logic that can post-process synced rows.
Triggers
An alternative change-capture mechanism when binlog access is unavailable.
API surface

How Stacksync connects to MySQL.

The connector runs on MySQL's native API. Stacksync manages authentication, rate limits, retries, and schema changes so your team does not maintain integration code.

Connection
SQL wire protocol (MySQL client/server protocol)
Authentication
Database credentials entered as a connection string or parameters, with optional SSL root certificate upload and optional SSH tunnel (SSH user + SSH host)
Change detection
Database triggers — Stacksync creates deterministic triggers for internal logging and syncing (requires log_bin_trust_function_creators=ON when binary logging is enabled)
Rate limits
No API rate limits; throughput is bounded by connection limits and server resources

Sync directions

  • Read Supported
  • Write Supported
  • Change data capture Supported
  • Webhooks Not available
MySQL connector documentation
What ships with MySQL

Connect MySQL for flexible, real-time data sync.

Real-time sync, workflow automation, event queues, EDI, and monitoring, for every connection.

Real-time

Two-way sync

Changes in MySQL instantly reflect across connected systems. No stale data, no manual imports.

No-code + pro-code

Workflow automation

Trigger automated workflows whenever MySQL data changes, update records, fire webhooks, or kick off sequences without brittle API scripts.

At scale

Event queues

Handle millions of events per minute without losing a single MySQL record.

Observability

Monitoring

Track your MySQL sync health, view errors, and replay failed events in one click.

Trading partners

EDI

Transform legacy EDI complexity into simple database interactions.

Use cases

What teams run on the MySQL connector.

MySQL calls itself the world's most popular open source database, and Oracle cites 2000 ISVs, OEMs, and VARs embedding it in their products. Backend engineering, DBA, and IT teams run it as the OLTP store behind web and line-of-business applications, so years of customer, order, and inventory records accumulate in its schemas - data that CRMs, support tools, and reporting systems need but that teams rarely want to expose through direct database credentials.

  • Backend engineering
  • Data engineering
  • DBAs
  • IT

  1. Two-way sync between a MySQL application database and a CRM so operational records and sales records stay identical

  2. Expose SaaS objects as MySQL tables so legacy internal tools built on MySQL can read live business data

  3. Replicate ERP master data (customers, items, pricing) into the MySQL databases behind storefronts and portals

  4. Keep e-commerce orders in MySQL flowing into finance and fulfillment systems without export scripts

  5. Feed a warehouse from MySQL continuously using binlog-based capture instead of nightly dumps

  6. Two-way sync of customer and order Tables with a CRM or support desk so business teams work from live operational data without being granted direct database access.

All MySQL integrations

Pick the system you need to keep in sync with MySQL. Each page covers the sync setup, field mapping, and common workflows for that pair.

CRM · 47

ERP · 43

Database · 49

Data warehouse · 29

Business productivity · 40

Accounting and finance · 17

How it works

Set up MySQL in minutes, without APIs.

Configure and sync within minutes, no code. Whether you sync 50k or 100M+ records, Stacksync handles the queues, infra, and plumbing. Integrations are non-invasive and need zero setup on your systems.

  1. 01

    Connect your apps

    Authenticate MySQL with its native method — OAuth, API keys, or service accounts — plus secure options like SSH tunneling, IP whitelisting, and VPC peering.

    • OAuth 2.0
    • SSH tunnel
    • VPC peering
    MySQL connected
    OAuth 2.0
    SSH tunnel
    SSL certificate
    VPC peering
  2. 02

    Choose tables

    Pick the MySQL objects to sync — Stacksync auto-detects the schema, including custom fields where the platform exposes them. Sync to existing tables, or let Stacksync create new ones with ideal data types.

    • Standard objects
    • Custom objects
    • Auto-schema
    objects · MySQL
    Customers 12,480
    Sales Orders 8,213
    Invoices 5,902
    Items 1,344
  3. 03

    Map fields

    Fields map automatically even when names and types differ. Stacksync handles transformation and type casting for you, zero configuration required.

    • Auto-map
    • Type casting
    • Transforms
    MySQL database
    Company company_name text
    Email email text
    Amount amount numeric
    Created created_at timestamp
Try interactive demo

FAQ

MySQL connector FAQ

What can I sync with the MySQL connector?

MySQL's core objects — Databases (Schemas), Tables, Views, Columns and custom fields — can sync with any of 302 other systems. Every integration is real-time and bidirectional, with field-level mapping and conflict resolution.

How does Stacksync connect to MySQL?

Via SQL wire protocol (MySQL client/server protocol), authenticated with Database credentials entered as a connection string or parameters, with optional SSL root certificate upload and optional SSH tunnel (SSH user + SSH host). Changes are detected as follows — database triggers — Stacksync creates deterministic triggers for internal logging and syncing (requires log_bin_trust_function_creators=ON when binary logging is enabled). Stacksync manages rate limits, retries, and schema changes automatically.

Is the MySQL connector two-way?

Yes. Changes made in MySQL propagate to the connected system and vice versa, in milliseconds. One-way flows are also supported when a direction should stay read-only.

How long does a MySQL integration take to set up?

Most MySQL integrations go live in minutes: authenticate MySQL and the other system, pick objects and fields, and enable the sync. No code and no infrastructure to manage.

Is MySQL data secure in transit?

Stacksync is SOC 2 Type II, ISO 27001, GDPR and HIPAA compliant. MySQL data is encrypted in transit, and a zero-persistent-storage architecture means records are not retained after a sync operation.

SECURITY

Security teams trust Stacksync

As a data company, we understand the importance of keeping your data secure. Stacksync is built with security best practices to keep your data safe at every layer, and is DPF-certified for US, EU, UK and CH data transfers.

Learn more about security
SOC 2 Type II
ISO 27001
HIPAA BAA
GDPR
CCPA
DPF US-EU-UK-CH
→ SECURITY WITH BENEFITS

SSO & SCIM

Let your users access Stacksync from your centralized user management systems. Works with Okta, Azure, Google SSO and more.

Alerts

Immediately get alerted about record syncing issues over email, Slack, PagerDuty and WhatsApp. Resolve issues from a centralized dashboard with retry and revert options.

Secure connection options

Securely connects to your systems with:

OAuth 2 SSH Tunnelling SSL certificates IP Whitelisting VPN gateway VPC peering and more
Coworkers laughing in front of a laptop in a casual office setting

Your last integration took months.
Your next one takes a prompt.

Book a demo Tour the platform on your own