Magento on Amazon RDS Connector

Amazon RDS is a cloud-based database service provided by Amazon Web Services (AWS) that simplifies the deployment, management, and scaling of databases.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Magento on Amazon RDSYour warehouseLive

Pick the tables to sync, and they appear here with their status.

Lands in

Queryable over MCP

How it works

Set up in minutes.
No code, no maintenance.

Magento on Amazon RDS

Data source

Authenticating...

Ready to connect

Overview

Magento on Amazon RDS in your warehouse.
Ready for your agents.

Amazon RDS is a cloud-based database service provided by Amazon Web Services (AWS) that simplifies the deployment, management, and scaling of databases. Weld's Magento on Amazon RDS connector is fully managed: it extracts data from Magento on Amazon RDS, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Weld MCP server

Ask your agent.
It can reach Magento on Amazon RDS.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It finds the Magento on Amazon RDS tables Weld has synced and queries your warehouse.

DiscoverSynced tables, columns and freshness
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCP

Which Magento on Amazon RDS tables do we have, and which one is the largest?

Looking up what the Magento on Amazon RDS connection has synced.

●weld·search_available_references

⎿raw.magento_on_amazon_rds.*

tables, columns and freshness

●weld·get_reference_schema

⎿columns, types and nullability

●weld·run_query

⎿select count(*) from {{raw.magento_on_amazon_rds.…}}

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Magento on Amazon RDS data in your warehouse

>Ask about your Magento on Amazon RDS dataMCP

Destinations

Load Magento on Amazon RDS into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Documentation

Magento on Amazon RDS setup guide

Step-by-step instructions to configure and start syncing.

MCP server

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

FAQ

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Magento on Amazon RDS connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Magento on Amazon RDS ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "magento-on-amazon-rds",
    "destination_schema_name": "magento-on-amazon-rds_data",
    "sync_interval": "0 * * * *"
  }'
▌