Keboola MCP Server Setup Guide

Requirements

• Keboola Storage API token
• Snowflake Read Only Workspace

Installation

Installing via Smithery

To install Keboola Explorer for Claude Desktop automatically via Smithery, run:

npx -y @smithery/cli install keboola-mcp-server --client claude
 

Manual Installation

1. Clone the repository and create a virtual environment:

   git clone https://github.com/keboola/keboola-mcp-server.git
    cd keboola-mcp-server
    python3 -m venv .venv
    source .venv/bin/activate
    

2. Install the package in development mode:

   pip3 install -e .
    

3. For development dependencies:

   pip3 install -e ".[dev]"
    

Claude Desktop Setup

1. Create or edit the Claude Desktop configuration file:

   • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
   • Windows: %APPDATA%Claudeclaude_desktop_config.json

2. Add the following configuration (adjust paths according to your setup):

   {
     "mcpServers": {
     "keboola": {
     "command": "/path/to/keboola-mcp-server/.venv/bin/python",
     "args": [
     "-m",
     "keboola_mcp_server",
     "--api-url",
     "https://connection.YOUR_REGION.keboola.com"
     ],
     "env": {
     "KBC_STORAGE_TOKEN": "your-keboola-storage-token",
     "PYTHONPATH": "/path/to/keboola-mcp-server/src",
     "KBC_SNOWFLAKE_ACCOUNT": "your-snowflake-account",
     "KBC_SNOWFLAKE_USER": "your-snowflake-user",
     "KBC_SNOWFLAKE_PASSWORD": "your-snowflake-password",
     "KBC_SNOWFLAKE_WAREHOUSE": "your-snowflake-warehouse",
     "KBC_SNOWFLAKE_DATABASE": "your-snowflake-database",
     "KBC_SNOWFLAKE_SCHEMA": "your-snowflake-schema",
     "KBC_SNOWFLAKE_ROLE": "your-snowflake-role"
     }
     }
     }
    }
    

3. Replace placeholders with your actual values:

   • /path/to/keboola-mcp-server with your actual path to the cloned repository
   • your-keboola-storage-token with your Keboola Storage API token
   • YOUR_REGION with your Keboola region (e.g., north-europe.azure)
   • your-snowflake-* with your Snowflake credentials

4. After updating the configuration:

   • Completely quit Claude Desktop (don’t just close the window)
   • Restart Claude Desktop
   • Look for the hammer icon in the bottom right corner, indicating the server is connected

Troubleshooting

• Check the logs in Claude Desktop for any error messages
• Verify your Keboola Storage API token is correct
• Ensure all paths in the configuration are absolute paths
• Confirm the virtual environment is properly activated and all dependencies are installed
• Make sure the PYTHONPATH points to the src directory

Cursor AI Setup

1. Create or edit the Cursor AI configuration file:

   • Location: ~/.cursor/mcp.json

2. Add one of the following configurations based on your preferred transport method:

   Option 1: Using Server-Sent Events (SSE)

   {
     "mcpServers": {
     "keboola": {
     "url": "http://localhost:8000/sse?storage_token=YOUR_STORAGE_TOKEN&snowflake_account=YOUR_ACCOUNT&snowflake_user=YOUR_USER&snowflake_password=YOUR_PASSWORD&snowflake_database=YOUR_DATABASE&snowflake_schema=YOUR_SCHEMA&snowflake_warehouse=YOUR_WAREHOUSE"
     }
     }
    }
    

   Option 2: Using Standard I/O (stdio)

   {
     "mcpServers": {
     "keboola": {
     "command": "/path/to/keboola-mcp-server/venv/bin/python",
     "args": [
     "-m",
     "keboola_mcp_server",
     "--transport",
     "stdio",
     "--api-url",
     "https://connection.YOUR_REGION.keboola.com"
     ],
     "env": {
     "KBC_STORAGE_TOKEN": "your-keboola-storage-token",
     "KBC_SNOWFLAKE_ACCOUNT": "your-snowflake-account",
     "KBC