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
python -m keboola_mcp_serverEnvironment 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
klavis
Develop and deploy AI agents that interact with a wide array of web services (e.g., Gmail, YouTube, LinkedIn, Supabase, Salesforce, Kubernetes) through a standardized Model Context Protocol (MCP), often orchestrated by an intelligent routing layer like Strata.
metorial-platform
An open source integration platform for agentic AI, connecting AI models to external APIs, data sources, and tools.
tableau-mcp
The Tableau MCP server provides a standardized interface for AI tools to interact with Tableau Cloud or Server, enabling AI-powered analytics, data exploration, and insight generation from Tableau workbooks, views, datasources, and Pulse metrics.
mcp-server-datahub
Enables AI agents to interact with DataHub for comprehensive data discovery, governance, lineage exploration, and SQL query generation across an organization's data ecosystem.