Chat with your VTEX data

AI to analyze VTEX data with Claude and ChatGPT

Get started for free

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

or sign up with your email

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

VTEX

You

How many orders did we process yesterday from VTEX?

VTEX Orders

Your VTEX store processed 1,247 orders yesterday with an average order value of R$ 342.

Via Kondado MCP

You

Which SKU has the highest stock level in warehouse SP01?

VTEX Stock

SKU VT-8842-XL currently holds the highest stock with 3,450 units available in warehouse SP01.

Via Kondado MCP

You

What was the revenue impact of the SUMMER20 coupon this month?

VTEX Coupons

The SUMMER20 coupon drove R$ 89,450 in attributed revenue across 234 orders this month.

Via Kondado MCP

You

Which affiliate channel generated the most orders last week?

VTEX Marketing

Affiliate partner_site_br generated 456 orders last week, representing 23% of total volume.

Via Kondado MCP

Works in Claude, ChatGPT and any MCP client

AI to Analyze VTEX Data with Claude and ChatGPT

Connect your VTEX store to Kondado and start asking Claude, ChatGPT, or any other MCP client about your e-commerce performance in plain English. Query daily sales trends from your Orders pipeline, check current inventory levels across multiple warehouses, or analyze which coupon campaigns generated the highest revenue during specific promotional periods. The AI reads your replicated VTEX data and returns instant, actionable insights without requiring you to write SQL or navigate complex admin panels.

Kondado replicates data from VTEX into a structured format accessible via MCP server, enabling Claude, ChatGPT, and compatible clients to query 17 distinct pipelines spanning 432 fields including Orders, Stock, Coupons, and SKUs. The same replicated data also powers ready dashboard templates in Power BI and Looker Studio for visual monitoring.

E-commerce managers can ask about order status distribution and identify shipping bottlenecks by querying Shipping Data of Orders, while marketing analysts investigate UTM campaign attribution through Marketing Data of Orders and Promotions pipelines. Finance teams reconcile daily revenue by questioning Payments: Order Transactions, and operations specialists prevent stockouts by monitoring Stock and SKUs data through simple chat commands. Every department receives precise, data-backed answers tailored to their specific VTEX business workflows through intuitive natural language conversations.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your VTEX data by Kondado in minutes.

View VTEX dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your VTEX data in natural language.

View MCP setup →

The pipelines below contain every data point available for AI analysis through your MCP connection. Query the Orders pipeline to track conversion rates and average order values over time, or examine Order Items to identify your best-selling SKUs by volume and revenue. The Stock and SKUs: Prices pipelines reveal inventory health and pricing strategies, while Marketing Data of Orders connects sales to specific affiliate campaigns and UTM parameters for attribution analysis. Combine data across multiple pipelines to uncover deeper insights, such as correlating coupon usage from the Coupons pipeline with actual order values to calculate true discount impact, or linking Shipping Data of Orders with Orders: Totals to analyze delivery costs against revenue. Because Kondado updates your VTEX data on a configurable schedule, your AI assistant always provides answers based on fresh, current information rather than stale exports.

How to connect VTEX 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

Detailed guide: Claude Detailed guide: ChatGPT

AI vocabulary

VTEX 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.

Tables

432

Fields

∞

Ad-hoc questions

Coupons

Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.

Stock

Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.

Master Data

Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.

Orders

Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.

Shipping Data of Orders

Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.

Marketing Data of Orders

Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.

Order Details

Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.

Logistics Information of Orders

Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.

Order Items

Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.

Payments: Order Transactions

Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.

Orders: Fees and Benefits

Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.

Orders: Totals

Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.

Products

Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.

Promotions

Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.

SKUs

Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.

SKUs: Kits

Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.

SKUs: Prices

Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.

Full docs on the wiki → Connect VTEX now →

How to connect and use AI with your data

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

Connect VTEX to Kondado

Connect your VTEX data source on Kondado at app.kondado.com.br and select a 'Via Kondado destination' so your data lands ready for AI access and for the Power BI or Looker Studio dashboard templates.

