Skip to main content
Glama

AgentXray — Amazon settlement report MCP server

A local MCP server that reads your Amazon settlement reports and tells your AI assistant what Amazon actually paid you: sales, refunds, promotions, referral and FBA fees, storage, subscription, reimbursements, the net, and profit per SKU — exact to the cent, computed on your computer.

  • Runs locally, works offline. The report is read from your disk and never uploaded. No account, no API keys, no Seller Central login.

  • Money is integer cents. No floating-point drift; the lines reconcile to the deposit in the report header, and the server tells you when they don't.

  • Same parser as AgentXray's settlement reader, checked to the cent against reference results for point and comma decimals, refunds, promotions and messy transaction types (test/fixtures/settlement).

Works with Claude Desktop, Claude Code, Cursor, VS Code, and any MCP client that runs local (stdio) servers.

Tools

Tool

What it does

read_settlement_report

Profit and loss for one report: every bucket with its Amazon line types, net, units, orders, average price, FBA fee per unit, referral rate. Give a unit cost (cogs_per_unit) and it returns profit after product cost. Optional start/end date range by posted date.

settlement_profit_by_sku

The same report grouped by SKU: units, orders, sales, fees, net and net per unit. Lines without a SKU (storage, subscription, most reimbursements) stay in their own group, so the SKUs plus that group equal the net exactly. include_lines shows the lines behind a SKU so you can check the arithmetic.

list_settlement_reports

Finds the settlement reports in a folder (e.g. Downloads) with settlement id, period, deposit date and total, newest first.

Every answer carries a basis (where the numbers came from) and gaps (what a settlement report cannot show — e.g. ads billed to a card, costs outside Amazon).

Related MCP server: Amazon Seller MCP Server - DataDoe

Install

Requires Node.js 20+.

{
  "mcpServers": {
    "agentxray": {
      "command": "npx",
      "args": ["-y", "github:agentxray-ops/amazon-seller-mcp"]
    }
  }
}

Claude Code: claude mcp add agentxray -- npx -y github:agentxray-ops/amazon-seller-mcp

Docker: docker build -t agentxray-mcp . then mount the folder with your reports: docker run -i --rm -v ~/Downloads:/reports:ro agentxray-mcp and ask about files under /reports.

From source: git clone, npm install (builds), node dist/index.js.

Getting a settlement report

Seller Central → Payments → Reports Repository → report type Transaction / Settlement → download the flat file (.txt) for a settlement period. Then ask, for example:

  • "Read ~/Downloads/12345678901.txt — what did Amazon actually pay me, and where did the money go?"

  • "My landed cost is 7.40 per unit. What was my profit in that settlement?"

  • "Which SKU lost money in that period? Show me the lines for SKU-123."

  • "List the settlement reports in my Downloads folder."

Optional: live data from your Amazon account

Settlement reports arrive every two weeks. If you also want live numbers — orders, Sponsored Products ads and search terms, stock and inbound shipments, account health, returns — this server can add the tools of the hosted AgentXray service. That part needs an AgentXray account and is off unless you set a token:

"env": { "AGENTXRAY_TOKEN": "axr_..." }

Create the token in AgentXray → Settings → AI Assistant. Those calls go to https://agentxray.ai/api/mcp; the settlement tools stay local either way. Clients that speak remote MCP can also connect to that endpoint directly (OAuth): setup pages for Claude, ChatGPT, Claude Code and Grok are at https://agentxray.ai/connect. To try the live tools without an account, the public read-only demo token on that page reads a synthetic store.

Without a token, the server makes no network requests.

Development

npm install        # installs and builds
npm test           # parser parity + MCP server tests
AGENTXRAY_TEST_TOKEN=axr_... npm test   # also checks the optional live tools

License and contact

MIT. Built by AgentXray (Avanta Global EOOD, Sofia, Bulgaria) — info@avantaglobalgroup.com · Security · Privacy


