Chat with your Granatum data

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

Granatum
You
What is my current total balance across all Granatum bank accounts?
Bank Accounts
Your consolidated balance across all bank accounts is R$ 47.890,50 as of the latest replication.
Via Kondado MCP
You
How many transactions are overdue this month in Granatum?
Transactions
You currently have 23 overdue transactions totaling R$ 12.450,00 with due dates passed.
Via Kondado MCP
You
Which cost center generated the highest revenue last quarter?
Cost Centers
The Operations cost center led with R$ 156.780,00 representing 42% of total quarterly revenue.
Via Kondado MCP
You
What percentage of clients prefer bank transfer payments?
Payment Methods
68% of your active clients use bank transfer as their primary payment method in Granatum.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze Granatum data with Claude and ChatGPT

Chat with Claude, ChatGPT, or any MCP client to explore your Granatum financial data using natural language. Ask about cash flow trends across specific periods, compare monthly revenues between different cost centers, or identify which payment methods drive the highest transaction volumes in your business. The AI reads your replicated Granatum data and returns instant insights without you writing a single query or formula.

Kondado replicates data from Granatum through a direct connection, exposing 6 tables with 83 fields via an MCP server compatible with Claude, ChatGPT, and other MCP clients. This same data also powers ready dashboards in Power BI and Looker Studio for visual monitoring.

Finance managers and operations teams benefit most from this conversational analytics approach. You can ask Claude about overdue transactions organized by client segment, query ChatGPT for detailed category-wise spending comparisons, or explore profit center performance trends across multiple quarters. Business users get precise answers to specific financial questions in seconds, turning complex Granatum data into actionable intelligence through simple, intuitive chat.

I prefer ready dashboards

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

View Granatum dashboards →

I want to ask the AI

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

View MCP setup →

The six data pipelines available from Granatum unlock comprehensive financial analysis when queried through your AI assistant. Ask about current balances across all Bank Accounts, dive into specific transaction values and due dates from the Transactions table, or analyze detailed spending patterns using the Categories data. The Cost and Profit Centers table reveals hierarchical financial performance across departments, while Payment Methods and Clients tables help you understand exactly which channels and customers drive your revenue growth.

Cross-reference Transactions with Categories to identify your highest-expense segments by color-coded groups, or join Clients with Payment Methods to see which customers prefer specific payment types and optimize your collection strategy. With automated updates running on a configurable schedule, your AI chat always references the freshest Granatum figures for accurate financial analysis and informed decision making.

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

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

6
Tables
83
Fields
∞
Ad-hoc questions
Bank Accounts
Table contains information about bank accounts, including fields such as id, description, and balance.
Transactions
Table records financial transactions with fields such as id, description, value, and due date.
Categories
Table lists categories with fields such as id, description, and color, allowing for the organization of transactions.
Cost and Profit Centers
Table presents cost and profit centers with fields such as id, description, and parent_id for hierarchy.
Payment Methods
Table details payment methods with fields such as id and description, facilitating transaction management.
Clients
Table contains client data, including fields such as name, email, phone, and address.
Full docs on the wiki → Connect Granatum now →

How to connect and use AI with your data

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

1
Connect Granatum and pick destination

Log in to app.kondado.com.br to set up your Granatum data source and select a "Via Kondado" destination. This replicates your financial data and makes it available for AI chat analysis and for the Power BI and Looker Studio dashboard templates.

2
Add Kondado MCP in Claude or ChatGPT

Open Claude (Web or Desktop) or ChatGPT, navigate to the connection settings, and add the Kondado MCP server. Authorize access once via OAuth at app.kondado.com.br using the graphical interface, with no CLI commands needed.

3
Chat about data or open dashboards

Start asking questions in natural language about your Bank Accounts, Transactions, or Cost Centers. For visual recurring 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
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 I ask Claude about my Granatum data? ▼
You can ask Claude about cash flow trends across specific date ranges, compare transaction volumes between different cost centers, identify top clients by payment frequency, or analyze which categories consume the largest portion of your budget. The AI interprets your natural language questions and queries the replicated Granatum tables to return specific figures and comparisons.
How do I connect ChatGPT to analyze Granatum financial data? ▼
In your ChatGPT connection settings, add the Kondado MCP server and authorize access via OAuth at app.kondado.com.br. This one-time authorization links your Granatum data source to ChatGPT, allowing the AI to read your financial data and answer questions in chat without any coding or command line setup.
Does the AI write data back to Granatum or is it read-only? ▼
The AI access is read-only for analytical purposes only. Claude, ChatGPT, and other MCP clients can query your Bank Accounts, Transactions, Categories, and other Granatum tables to provide insights, but they cannot create transactions, update balances, or modify any data in your Granatum system.
How often does the Granatum data update in the AI chat? ▼
Updates occur on a configurable schedule that you set in Kondado, ensuring the AI references near-current financial data during your conversations. You control the replication frequency based on your business needs, from frequent updates for active monitoring to daily refreshes for periodic analysis.
What is the difference between asking the AI in chat and using the Power BI dashboard templates? ▼
Chatting with Claude or ChatGPT provides immediate, specific answers to ad-hoc questions like "What was my revenue last Tuesday?" while the Power BI and Looker Studio templates offer persistent visual dashboards for recurring monitoring of KPIs and trends. The same Granatum data powers both experiences, with chat serving exploratory analysis and dashboards serving visual tracking.
Which Granatum tables are available for AI analysis through Kondado? ▼
Kondado exposes six Granatum tables via MCP: Bank Accounts with balance information, Transactions with values and due dates, Categories for spending organization, Cost and Profit Centers for hierarchical analysis, Payment Methods for channel insights, and Clients for customer data. All 83 fields across these tables are queryable through natural language chat.
Do I need technical skills to set up Claude or ChatGPT with Granatum data? ▼
No coding or technical expertise is required. Both Claude (Web and Desktop) and ChatGPT offer graphical interfaces where you simply add the Kondado MCP server URL and complete OAuth authorization at app.kondado.com.br. The entire setup happens through point-and-click configuration without CLI commands or JSON editing.

Try out all the features for free for 14 days