Choose both endpoints
Select source and target connections and databases. Cupcake reads their schemas and pairs tables by name. Review the proposed pairs before continuing.
Plans / Mapping editor
MySQL table mappings.
Every column counts.
Choose your source and target. Pair the tables, inspect the columns, and save the rules that your next snapshot or comparison will use.
← All Plans
Commerce replica
A reusable, versioned plan for snapshots, CDC, comparison, and reconciliation.
Check SchemasCompare DDLSave Changes
SOURCECommerce productionMySQL 8 · commerce_prod
TARGETCommerce replicaMySQL 8 · commerce_replica
Table Mappings
3 selected · 0 warnings · 0 errorsRe-discoverSrc DDLTgt DDLReset all
| Included | Source table | Target table | Cols | Rows ≈ | Filter |
|---|---|---|---|---|---|
| ✓ | customers | 5 | 18.4k | — | |
| ✓ | orders | 5 | 84.2k | status = 'paid' | |
| ✓ | inventory | 3 | 6.3k | — |
Select a source table to explore its column mappings.
customers customers
5 mappedColumn MappingsReset columns
| Source column | Target column | Key | Cast | Expression |
|---|---|---|---|---|
| idbigint | id | PK | — | — |
| namevarchar(160) | name | — | — | — |
| emailvarchar(255) | — | — | LOWER(email) | |
| created_atdatetime | created_at | — | — | — |
| updated_atdatetime | updated_at | — | — | — |
orders orders
5 mappedColumn MappingsReset columns
| Source column | Target column | Key | Cast | Expression |
|---|---|---|---|---|
| idbigint | id | PK | — | — |
| customer_idbigint | customer_id | — | — | — |
| totaldecimal(12,2) | total | — | decimal(12,2) | — |
| statusvarchar(24) | status | — | — | — |
| created_atdatetime | created_at | — | — | — |
inventory inventory
3 mappedColumn MappingsReset columns
| Source column | Target column | Key | Cast | Expression |
|---|---|---|---|---|
| product_idbigint | product_id | PK | — | — |
| quantityint | quantity | — | — | — |
| updated_atdatetime | updated_at | — | — | — |
Saving records the plan. It does not start a copy job.
From discovery to a saved plan
Two panes.
One set of rules.
The table list keeps the scope visible. The column panel shows exactly how the selected pair is mapped.
Review tables and columns
Include or exclude tables, choose target names, and set source row filters. Select a table to inspect column pairs, key indicators, type casts, and expressions. Row counts in the editor are estimates.
Check, then save
Use Check Schemas on a saved plan to read both schemas again, or Compare DDL to inspect differences. Save Plan or Save Changes records the mapping; a snapshot, CDC stream, or comparison is a separate action.
When schemas change
Keep the exceptions visible.
Re-discover refreshes the schema while keeping existing pairings, filters, and expressions. Reset all starts the mapping over; Reset columns rebuilds the selected table’s column pairs.
Saving is not proof of a match
Schema checks report mismatches separately from saving. Review warnings and errors, and pay attention to unmanaged target tables: tables outside the plan are not copied, compared, or reconciled.
The preview shows the current macOS workflow. Enterprise uses its own browser interface; Windows is coming soon.
Save the plan.
Choose the next operation.
Use the same mapping for snapshots, comparisons, CDC, and reconciliation.