Amazon and Seller Central are trademarks of Amazon.com, Inc. or its affiliates. This project is independent and not affiliated with or endorsed by Amazon. Claude is a trademark of Anthropic; ChatGPT is a trademark of OpenAI.

Available Tools

4 tools
agentxray_live_setupConnect live Amazon data (optional)A
Read-only

Explains how to add live Amazon data (orders, ads, stock, account health) to this server by connecting an AgentXray account. Listed only while no AGENTXRAY_TOKEN is set; the settlement tools do not need it.

Inputs: no named parameters.

list_settlement_reportsFind settlement reports in a folderA
Read-only

Lists the Amazon settlement reports in a folder on this computer (for example your Downloads folder), with settlement id, period, deposit date, currency and deposit total for each, newest period first. Files that are not settlement reports are skipped.

Inputs: directory (required).

read_settlement_reportProfit and loss from an Amazon settlement reportA
Read-only

Reads an Amazon settlement report (the tab-separated flat file from Seller Central → Payments → Reports Repository) from this computer and returns what Amazon actually settled: sales, refunds, promotions, referral and FBA fees, storage, subscription, reimbursements and the net, plus units, orders, average price, FBA fee per unit and referral rate. With a unit cost it also returns profit after product cost. Amounts are exact to the cent. The file never leaves this machine.

Inputs: path (required), end, start, cogs_per_unit.

settlement_profit_by_skuSettlement net per SKUA
Read-only

Groups the lines of an Amazon settlement report by SKU and returns, for each SKU, units, orders, sales, fees by bucket, net and net per unit. Lines Amazon booked without a SKU (storage, subscription, most reimbursements) are kept as their own unattributed group instead of being spread across products, so the SKU nets plus that group equal the report's net exactly. Set include_lines to see the individual lines behind one SKU.

Inputs: path (required), end, sku, start, +1 more.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A4/5.0

    Scored across 4 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: listing local settlement files, reading one report's totals, grouping one report by SKU, and explaining live-data onboarding. The two report-reading tools are differentiated by whole-report summary versus per-SKU breakdown.

    Naming Consistency3/5

    All names use snake_case, but the conventions are mixed: list_settlement_reports and read_settlement_report use verb_noun, while settlement_profit_by_sku and agentxray_live_setup are noun-phrase style. Still readable, but not a predictable pattern across the set.

    Tool Count5/5

    Four tools are well-scoped for a settlement-report-focused server: one listing tool, two analysis tools, and one conditional onboarding helper. The count is small but each tool has a clear role.

    Completeness4/5

    The core settlement workflow is covered: discover local files, read totals, and break down profit by SKU. Minor gaps exist around multi-report comparison or date filtering, and the live-data option is only described rather than implemented as query tools.

    Maintenance

    ActivityMaintained
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      C
      maintenance
      agentcentral is a hosted MCP server for Amazon sellers that connects Claude, ChatGPT, and other AI clients to Amazon Ads, Seller Central, inventory, orders, catalog, rankings, finance, and fulfillment data. It provides fast reads from pre-materialized Amazon data, scoped API keys, OAuth-based Amazon connections, encrypted tokens, per-tenant isolation, and guarded write tools with audit log
      100
      6
      MIT
    • F
      license
      A
      quality
      D
      maintenance
      A local MCP server that enables querying Amazon Selling Partner API for profitability analysis (revenue, fees, COGS, net margin) and inventory alerts (FBA stock levels and low-stock warnings) using read-only operations.
      9
      -
    • A
      license
      Not graded
      quality
      C
      maintenance
      Connects Amazon Seller Central and Amazon Advertising to any MCP client, with a settlement-accurate P&L underneath: every fee, refund and reimbursement as Amazon actually posted it, so contribution margin and breakeven are per product, per marketplace, per day. 107 tools spanning P&L, full Sponsored Products/Brands/Display management, Search Query Performance and Brand Analytics, inventory and for
      1
      MIT