Amazon MWS Connector
Connect Amazon MWS to your data stack with Weld. Fully managed pipelines, set up in minutes, ready for your agents.
Amazon MWSYour warehouseLive
Queryable over MCPSet up in minutes.
No code, no maintenance.
Amazon MWS
Data source
Amazon MWS in your warehouse.
Ready for your agents.
Weld's Amazon MWS connector is fully managed: it extracts data from Amazon MWS, 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.
Amazon MWS models.
What the numbers mean.
Open-source SQL that turns the raw Amazon MWS tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Monthly Sales Performance ReportsExtracts monthly sales performance reports for Amazon integration. It calculates the total sales amount, number of orders, and total items sold for each month. Additionally, it calculates the average order value by dividing the total sales amount by the number of orders. The results are ordered in descending order by month.
- Monthly Inventory ReportsExtracts monthly inventory reports for Amazon integration. It retrieves data from the Amazon Selling API to calculate various metrics such as total items listed, total fulfillable quantity, total damaged items, expired items, total unfulfillable quantity, items in transit, and items receiving. The results are ordered by month in descending order.
- Monthly Financial Analysis Generates a monthly financial analysis for Amazon integration. It calculates the gross revenue, refunds, net revenue, average item price, average promotion discount, average shipping price, and average shipping tax. The analysis is based on data from the settlement report and orders by last updated date report. The results are sorted in descending order by month.
- Monthly Shipping and Delivery ReportsGenerates a monthly shipping and delivery report for Amazon integration. It calculates various metrics such as the number of orders, total items shipped and unshipped, average days to ship, and the count of premium and regular orders. It also includes information on different shipping service levels and the number of orders for each level. The final result is sorted by month and shipping service level.
- Monthly Returns AnalysisExtracts a monthly returns analysis for Amazon integration. It calculates various metrics such as total returns, total refunded amount, in-policy returns, out-of-policy returns, prime returns, and non-prime returns. Additionally, it provides information on return reasons and their respective counts. The results are sorted by month and reason count in descending order.
- Monthly Order Update Tracking Report Extracts a monthly order update tracking report for Amazon integration. It retrieves data from the "orders_by_last_updated_date_report" table and calculates various metrics such as total orders updated, total updates, average price updated, status breakdown, and channel breakdown. The results are sorted by month, status count, and channel count in descending order.grain: month x order status x order channel, by last-updated date
Ask your agent.
It can reach Amazon MWS.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It finds the Amazon MWS tables Weld has synced and queries your warehouse.
- DiscoverSynced tables, columns and freshness
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
Which Amazon MWS tables do we have, and which one is the largest?
Looking up what the Amazon MWS connection has synced.
Load Amazon MWS into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create Amazon MWS connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your Amazon MWS data to work.
Connect Amazon MWS, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
