How to Connect Kondado to Claude (Web, Desktop, Claude Code)

Claude from Anthropic becomes a conversational data analyst when connected to Kondado. With the Model Context Protocol (MCP), you can query data from 100+ integrated sources — ERPs, CRMs, e-commerce, and marketing — using natural language, without leaving the chat. This guide covers three ways to connect: Claude Web (browser), Claude Desktop (app), and Claude Code (command line). Single endpoint https://mcp.kondado.io/mcp works for Claude Web, Desktop, and Code. Automatic OAuth 2.1 authentication — you just register the URL and log in to Kondado. Three modalities: Web (fastest), Desktop (daily use), Code (developers and agents). Bonus: Cursor IDE also accepts MCP. First question: "What tables do I have in Kondado?" to confirm the connection.

Who This Guide Is For

This tutorial is ideal if you:

• Are a developer or data analyst who wants to explore data without manual SQL
• Use Claude Desktop or Claude Code in your daily workflow
• Are an early adopter of AI tools and want to integrate business data
• Want to create automated agents that query data via Claude Code
• Seek a more analytical alternative to ChatGPT for data work

How the MCP Connection Works

The MCP (Model Context Protocol) is an authenticated channel that links Claude directly to your Via Kondado data — the SQL destination where your 100+ sources are replicated.

Data flow:

Data source (Shopify, Google Ads, etc.)
         ↓
    Kondado (replication)
         ↓
  Via Kondado (ready SQL)
         ↓
Claude + MCP (natural language queries)

Claude does not access your sources directly. It queries tables already prepared by Kondado — updated at the frequency you configured (daily, hourly, etc.). Via Kondado MCP endpoint:

https://mcp.kondado.io/mcp

Method 1: Claude Web (Browser)

Claude Web is the fastest way to get started — works in any browser, nothing to install.

Step 1: Open Settings → Connectors

Go to Settings → Connectors in the left sidebar of Claude Web. Scroll to the bottom and click "Add custom connector".

Step 2: Configure the Connector

In the "Add custom connector" modal, enter:

• Name: Kondado (or Via Kondado — just a label)
• Remote MCP server URL: https://mcp.kondado.io/mcp (include the /mcp at the end)
• Advanced settings: leave defaults — OAuth is auto-discovered

Click Add. Claude validates that the server responds.

Step 3: Trigger the First Call

Open a new chat and ask something that uses Kondado:

• "What tools do you have available from Via Kondado?"
• "List my Kondado tables."
• "How much did I spend on Google Ads last month?"

On the first call, Claude displays a card "Authentication required to use this tool" with a Connect button. Click Connect.

Step 4: Log in to Kondado

A pop-up window opens to the Kondado login screen (app.kondado.com.br). Log in with your email and password.

Step 5: Authorize and Choose Via Kondado

The "Authorize MCP access" screen appears:

1. Confirm you are the correct user ("Logged in as ...") 2. In the dropdown Choose a Via Kondado destination, select which Via Kondado Claude should query 3. Click Approve

Step 6: Confirmation

The window shows "Authentication complete" and closes automatically.

Step 7: Allow Tool Calls

Back in Claude, the pending tool call executes automatically. From now on, Claude will ask for permission ("Claude wants to use Run query from Kondado") with Always allow / Deny buttons.

Click Always allow if you want to stop seeing this pop-up for this tool.

Method 2: Claude Desktop (App)

Claude Desktop offers the best experience for daily use — integrates with your workflow with native notifications.

Configuration

1. Open Claude Desktop → Settings → Connectors 2. Click "Add custom connector" 3. Enter: - Name: Kondado - Remote MCP server URL: https://mcp.kondado.io/mcp 4. Confirm

Authentication

On the first call that uses Kondado, Claude Desktop opens your default browser to the same consent screen from Steps 4-6 of Claude Web. After authorizing, the token is saved locally and refreshes automatically.

Note on versions: Anthropic evolves the Claude Desktop interface. If your version requires a JSON configuration file instead of the Settings menu, use the format from the Claude Code section below (same URL, same automatic authentication).

Method 3: Claude Code (CLI for Developers)

Claude Code is Anthropic's CLI for terminal — ideal for developers, scripts, and automation.

Option A: Direct Command

claude mcp add kondado --transport http --url https://mcp.kondado.io/mcp

Option B: Configuration File

Add to your Claude Code settings.json:

{
  "mcpServers": {
    "kondado": {
      "type": "http",
      "url": "https://mcp.kondado.io/mcp"
    }
  }
}

