Chat with your FTP data

AI to analyze FTP 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

FTP
You
How many rows are in the latest sales_export.csv file?
FTP Files
The sales_export.csv file contains 12,847 rows of transaction data from yesterday's upload.
Via Kondado MCP
You
What is the total row count across all CSV files this week?
CSV Data
Your FTP server processed 45,230 rows across all CSV files since Monday morning.
Via Kondado MCP
You
Which file has the most columns in yesterday's upload?
File Structure
The inventory_2024.csv file has 28 columns, making it the widest structure in your dataset.
Via Kondado MCP
You
How many unique files are stored in the FTP root directory?
File Inventory
There are 15 distinct CSV files currently available for analysis in your FTP storage.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze FTP data with Claude and ChatGPT

Chat with Claude, ChatGPT, or any MCP client to explore your FTP file contents without writing code. Ask how many rows are in yesterday’s CSV uploads, compare column structures across different files, or validate data completeness before processing. The AI reads your replicated file data and returns answers in seconds, turning raw FTP storage into accessible business insights.

Kondado replicates FTP data into 1 pipeline accessible via MCP, enabling Claude, ChatGPT, and other clients to analyze your CSV files through chat. The same data also powers ready dashboards in Power BI and Looker Studio for visual monitoring.

Operations managers, data analysts, and finance teams benefit from instant file validation without downloading individual documents. Simply ask about row counts, column variations, or file basenames to verify data quality. Compare weekly upload volumes or identify missing fields across your FTP directory using conversational queries that eliminate manual file inspection.

I prefer ready dashboards

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

View FTP dashboards →

I want to ask the AI

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

View MCP setup →

The CSV pipeline below exposes every row and column from your FTP files, enabling granular file content analysis through natural language chat.

Query this pipeline to inspect row_number totals for specific __file_basename entries, analyze column_number distributions across different uploads, or compare file dimensions between yesterday and today. Investigate schema variations by examining which files contain the most columns, or validate data completeness by checking for unexpected row counts. While FTP provides this single comprehensive pipeline, you can contextualize these file metrics alongside other business data in your Kondado workspace for deeper operational insights. Data refreshes on a configurable schedule, ensuring your chat queries always reference the latest file uploads.

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

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

1
Table
8
Fields
∞
Ad-hoc questions
CSV
Table includes fields such as row_number, column_number, and __file_basename, enabling analysis of data from files with varying columns.
Full docs on the wiki → Connect FTP now →

How to connect and use AI with your data

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

1
Connect FTP data source

Log in to app.kondado.com.br and connect your FTP server as a data source, selecting a 'Via Kondado' destination so your file data lands ready for AI access and the available dashboard templates.

2
Add Kondado MCP in Claude or ChatGPT

Open the connection settings in Claude Web or Desktop, or in ChatGPT, and add the Kondado MCP server. Authorize once via OAuth at app.kondado.com.br to enable chat-based analysis without CLI commands or coding.

3
Chat about FTP or open dashboards

Ask questions in natural language about your CSV files, row counts, and column structures. For recurring visual monitoring, open the ready Power BI or Looker Studio dashboard templates powered by the same 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)
Olist Tiny Olist Tiny
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
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 or ChatGPT answer about my FTP data in chat? ▼
They can analyze CSV file contents stored on your FTP server, count total rows per file, identify column structure variations, and validate data completeness by querying the row_number, column_number, and __file_basename fields available through the MCP connection.
How do I configure Claude or ChatGPT to access my Kondado FTP data? ▼
In Claude Web or Desktop, or in the ChatGPT interface, navigate to the connection settings and add the Kondado MCP server. You will authorize access once via OAuth at app.kondado.com.br, granting the AI read-only access to your replicated FTP pipelines.
Can the AI execute file transfers or write data back to my FTP server? ▼
No, the interaction is read-only analytical chat. Claude and ChatGPT can query and analyze your file contents and metadata but cannot upload, delete, or modify files on your FTP server.
How often is the FTP data updated for AI queries? ▼
Data replication runs on a configurable schedule you set in Kondado, ensuring the AI provides answers based on recent file uploads rather than outdated information.
Which dashboard templates are available for visual FTP monitoring? ▼
Kondado offers ready report templates in Power BI and Looker Studio that visualize the same CSV file metrics and row structures you can query via chat, providing visual monitoring alongside conversational analysis.
What is the difference between asking the AI about FTP data and opening a ready dashboard? ▼
Chatting with Claude or ChatGPT allows exploratory, on-demand questioning about specific files and row-level details, while Power BI and Looker Studio templates provide recurring visual monitoring of file volumes and upload trends.
Can I use other AI clients besides Claude and ChatGPT to analyze my FTP data? ▼
Yes, any MCP-compatible client can connect to Kondado. While Claude and ChatGPT are the most popular options, other MCP clients also work with the same OAuth authentication process.

Try out all the features for free for 14 days