Chat with your Mercado Libre data

AI to analyze Mercado Libre data with Claude and ChatGPT

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Mercado Libre
Works in Claude, ChatGPT and any MCP client

AI to analyze Mercado Livre data with Claude and ChatGPT

Chat directly with Claude, ChatGPT, or any MCP-compatible client to explore your Mercado Livre business metrics without writing a single query. Ask about daily sales trends across your product catalog, compare performance metrics between active ad listings, or investigate order fulfillment statuses and payment reconciliation details using simple conversational language. The AI interprets your natural language questions and retrieves specific answers from your replicated marketplace data, turning complex analysis into instant insights.

Kondado provides a direct integration with Mercado Livre that exposes 19 data pipelines through an MCP server, enabling Claude, ChatGPT, and other MCP clients to query your e-commerce metrics conversationally. The same replicated data also powers ready reports in Power BI and Looker Studio for visual monitoring.

Marketing analysts leverage this capability to evaluate campaign ROI and visitor engagement patterns across multiple listings, while e-commerce managers monitor inventory levels and daily store performance metrics to optimize stock decisions and pricing strategies. Finance teams query payment statuses, order values, and invoicing details for accurate revenue tracking and financial reconciliation, and operations specialists investigate shipment tracking numbers, buyer profiles, and complaint resolution statuses to improve customer satisfaction. Every department gains immediate analytical access through natural conversation, transforming complex data exploration into actionable business intelligence that drives faster decision-making.

The Mercado Livre data source offers 19 specialized pipelines covering every aspect of your marketplace operations, from initial product listings to comprehensive post-sale analytics and financial records. Query the Ads pipeline to analyze total visits and pricing strategies across your catalog, explore the Items daily performance pipeline to track sales velocity trends over specific time periods, or examine the Orders pipeline alongside Order Items to understand detailed purchase patterns and quantities sold per transaction. The Order Reviews pipeline reveals customer satisfaction ratings and detailed feedback comments for quality insights, while the Payments Mercado Pago pipeline provides comprehensive financial transaction details essential for reconciliation and cash flow analysis. Cross-analyzing the Order Shipments pipeline with the Order Buyers pipeline helps identify delivery trends by customer segment and geographic region, while linking the Items stock pipeline with the Items selling prices pipeline enables dynamic inventory valuation and profitability conversations directly in your AI chat. With automated updates operating on a configurable schedule that you control, your AI conversations always reference fresh, current marketplace data for accurate and timely business answers.

How to connect Mercado Libre to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
AI vocabulary

Mercado Libre tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

19
Tables
716
Fields
Ad-hoc questions
Ads
Table presents published ads with fields such as id, title, price, and description, along with metrics like total_visits_last_90_days.
Items
Table contains item details, including id, catalog_product_id, and attributes such as brand and model, along with pricing information.
Items: stock
Table provides information on available stock, including user_product_id, item_id, and quantity, along with availability type.
Items: daily performance
Table presents daily performance metrics of items, allowing analysis of sales and interactions over time.
Items: prices
Table displays pricing information for items, including id, selling price, and sale conditions, essential for marketing strategies.
Items: selling prices
Table provides details on the selling prices of items, including id and values, fundamental for market analysis.
Items: variations
Table presents variations of items, including attributes such as color and size, allowing better customer segmentation.
Store: daily performance
Table provides daily performance metrics of the store, including total sales and interactions, essential for evaluating results.
Payments Mercado Pago
Table contains information on payments, including id, status, and values, fundamental for financial management.
Orders
Table presents order details, including id, status, and information about buyers, essential for sales management.
Order Invoices
Includes fields such as id, seller_id, and total_amount, allowing detailed analysis of transactions and billed amounts.
Order Reviews
Contains information such as order_id, rating, and comment, facilitating the assessment of customer satisfaction and feedback on orders.
Order Buyers
Presents data such as buyer_id, buyer_email, and buyer_name, allowing analysis of buyer profiles and their contact information.
Order Context
Includes fields such as order_id, context_type, and context_value, providing insights into the conditions and circumstances of orders.
Order Shipments
Contains information such as shipment_id, tracking_number, and shipping_status, allowing tracking and management of shipments made.
Order Items
Includes data such as item_id, quantity, and price, facilitating the analysis of purchased products and their quantities.
Order Payments
Presents fields such as payment_id, payment_method, and payment_status, allowing analysis of payment methods and statuses for orders.
Order Sellers
Includes information such as seller_id, seller_name, and seller_rating, allowing analysis of seller performance and reputation.
Complaints
Contains fields such as complaint_id, order_id, and resolution_status, facilitating tracking and management of customer complaints.

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect Mercado Livre at app.kondado.com.br

