Chat with your Olist Tiny data

AI to analyze Olist Tiny 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

Olist Tiny
You
What were my total Olist Tiny sales yesterday?
Olist Tiny
Your Olist Tiny store processed R$ 47.850 across 23 orders yesterday, with an average ticket of R$ 2.080.
Via Kondado MCP
You
Which products have the lowest stock coverage this week?
Product Stock
47 SKUs in your Olist Tiny catalog show less than 5 units available, including wireless headphones with only 2 items left.
Via Kondado MCP
You
How does last month's revenue compare to the previous month?
Orders
Olist Tiny revenue grew +12% MoM to R$ 1.245.000, driven by a 18% increase in Order Details volume from repeat customers.
Via Kondado MCP
You
How many CRM issues are currently open awaiting resolution?
CRM Issues
You have 14 active tickets in Olist Tiny CRM Issues, with 3 marked as high priority and an average resolution time of 4.2 days.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze Olist Tiny data with Claude and ChatGPT

Ask Claude, ChatGPT, or any other MCP client about your Olist Tiny data using natural language chat. Query total sales from Orders and Order Details to track daily revenue, check outstanding balances in Accounts Receivable for cash flow visibility, or compare current Product Stock levels against recent invoices to identify replenishment needs. The AI reads your replicated ERP data and returns precise answers instantly, eliminating the need to navigate complex menus or build manual spreadsheets.

Kondado replicates data from Olist Tiny into 15 pipelines accessible via the open MCP standard, enabling direct analytical chat in Claude, ChatGPT, and other compatible clients. The same data also powers ready reports in Power BI and Looker Studio for teams who prefer visual dashboard monitoring.

E-commerce managers track order status and fulfillment metrics by asking about the Orders and Order Details pipelines to monitor delivery performance. Finance teams query Accounts Payable and Accounts Receivable to manage working capital and payment schedules through simple conversational questions. Marketing and support analysts combine CRM Issues with Contacts data to understand ticket resolution trends and customer satisfaction patterns. All business users gain immediate operational insights without technical setup, using the chat interface they already use daily.

I prefer ready dashboards

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

View Olist Tiny dashboards →

I want to ask the AI

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

View MCP setup →

The fifteen pipelines below contain every field needed to run your Olist Tiny operations through conversational analysis. Query the Orders and Order Details pipelines to calculate average order values and identify peak sales periods, or examine Accounts Receivable alongside Invoices to understand payment collection cycles and outstanding customer balances. The CRM Issues and CRM Issues Details pipelines reveal support ticket volumes and resolution timelines, while Product Stock combined with Products data shows inventory turnover and category performance.

Combining multiple pipelines unlocks deeper cross-functional insights, such as correlating sales velocity from Order Details with available Product Stock to forecast replenishment needs. Accounts Payable Details paired with Accounts Receivable Details give finance teams a complete view of cash flow timing across vendors and customers. Since Kondado updates your data on a configurable schedule, every question in Claude or ChatGPT reflects the latest transactions and inventory changes from your ERP.

How to connect Olist Tiny 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

Olist Tiny 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.

15
Tables
792
Fields
∞
Ad-hoc questions
CRM Issues
Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue in the CRM.
CRM Issues Details
Presents detailed information such as cliente_codigo, cliente_nome, and cliente_cidade, providing a comprehensive view of issues and their respective clients.
Accounts Payable
Contains data such as id, data_emissao, and valor, allowing effective management of accounts payable and their respective statuses.
Accounts Receivable
Includes information on receivables such as id, data_emissao, and saldo, facilitating the tracking of revenues to be received.
Contacts
Presents data such as cliente_id_cliente, cliente_nome, and cliente_email, allowing effective management of contacts and their information.
Accounts Payable Details
Includes fields such as id, data_vencimento, and historico, providing a detailed view of accounts payable and their conditions.
Accounts Receivable Details
Presents information such as id, data_vencimento, and saldo, allowing detailed control of accounts receivable.
Invoice Details
Includes fields such as id, numero_doc, and data_emissao, providing a detailed view of issued invoices.
Invoice Details: XML
Presents information in XML format, including fields such as id and xml_data, allowing technical analysis of invoices.
Order Details
Includes fields such as id, data_pedido, and valor_total, providing a comprehensive view of orders placed.
Product Stock
Contains information about the available quantity of products, including fields such as id, product name, and stock balance.
Invoices
Records details of issued invoices, including fields such as id, issue date, and customer name.
Orders
Includes information about placed orders, with fields such as id, order date, and order status.
Products
Presents data about registered products, including id, name, and selling price.
Products: grid
Provides a grid view of products, with fields such as id, name, and category.
Full docs on the wiki → Connect Olist Tiny now →

