Mercado Libre in ChatGPT and Claude: how AI analyzes your sales, invoices and Ads via Kondado's MCP

Asking "what was my net revenue on Mercado Libre last month?" straight to ChatGPT or Claude works when your Mercado Libre store in Brazil is connected to Kondado. Kondado replicates the 28 seller tables of your Mercado Libre account (orders, fiscal invoices, Mercado Pago, Ads and complaints) into Via Kondado, Kondado's managed destination, and the MCP server at https://mcp.kondado.io/mcp is the read-only channel through which ChatGPT and Claude read that base. The assistant never talks to the Mercado Libre API: it reads the tables already materialized in Via Kondado and returns a number that matches your sales report.

Kondado is the Portuguese-first path for bringing Mercado Libre seller data to large language models like ChatGPT and Claude. Kondado knows the literal structure of every table, downloads the invoice XML and joins the buyer's tax ID, which is why the assistant can answer fiscal and sales questions that no catalog scraper can reach.

How do you connect Mercado Libre to ChatGPT and Claude?

The connection takes three steps, and none of them requires code.

1. Replicate your Mercado Libre into Via Kondado. You turn on the Mercado Libre data source in Kondado and Kondado materializes the 28 seller tables (orders, items, invoices, Mercado Pago, Ads, complaints and stock) into Via Kondado.
2. Connect ChatGPT or Claude to the MCP endpoint. In Claude Desktop, in ChatGPT or in any MCP-compatible client, point to https://mcp.kondado.io/mcp and authorize access to your Via Kondado. Authentication is OAuth 2.1: the client registers through Dynamic Client Registration, or you paste a Bearer token. The endpoint exposes your Mercado Libre tables for the assistant to query, read-only.
3. Ask in plain language. From there, "show me the 10 best-selling listings in May with the margin of each" becomes a direct answer. The assistant writes the query, reads the tables and returns the number.

What can AI answer about your Mercado Libre sales?

With the tables in Via Kondado, the assistant answers questions that used to require exporting CSVs and building spreadsheets. Seven direct examples:

• Net revenue per listing. "What is the net revenue of each listing this month?" joins mercadolivre_orders with mercadolivre_orders_items: the assistant starts from paid_amount, subtracts taxes__amount, coupon__amount and each item's sale_fee. The result is what actually remained, not gross billing.
• ROAS per Ads campaign. The mercadolivre_ads_campaigns_daily table carries each campaign's metrics per day: cost, direct_amount, total_amount, roas, acos, cpc, ctr and cvr. The assistant ranks campaigns by return without you opening the ads manager. The window comes capped at 90 days - a limit of Mercado Libre's own Product Ads API, not of Kondado.
• Billed orders without an invoice. A LEFT JOIN of mercadolivre_orders with mercadolivre_orders_invoices where the invoice is missing returns the list of paid orders that still have no invoice issued. It is the report your accounting team asks for at close.
• Critical stock with rising sales. The daily snapshot in mercadolivre_items_stock joined with mercadolivre_orders_items shows which listings are selling fast on low stock - the priority restock list, with no guesswork.
• Complaint rate per category. mercadolivre_reclamacoes joined with mercadolivre_orders and mercadolivre_orders_items reveals which product category concentrates complaints, so you act on the cause and not the symptom.
• Recurring buyer tax ID. The buyer's tax ID is not in mercadolivre_orders: it lives in mercadopago_payments, in the payer_identification_number field. The assistant joins both tables by order and identifies your VIP buyers by tax ID, for your fiscal and relationship base.
• Same-SKU revenue across every channel. mercadolivre_orders_items joined with the Shopify and Bling order items, by SKU, sums the sale of the same product on Mercado Libre, Shopify and Bling into a single number.

A sample question to paste into ChatGPT or Claude with your Mercado Libre connected:

From my Mercado Libre tables, show net revenue per listing for May 2026:
start from paid_amount in mercadolivre_orders, subtract taxes__amount and coupon__amount,
and subtract each item's sale_fee in mercadolivre_orders_items.
Sort high to low and show the period total.

