Back to Home
keboola icon

mcp-server

by keboola

Overview

Keboola MCP Server acts as an open-source bridge connecting Keboola projects with modern AI agents (e.g., Claude, Cursor, CrewAI, LangChain). It exposes Keboola features like data storage access, SQL transformations, job triggers, and data app management as callable tools for AI assistants, enabling them to interact with and manage data in Keboola without manual glue code.

Installation

Run Command
python -m keboola_mcp_server

Environment Variables

  • KBC_STORAGE_API_URL
  • KBC_TOKEN
  • OAUTH_CLIENT_ID
  • OAUTH_CLIENT_SECRET
  • OAUTH_SERVER_URL
  • KBC_MCP_SERVER_URL
  • KBC_OAUTH_JWT_SECRET
  • KEBOOLA_MCP_SERVER_WORKSPACE_SCHEMA
  • KEBOOLA_MCP_SERVER_OAUTH_LOG_ALL
  • KEBOOLA_MCP_SERVER_DEBUG_MODE

Security Notes

Critical SQL Injection Risk: The `query_data` tool (used in `tools/sql.py` and potentially injected into `data_apps`) directly passes user-provided SQL queries to the backend without explicit sanitization by the tool itself. If AI agents construct these queries from untrusted user input, it creates a severe SQL injection vulnerability. High Arbitrary Code Execution Risk: The `modify_data_app` tool accepts `source_code` as input, which is then executed as a Streamlit application. An AI agent, if compromised or given malicious instructions, could inject arbitrary Python code into these data apps, potentially leading to unauthorized actions within the sandboxed environment. Medium OAuth Redirect URI Whitelist Concerns: The OAuth provider validates `https` redirect URIs against a predefined whitelist but allows arbitrary custom URI schemes. While custom schemes typically require client-side registration, this approach could be exploited if a local system has a vulnerable handler for a custom scheme or if the `https` whitelist is incomplete. Low Risk from Debugging Flag: The `KEBOOLA_MCP_SERVER_OAUTH_LOG_ALL` environment variable, if enabled in a production environment, could expose sensitive OAuth token details in server logs.

Similar Servers

Stats

Interest Score47
Security Score1
Cost ClassMedium
Avg Tokens2000
Stars80
Forks21
Last Update2026-01-19

Tags

AI Agent IntegrationKeboola Data PlatformETL OrchestrationOAuthSQL QueryingData AppsMetadata ManagementDevelopment Branches