# MySQL + Supabase

> Integrate tables and database objects from MySQL to Supabase with Erathos. An incremental, no-code pipeline with full observability. Start for free.

Source: https://www.erathos.com/en/pipelines/mysql-supabase
Em português: https://www.erathos.com/pipelines/mysql-supabase

MySQL is an open-source relational database management system, widely used to store, organize, and retrieve data in web and enterprise applications. Postgres, on the other hand, is a highly robust and scalable open-source relational database management system. It supports a wide range of data types and advanced features.

With Erathos, your MySQL data arrives at Supabase ready to power applications via REST, GraphQL, or Realtime Subscriptions, without your team having to build the sync layer from scratch.

### What MySQL data does Erathos sync with PostgreSQL?

The integration automatically syncs key MySQL objects:

- **Selected tables**: incremental replication of any configured table
- **Schema drift**: new columns are automatically detected and added to the destination
- **Primary keys and timestamps**: used for efficient incremental syncing
- **Historical data**: full initial load followed by incremental updates

### Why sync MySQL with Supabase?

In Supabase, MySQL data becomes available via REST, GraphQL, and Realtime Subscriptions, ready to power applications built by teams that are not data engineering specialists.

### How it works

Erathos connects to MySQL via the official API and syncs your data incrementally: only new or updated records are processed in each run, keeping pipelines fast and Supabase costs predictable. You choose the sync frequency (from 5 minutes to daily), the objects to sync, and the destination dataset. Every run is logged with full observability: runtime, rows processed, errors with context, and instant alerts via Slack or email if anything goes wrong.

## MySQL data in Supabase in minutes

### MySQL connector ready to use

Connect MySQL to Supabase and automatically export data. Centralize database data for analysis — without spreadsheets or scripts.

### Full control over your MySQL pipelines

Configure scheduling, frequency, and sync type at the table level. Configure sync frequency and type on a per-table basis. Erathos uses smart UPSERT in Supabase — data is available via REST, GraphQL, and Realtime Subscriptions as soon as it lands in the database.

### End-to-end observability

Stop finding out about MySQL failures only when the business team complains. Every run is logged with runtime, rows processed, and error context. Automatic alerts via Slack, Discord, or email as soon as anything goes off track — with fresh data always available for your analysis.

## Centralizing MySQL data in Supabase has never been simpler

Erathos is a data ingestion platform built for data and engineering teams. With the MySQL connector, you can automatically centralize MySQL tables and database objects in Supabase — always up-to-date data, full visibility into every run, and zero maintenance.

## FAQ

### What is Erathos, and how can it help my business?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect sources like MySQL to their data warehouse — with full visibility into every run, zero maintenance, and none of the black-box behavior of traditional tools on the market.

### Which MySQL data does Erathos sync to Supabase?

Erathos performs incremental or full MySQL replication to your destination Data Warehouse, including tables, schemas, and relationships. Synchronization is configurable by frequency and schedule, with no code required.

### How often does Erathos sync data from MySQL to Supabase?

You can configure sync frequency from every 5 minutes up to daily, at the table level. Erathos uses incremental sync — only new or updated records are processed in each run, keeping the MySQL pipeline efficient and Supabase costs predictable.

### What happens if a MySQL sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just “job failed.” Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial for the MySQL connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect MySQL to Supabase and start syncing right away — no credit card required.
