Iceberg MCP Server (via 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.

MCP servers that give AI clients safe, structured access to SQL databases. One installable package per database engine. Every package exposes the same minimal two-tool surface, execute_sql and search_objects, with guardrails on by default: read-only mode, row caps, and statement timeouts.

AI-powered SQL query builder — natural language to SQL, schema introspection, query optimization, multi-dialect support by MEOK AI Labs

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.

Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety

An AI-powered gateway for managing over 40 data sources like Alibaba Cloud and mainstream databases, featuring NL2SQL, code generation, and data migration.

Query Apple Health data using natural language and SQL.

Interact with AskTable SaaS or local deployments to query data sources using natural language.

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