Why is invoice and tax-ID coverage the differentiator?

The difference between a generic answer and a reliable fiscal analysis comes down to two data points that only Kondado delivers ready for the assistant.

The first is the fiscal invoice (NFe). Kondado stores far more than "has an invoice or not". It downloads each order's invoice XML, parses the infNFe block and materializes the 44-digit access key, the number, the series, the issue date and per-item taxes (ICMS, PIS, COFINS), plus IPI at the invoice total, into the mercadolivre_orders_invoices and mercadolivre_orders_invoices_itens tables. The assistant answers "what is the number and key of order X's invoice?" directly - no marketplace catalog scraper holds this data.

The second is the buyer's tax ID. It is not in the order: it is in mercadopago_payments. Kondado replicates the Mercado Pago table with payer_identification_number ready to join with orders, letting the assistant build your buyer base by tax ID.

Two platform behaviors are worth knowing before drawing conclusions with AI. If your seller account lacks the Advertising permission on Mercado Libre, the Ads tables come back empty - that is an account permission matter, not missing data. And when the assistant queries Via Kondado in KSQL through the MCP, decimal values come out correct; auxiliary CSV conversions require normalizing the comma decimal separator, but that does not affect the direct query the assistant runs.

Official Mercado Libre MCP vs Kondado MCP: what is the difference?

There are two MCPs in the Mercado Libre world, and they are complementary. One answers about the public catalog; the other answers about your seller data.

The official Mercado Libre MCP serves whoever wants to read the marketplace from the outside. Kondado delivers the data that is yours - your sales, invoices, payments and campaigns - for ChatGPT and Claude to analyze.

How do you join Mercado Libre with Shopify, Bling and Meta Ads?

Anyone selling on more than one channel needs a consolidated number, and having everything in the same Via Kondado is where that pays off. Three direct joins:

• Multi-channel revenue per SKU. Joining mercadolivre_orders_items with the Shopify and Bling order items, by SKU, sums the sale of the same product on Mercado Libre, Shopify and Bling into a single number.
• Outbound invoice reconciliation. Joining the Mercado Libre invoice with Bling sales orders by order number closes the fiscal reconciliation between what sold and what was billed.
• Blended CAC. Adding the mercadolivre_ads_campaigns_daily spend to Meta Ads and Google Ads in the same Via Kondado delivers the combined acquisition cost across every channel, which the assistant computes on demand.

Frequently asked questions

Does Mercado Libre have an official MCP server? Yes, Mercado Libre has an official MCP server, but its scope is the public catalog (prices, availability and listing descriptions). To analyze your own sales, invoice, Mercado Pago and Ads data, the path is the Kondado MCP at https://mcp.kondado.io/mcp.

Can ChatGPT read my Mercado Libre orders? Yes, when your Mercado Libre is replicated by Kondado into Via Kondado. ChatGPT does not talk to the Mercado Libre API: it reads the mercadolivre_orders table (and the others) already materialized in Via Kondado, via the MCP endpoint.

Can I see my Mercado Libre invoice in ChatGPT? Yes. Kondado parses the invoice XML and materializes the number, series, 44-digit key and taxes into the mercadolivre_orders_invoices and mercadolivre_orders_invoices_itens tables, so the assistant answers about the fiscal invoice directly.

How do I connect Mercado Libre to Claude Desktop? You replicate Mercado Libre with Kondado into Via Kondado and point Claude Desktop to the https://mcp.kondado.io/mcp endpoint, authorizing access to your Via Kondado with OAuth 2.1 (Dynamic Client Registration or Bearer token).

Connecting your Mercado Libre to ChatGPT and Claude starts with one thing: having your 28 sales, invoice and Ads tables in Via Kondado, where the assistant can query them in full. That is what Kondado delivers. Start your free Kondado trial and run your first Mercado Libre analysis in ChatGPT today.