Skip to main content
MySQL / PostgreSQL integration tile in Arya settings

​
What it does

If you have an external database (MySQL, PostgreSQL) with legacy operational data, Arya can sync specific tables as objects. Configurable sync per field, frequency, direction.

​
Prerequisites

  • Active account with MySQL / PostgreSQL
  • Admin or Manager role on Arya to connect
  • OAuth authorisation (or API key, where applicable)

​
Connect MySQL / PostgreSQL

1

Go to Settings → Integrations

Find MySQL / PostgreSQL in the gallery and click Connect.
2

Authorise via OAuth

Opens MySQL / PostgreSQL login page. Grant requested permissions.
3

Confirm in Arya

Arya tests the connection. If OK, you see “Connected” in green.
4

Configure preferences (optional)

Sync frequency, filters, field mapping. From Settings → Integrations → [MySQL / PostgreSQL] → Configure.

​
What syncs

DirectionEntity
ConfigurableDB tables ↔ Arya objects
ConfigurableExplicitly mapped fields
ConfigurableFrequency (real-time, every N min, daily)

​
Use in workflows

Once connected, MySQL / PostgreSQL appears as an action in the workflow builder. You can:
  • Trigger workflows from MySQL / PostgreSQL events
  • Use MySQL / PostgreSQL as an action (e.g. create record, send message)

​
Troubleshooting

Expired or revoked token. Disconnect and reconnect.
Check service API quota (rate limit). Reduce frequency if exceeding quota.
Verify field mapping and filters. Try manual sync from ⋯ → Sync now.
Arya uses unique keys for matching. Configure key (email, external ID) in Settings → Sync.

​
Disconnect

Disconnection immediately stops synchronisation. Already-imported data stays in the workspace.
1

Go to Settings → Integrations

Find the MySQL / PostgreSQL card.
2

Click Disconnect

Confirm. Access token is revoked.