How to connect and use AI with your data

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

1
Connect Olist Tiny on Kondado

Log in at app.kondado.com.br, add Olist Tiny as a data source, and select a Via Kondado destination. Your ERP data lands ready for AI access and for the Power BI and Looker Studio dashboard templates.

2
Add Kondado MCP in Claude or ChatGPT

In Claude Web or Desktop, or in ChatGPT, open the connection settings to add the Kondado MCP server and authorize once via OAuth. The setup is identical in both clients and requires no command line tools or JSON configuration.

3
Ask about Olist Tiny in chat

Start asking natural language questions about your Orders, Accounts Receivable, or Product Stock data. For visual recurring monitoring of KPIs, open a ready Power BI or Looker Studio dashboard template using the same replicated data.

Other connectors with AI via MCP

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

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

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

What business questions can Claude answer about my Olist Tiny sales data? ▼
Claude can calculate total revenue from the Orders pipeline for any date range, compare performance across product categories using Order Details, and identify top-selling items by volume. You can ask about average order values, sales trends month-over-month, or correlation between invoice issuance dates and actual payment receipt in Accounts Receivable.
How do I configure ChatGPT to access my Olist Tiny data through Kondado? ▼
Open the connection settings in ChatGPT, add the Kondado MCP server using the provided URL, and complete the OAuth authorization at app.kondado.com.br. This one-time setup grants ChatGPT read access to your replicated Olist Tiny pipelines without requiring API keys or technical configuration.
Can the AI execute actions in Olist Tiny like creating invoices or updating stock? ▼
No, the AI provides read-only analytical chat based on your replicated data. It cannot create invoices, post accounting entries, modify Product Stock levels, or execute any write operations back to Olist Tiny. For operational tasks, continue using your ERP interface directly.
How does authentication work when connecting Claude to Olist Tiny data? ▼
After adding the Kondado MCP server in Claude Web or Desktop settings, you authorize the connection once via OAuth at app.kondado.com.br. This secure browser-based flow links your Kondado account to Claude without sharing passwords or API credentials directly with the AI client.
How often is the Olist Tiny data updated for AI queries? ▼
Kondado replicates your Olist Tiny data on a configurable schedule, ensuring Claude and ChatGPT access current information. You set the frequency based on your operational needs, from frequent updates for high-volume stores to daily refresh for standard monitoring.
What dashboard templates are available for Olist Tiny data? ▼
Kondado offers ready reports in Power BI and Looker Studio that use the same replicated Olist Tiny data as the AI chat. These templates provide visual monitoring of sales performance, accounts receivable aging, and inventory levels for recurring business reviews.
What is the difference between asking the AI about Olist Tiny and opening a ready dashboard? ▼
AI chat in Claude or ChatGPT answers specific ad-hoc questions using natural language, such as "What was our accounts payable balance last Tuesday?" Ready dashboards in Power BI or Looker Studio display pre-built visual reports optimized for recurring monitoring and team presentations. Both use identical underlying data from Kondado.
Can I use other MCP clients besides Claude and ChatGPT to analyze Olist Tiny data? ▼
Yes, any MCP-compatible client can connect to Kondado to query your Olist Tiny pipelines. While Claude and ChatGPT are the most popular interfaces for business users, other MCP clients also work with the same OAuth authentication and pipeline access.

Try out all the features for free for 14 days