Cloudera Iceberg MCP Server (via Impala)

by peterableda

206 downloads Not rated yet Apache-2.0 license
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

License
Apache-2.0 license

Explore

- 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

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.

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.

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"
        }
    }
}

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.