Cloudera Iceberg MCP Server (via Impala)

by peterableda

206 downloads
Not rated
GitHub

About

A Model Context Protocol server that provides read-only access to Iceberg tables via Apache Impala. It enables LLMs to inspect database schemas and execute read-only SQL queries.

Details

Author
peterableda
Downloads
206
Categories
Other

- execute_query: Run any SQL query on Impala and return results as JSON.
- get_schema: List all tables available in the current database.
- Read‑only access to Iceberg tables.
- Designed for LLM integration (Claude Desktop, LangChain, OpenAI SDK).
- Uses Impala as the query engine.

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name Cloudera Iceberg MCP Server (via Impala)
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Configure it in Claude Desktop as an MCP server by adding a JSON entry to claude_desktop_config.json with uv run server.py and environment variables (IMPALA_HOST, IMPALA_PORT, IMPALA_USER, IMPALA_PASSWORD, IMPALA_DATABASE). Example integrations for LangChain/LangGraph and OpenAI SDK are included in the ./examples folder.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "cloudera iceberg mcp server (via impala)": {
            "iceberg-mcp-server": {
                "command": "uv",
                "args": [
                    "--directory",
                    "/path/to/iceberg-mcp-server",
                    "run",
                    "server.py"
                ],
                "env": {
                    "IMPALA_HOST": "coordinator-default-impala.example.com",
                    "IMPALA_PORT": "443",
                    "IMPALA_USER": "username",
                    "IMPALA_PASSWORD": "password",
                    "IMPALA_DATABASE": "default"
                }
            }
        }
    }
}

McpServers

{
    "iceberg-mcp-server": {
        "command": "uv",
        "args": [
            "--directory",
            "/path/to/iceberg-mcp-server",
            "run",
            "server.py"
        ],
        "env": {
            "IMPALA_HOST": "coordinator-default-impala.example.com",
            "IMPALA_PORT": "443",
            "IMPALA_USER": "username",
            "IMPALA_PASSWORD": "password",
            "IMPALA_DATABASE": "default"
        }
    }
}

Cloudera Iceberg MCP Server (via Impala)

This is a A Model Context Protocol server that provides read-only access to Iceberg tables via Apache Impala. This server enables LLMs to inspect database schemas and execute read-only queries.

- execute_query(query: str): Run any SQL query on Impala and return the results as JSON.
- get_schema(): List all tables available in the current database.

Usage with Claude Desktop

To use this server with the Claude Desktop app, add the following configuration to the "mcpServers" section of your claude_desktop_config.json:

{
"mcpServers": {
"iceberg-mcp-server": {
"command": "uv",
"args": [
"--directory",
"/path/to/iceberg-mcp-server",
"run",
"server.py"
],
"env": {
"IMPALA_HOST": "coordinator-default-impala.example.com",
"IMPALA_PORT": "443",
"IMPALA_USER": "username",
"IMPALA_PASSWORD": "password",
"IMPALA_DATABASE": "default"
}
}
}
}

Replace /path/to with your path to this repository and set the environment variables.

Usage with AI frameworks

The ./examples folder contains several examples how to integrate this MCP Server with common AI Frameworks like LangChain/LangGraph, OpenAI SDK.

Copyright (c) 2025 - Cloudera, Inc. All rights reserved.

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.