Add Kondado MCP Server

In Claude (Web or Desktop) or ChatGPT, add the Kondado MCP server in the connection settings and authorize once via OAuth at app.kondado.com.br. The setup process is identical in both clients and requires no command line tools or code editing.

Query Data or Open Dashboards

Ask questions in chat using natural language about your VTEX orders, inventory, or campaigns. For visual recurring monitoring, open a ready Power BI or Looker Studio dashboard template populated with the same replicated data.

Other connectors with AI via MCP

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

Related on Kondado

Frequently asked questions about AI

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

What specific business questions can I ask Claude or ChatGPT about my VTEX store? ▼

You can ask about sales performance trends, inventory levels by warehouse, order status distributions, coupon redemption rates, and shipping delay patterns. The AI analyzes your replicated Orders, Stock, Coupons, and Shipping Data pipelines to return specific metrics like conversion rates or top-performing SKUs without requiring technical query languages.

How do I configure Claude or ChatGPT to access my VTEX data through Kondado? ▼

In Claude (Web or Desktop) or ChatGPT, navigate to the connection settings and add the Kondado MCP server using the provided URL. You will authorize access once via OAuth at app.kondado.com.br, granting the AI read permissions to your replicated VTEX pipelines. The entire setup uses graphical interfaces with no command line tools or JSON configuration required.

Can the AI execute actions on my VTEX store or write data back to the platform? ▼

No, the integration provides read-only analytical access for chat-based insights. Claude, ChatGPT, and other MCP clients can query your Orders, Stock, and Payments data to answer questions, but cannot create orders, update inventory, or modify prices in your VTEX admin. This ensures safe exploration of business metrics without risk to live operations.

How often is the VTEX data updated for AI querying? ▼

Kondado replicates your VTEX data on a configurable schedule that you control, ensuring your AI assistant works with recent information rather than outdated snapshots. Update frequency can be adjusted based on your business needs, keeping your chat queries about orders, stock levels, and campaign performance timely and relevant.

What dashboard templates are available for VTEX data besides the AI chat? ▼

Kondado offers ready report templates in Power BI and Looker Studio that visualize the same replicated VTEX data used for AI chat. These templates provide pre-built views of sales funnels, inventory status, and marketing attribution for users who prefer traditional dashboard monitoring over conversational analysis.

What is the difference between asking the AI in chat and opening a ready dashboard? ▼

The AI chat provides flexible, on-demand answers to specific business questions using natural language, such as "What was our revenue last Tuesday?" or "Which coupons performed best this month?" Ready dashboards in Power BI or Looker Studio offer fixed visual layouts for recurring monitoring of standard KPIs, updated automatically with the same underlying VTEX data.

Do I need technical skills or coding knowledge to set up the AI connection? ▼

No coding is required. The setup involves connecting VTEX to Kondado through the web interface, then adding the Kondado MCP server in Claude or ChatGPT settings using the GUI-based configuration. Authorization happens via standard OAuth in your browser at app.kondado.com.br, making the process accessible to business users without developer assistance.

Can I use other AI assistants besides Claude and ChatGPT with my VTEX data? ▼

Yes, any MCP-compatible client can connect to your Kondado VTEX data, including other emerging AI assistants and analytical platforms that support the Model Context Protocol. While Claude and ChatGPT are the most popular options showcased, the open MCP standard ensures flexibility to use your preferred analytical interface.

Try out all the features for free for 14 days

Get started for free

Get started for free

Get started for free

AI to analyze VTEX data with Claude and ChatGPT

Get started for free

AI to Analyze VTEX Data with Claude and ChatGPT

I prefer ready dashboards

I want to ask the AI

VTEX tables and metrics available via Kondado

How to connect and use AI with your data

Connect VTEX to Kondado

Add Kondado MCP Server

Query Data or Open Dashboards

Other connectors with AI via MCP

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

Related on Kondado

Frequently asked questions about AI