CLI Authentication

On the first tool call that uses Kondado, Claude Code opens your browser to the same OAuth flow from Steps 4-6 of Claude Web. After authorizing, the token is saved locally and automatically renewed.

Bonus: Cursor IDE (VS Code with AI)

Cursor is a VS Code-based IDE with integrated AI that also supports MCP. If you develop and want to query data without leaving your editor, follow these steps:

Configuration in Cursor

1. Open Cursor → Settings (Ctrl+, or Cmd+,) 2. Search for "MCP" or go to Features → MCP 3. Click "Add MCP Server" 4. Configure: - Name: kondado - URL: https://mcp.kondado.io/mcp - Transport: HTTP 5. Save

Using in Cursor

In the Cursor chat (Ctrl+L or Cmd+L), you can ask:

• "Show my last 10 Shopify orders"
• "What's the ROI of my Meta Ads campaigns?"
• "Create a Python function that queries sales by category from Kondado"

Cursor combines your code context with Kondado data — useful for generating reports, validating hypotheses, or creating programmatic dashboards.

Practical Example: First Query on Your Data

After configuring any of the three modalities, test with these questions:

1. Explore Structure

What tables do I have available in Via Kondado?

2. Sales Analysis

How much revenue did I make from Shopify in the last 30 days, by product category?

3. Marketing vs Sales

Compare my Google Ads spend with my Shopify revenue last month.

4. Inventory Alert

Which products in my ERP have inventory below 10 units?

Claude converts your question to KSQL (Kondado's JSON query language), executes on Via Kondado, and presents the answer in natural language — with formatted tables, analysis, and suggestions.

Limitations and Important Considerations

v1 Limitations

• Read-only: MCP only allows queries — no write, update, or delete
• KSQL required: Queries use Kondado syntax (JSON), not raw SQL
• 1,000 rows max: Each execution returns up to 1,000 records
• One Via per session: Each OAuth session binds to a single Via Kondado

Best Practices

1. Switching Via Kondado: To alternate between destinations, go to Settings → Connectors, remove the connector and add it again — choosing another Via in the consent screen.

2. Token expired: Claude automatically renews via refresh token. If you see an authentication error, redo the connection (remove + add).

3. Tables not appearing: Verify you selected the correct Via Kondado in the authorization screen. The connector only sees tables from that specific destination.

4. Permission on every call: Click Always allow the first time for each tool to stop seeing the pop-up.

5. Pop-up blocked: Disable pop-up blockers for the Claude tab — the consent screen opens in a secondary window.

FAQ: Frequently Asked Questions

What is Kondado MCP in Claude?

It's an authenticated channel that links Claude directly to your Via Kondado data. Once configured, you ask in natural language ("list my tables", "how much did I spend on ads") and Claude automatically builds KSQL queries.

Do I need to pay for Claude to use MCP?

Custom MCP server configuration depends on Anthropic's current policy. If you see Settings → Connectors → Add custom connector in Claude Web, you can add Via Kondado. Claude Desktop and Claude Code accept the same configuration on any Anthropic account. Check your account for availability.

Can I connect more than one Via Kondado?

Each OAuth session binds to one Via Kondado. To alternate, remove the connector in Settings → Connectors and add it again, choosing another Via in the consent.

Does Claude see all my data? Is it secure?

Claude only executes queries you request and receives results via MCP. Access is authenticated by OAuth and limited to the Via Kondado you chose. MCP is read-only — no write operations are allowed. Keep your token in a secure place.

Does it work on mobile?

Claude Web works on mobile browsers. Claude Desktop is a desktop app. Claude Code requires a terminal.

Can I use with other IDEs besides Cursor?

Any IDE or tool that supports MCP can be configured with URL https://mcp.kondado.io/mcp and OAuth or legacy token authentication.

What is KSQL?

KSQL is Kondado's JSON query language. Instead of writing traditional SQL, you describe queries in JSON format — and Claude does this automatically when you ask in natural language.

Next Steps

Now that your Claude is connected to Kondado, explore:

• Via Kondado main article — understand the SQL destination behind MCP
• MCP Guide — details on OAuth vs legacy token
• ChatGPT + Kondado — compare with the OpenAI alternative
• Available sources — see the 100+ supported data sources

Start your 14-day free trial with Kondado, connect your data sources, and transform Claude into your personal business analyst — without writing a single line of code.

Start Free Trial →