Select Mercado Livre as your data source and choose the 'Via Kondado' destination so your data lands in a format ready for both AI querying and the Power BI or Looker Studio report templates.

2
Add Kondado MCP in Claude or ChatGPT

Open the connection settings in Claude Web or Desktop, or in ChatGPT, to add the Kondado MCP server and complete the OAuth authorization at app.kondado.com.br once, enabling immediate chat access without any CLI commands or coding.

3
Ask about Mercado Livre data in chat

Start asking questions about your marketplace metrics using natural language in the chat interface, or for ongoing visual monitoring, open one of the ready Power BI or Looker Studio report templates available with the same data.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

Marketing and Automation

Advertising and Media

E-commerce and Marketplaces

Financial and Payments

Support and Customer Service

Databases

Productivity and Collaboration

Social Media

User Analytics

Storage and Transfer

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What types of business questions can I ask Claude or ChatGPT about my Mercado Livre data?
You can ask about sales performance trends across specific date ranges, compare conversion rates between different ad listings, analyze customer review sentiments by product category, or investigate shipping delays and complaint resolution statuses. The AI interprets your natural language questions and queries the underlying 19 pipelines to provide analytical answers with specific metrics and counts.
How do I configure Claude or ChatGPT to access my Mercado Livre data through Kondado?
In Claude Web or Desktop, or directly in the ChatGPT interface, navigate to the connection settings and add the Kondado MCP server using the provided URL. The setup uses a graphical interface with no command line tools required, and you authorize access once through OAuth at app.kondado.com.br to establish the connection.
Does the AI have permission to execute actions on my Mercado Livre account or modify data?
No, the AI access is read-only for analytical purposes only. Claude, ChatGPT, and other MCP clients can query your replicated data to answer questions about orders, inventory, and payments, but they cannot create listings, update prices, process refunds, or perform any write operations back to your Mercado Livre store.
How frequently does the Mercado Livre data update for AI queries?
Data replicates on a configurable schedule that you set in Kondado, ensuring your AI conversations reference current information without manual refreshes. You can adjust the update frequency based on your operational needs, from frequent intervals for active sales periods to standard schedules for regular monitoring.
What ready report templates are available for visual Mercado Livre monitoring?
Kondado offers report templates for Power BI and Looker Studio that visualize the same Mercado Livre data available to the AI. These templates cover marketplace performance, sales analytics, and financial overviews, providing graphical charts and recurring monitoring capabilities alongside your conversational AI analysis.
What is the difference between analyzing Mercado Livre data in AI chat versus opening a ready report?
AI chat allows you to ask spontaneous, specific questions in natural language and explore data conversationally without predefined structures, ideal for deep-dive investigations. Ready reports in Power BI or Looker Studio provide fixed visual layouts with charts and graphs designed for recurring monitoring and standardized reporting across your team.
Can I use other MCP clients besides Claude and ChatGPT to analyze my Mercado Livre data?
Yes, while Claude and ChatGPT are the primary interfaces we showcase, any MCP-compatible client can connect to Kondado's server. This includes other AI assistants and business tools that support the Model Context Protocol open standard, giving you flexibility in how you access your marketplace analytics.

Try out all the features for free for 14 days