Cloudera Iceberg MCP Server (via Impala)

Provides read-only access to Apache Iceberg tables using Apache Impala.

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.

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

Option 1: Direct installation from GitHub (Recommended)

{ "mcpServers": { "iceberg-mcp-server": { "command": "uvx", "args": [ "--from", "git+https://github.com/cloudera/iceberg-mcp-server@main", "run-server" ], "env": { "IMPALA_HOST": "coordinator-default-impala.example.com", "IMPALA_PORT": "443", "IMPALA_USER": "username", "IMPALA_PASSWORD": "password", "IMPALA_DATABASE": "default" } } } }

Option 2: Local installation (after cloning the repository)

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

For Option 2, replace/path/towith your path to this repository. Set the environment variables according to your Impala configuration.

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

The MCP server's transport protocol is configurable via theMCP_TRANSPORTenvironment variable. Supported values:

- stdio(default)— communicate over standard input/output. Useful for local tools, command-line scripts, and integrations with clients like Claude Desktop.
- http- expose an HTTP server. Useful for web-based deployments, microservices, exposing MCP over a network.
- sse— use Server-Sent Events (SSE) transport. Useful for existing web-based deployments that rely on SSE.

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

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Query and analyze data with MotherDuck and local DuckDB

A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.

A read-only MCP server for Avro data sources, powered by the CData JDBC Driver.

Run SQL queries on data in Amazon S3 using AWS Athena.

Interact with Bauplan data tables and run queries.

Production-grade MCP server for Databricks: SQL Warehouses, Jobs API, multi-workspace support.

Visual no-code generator that turns any database into multiple scoped MCP servers — one per access group, with PII masking and fail-closed query scoping built in.

A read-only MCP server by CData that enables LLMs to query live data from EnterpriseDB databases.

A read-only MCP server for MySQL, enabling LLMs to query live data using the CData JDBC Driver.