# MCP

> MCP is an open-source MCP server for analytics and data. Keboola's MCP server to query storage, build SQL transformations and run jobs. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** API, CLI, self-hosted
- **Repository:** https://github.com/keboola/mcp-server
- **MCP Registry name:** com.keboola/mcp
- **Categories:** [analytics and data](https://ai-powered.com/categories/analytics-and-data), [databases](https://ai-powered.com/categories/databases)
- **Listing updated:** 2026-11-14

## About

Keboola MCP Server is the open-source bridge between a Keboola data project and AI clients such as Cursor, Claude, Windsurf, VS Code, CrewAI, LangChain and Amazon Q. The easiest route is the hosted remote server on each multi-tenant Keboola stack, copied from the project's MCP Server settings and authenticated with OAuth. A local install from PyPI as `keboola-mcp-server` is also available.

Its feature areas are storage (query tables, manage descriptions), components, SQL transformations written in natural language, jobs, conditional and orchestrator flows, data apps (including Streamlit), metadata search, and development branches so work stays out of production.

HTTP connections can be restricted with headers: allow or disallow named tools, or force read-only mode. Branch scoping uses an `X-Branch-Id` header; without it the production branch is used. Project selection happens in the conversation after login.

## Features

- **Storage queries:** Query tables directly and manage table and bucket descriptions.
- **SQL transformations:** Create SQL transformations from natural language.
- **Jobs and flows:** Run components and transformations, inspect job details and build workflow pipelines.
- **Data apps:** Create, deploy and manage data apps, including Streamlit apps.
- **Dev branch scoping:** Keep operations inside a development branch away from production.
- **Tool access control:** Allow, disallow or restrict to read-only tools using HTTP headers.

## Good for

- Ask an assistant to explain what a Keboola transformation does
- Build a SQL transformation from a plain-language request
- Trigger a job and read its execution details
- Deploy a data app over storage data
- Give a read-only connection to an analyst

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http mcp https://mcp.us-east4.gcp.keboola.com/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://mcp.us-east4.gcp.keboola.com/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp": {
      "url": "https://mcp.us-east4.gcp.keboola.com/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp": {
      "type": "http",
      "url": "https://mcp.us-east4.gcp.keboola.com/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp": {
      "serverUrl": "https://mcp.us-east4.gcp.keboola.com/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp": {
      "type": "http",
      "url": "https://mcp.us-east4.gcp.keboola.com/mcp"
    }
  }
}
```

## FAQ

### How do I connect?

Copy your server URL from Project Settings, MCP Server tab, paste it into your client and log in with your Keboola account.

### Can I make it read-only?

Yes, with the X-Read-Only-Mode header set to true.

### How do I avoid touching production?

Send the X-Branch-Id header with a development branch ID.

### Is it open source?

The README calls it an open-source bridge; a PyPI package is available.

### Is MCP free?

Yes. MCP is open source, so you can use and self-host it for free.

### How do I add MCP to Claude Code?

Run this command in your terminal: claude mcp add --transport http mcp https://mcp.us-east4.gcp.keboola.com/mcp

### What are the best alternatives to MCP?

The closest alternatives to MCP are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, dashboard-icons, Tapetide - Indian Stock Market MCP and Midplane.

## Where this comes from

- Description: written from the project's README.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Google Ads + Meta Ads + SEO/GEO MCP](https://ai-powered.com/mcp/google-ads-meta-ads-seo-geo-mcp): Google Ads + Meta Ads + SEO/GEO MCP is a freemium MCP server for marketing and seo.
- [dashboard-icons](https://ai-powered.com/mcp/dashboard-icons): dashboard-icons is an open-source MCP server for analytics and data.
- [Tapetide - Indian Stock Market MCP](https://ai-powered.com/mcp/tapetide-indian-stock-market-mcp): Tapetide - Indian Stock Market MCP is a freemium MCP server for finance and payments.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [World Monitor](https://ai-powered.com/mcp/world-monitor): World Monitor is a freemium MCP server for analytics and data.
- [DataArcus for Power BI](https://ai-powered.com/mcp/dataarcus-for-power-bi): DataArcus for Power BI is a free MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.

---
Source: https://ai-powered.com/mcp/mcp-mwenadm1
