Iceberg MCP Server
Apache Impala database tables provide schema inspection and query execution for AI.
Data last scanned today · Reviewed today
Overview
The Iceberg MCP Server facilitates read-only interactions with Apache Iceberg tables by leveraging Apache Impala. It allows AI models to browse database schemas via a dedicated inspection tool and perform data retrieval by executing SQL queries against connected Impala instances. The server supports multiple transport protocols, including stdio for local operations and HTTP or SSE for networked environments. Integration is managed through environment variables for host authentication, and example configurations are provided for both direct remote execution and local deployment.
Our verdict
The Iceberg MCP Server currently holds a high-risk security score of 23/100. This elevated risk level is primarily driven by the fact that the project has not been editorially reviewed and the repository has not received a commit in over 427 days, indicating a potential lack of active maintenance. Due to these factors, this tool should be treated with caution and is recommended only for users in controlled, isolated environments who are prepared to perform their own security audits.
- Zero direct dependencies reduce the supply-chain surface area
- Licensed under the permissive Apache-2.0 license
- Includes documentation for multiple transport protocols
- Provides specific tools for schema listing and query execution
- Last code commit occurred over 427 days ago
- Community-maintained without official vendor support status
- Authentication and read-only implementation lack independent review
Tools
| Tool | Description | Risk |
|---|---|---|
| execute_query | Run any SQL query on Impala and return the results as JSON. | low |
| get_schema | List all tables available in the current database. | low |
Compatibility
| Client | Local | Docker | Remote | Read-only |
|---|---|---|---|---|
| Claude Desktop | ||||
| Cursor | ||||
| VS Code | ||||
| Windsurf | ||||
| ChatGPT |
Frequently asked questions
›Does this MCP server allow write access to Iceberg tables?
No, this server provides read-only access to Iceberg tables via Apache Impala.
›What tools does this server provide for LLMs?
The server provides two tools: execute_query for running SQL queries on Impala and get_schema for listing available tables in the database.
›Which environment variables must be configured to connect to Impala?
You must define IMPALA_HOST, IMPALA_PORT, IMPALA_USER, IMPALA_PASSWORD, and IMPALA_DATABASE to match your Impala configuration.
›Can I use transport protocols other than stdio?
Yes, you can configure the transport protocol using the MCP_TRANSPORT environment variable, which supports stdio, http, and sse.
Alternatives
Badge
Maintain this server? Add the live badge to your README.