IcebergMCP 🚀

AI-native Lakehouse Integration

IcebergMCP is a Model Context Protocol (MCP) server that lets you interact with your Apache Iceberg™ Lakehouse using natural language in Claude, Cursor, or any other MCP client.

Table of Contents

• Installation
  • Prerequisites
  • Claude
  • Cursor
• Configuration
• Available Tools
• Examples
• Limitations & Security Considerations
• Contributing

Installation

Prerequisites

• Apache Iceberg™ catalog managed in AWS Glue
• AWS profile configured on the machine, with access to the catalog
• uv package manager - install via brew install uv or see official installation guide

Claude

1. Inside Claude, go to Settings > Developer > Edit Config > claude_desktop_config.json

2. Add the following:

jsonCopy code
{
  "mcpServers": {
    "iceberg-mcp": {
      "command": "uv", // If uv can't be found, replace with full absolute path to uv
      "args": [
        "run",
        "--with",
        "iceberg-mcp",
        "iceberg-mcp"
      ],
      "env": {
        "ICEBERG_MCP_PROFILE": "<aws-profile-name>"
      }
    }
  }
}

Cursor

1. Inside Cursor, go to Settings -> Cursor Settings -> MCP -> Add new global MCP server

2. Add the following:

jsonCopy code
{
  "mcpServers": {
    "iceberg-mcp": {
      "command": "uv", // If uv can't be found, replace with full absolute path to uv
      "args": [
        "run",
        "--with",
        "iceberg-mcp",
        "iceberg-mcp"
      ],
      "env": {
        "ICEBERG_MCP_PROFILE": "<aws-profile-name>"
      }
    }
  }
}

Configuration

Environment variables can be used to configure the AWS connection:

• ICEBERG_MCP_PROFILE - The AWS profile name to use. This role will be assumed and used to connect to the catalog and the object storage. If not specified, the default role will be used.
• ICEBERG_MCP_REGION - The AWS region to use. This is used to determine the catalog and object storage location. us-east-1 by default.

Available Tools

The server provides the following tools for interacting with your Apache Iceberg™ tables:

• get_namespaces: Gets all namespaces in the Apache Iceberg™ catalog
• get_iceberg_tables: Gets all tables for a given namespace
• get_table_schema: Returns the schema for a given table
• get_table_properties: Returns table properties for a given table, like total size and record count
• get_table_partitions: Gets all partitions for a given table

Examples

Once installed and configured, you can start interacting with your Apache Iceberg™ tables through your MCP client. Here are some simple examples of how to interact with your lakehouse:

1. "List all namespaces in my catalog"
2. "List all tables for the namespace called bronze"
3. "What are all the string columns in the table raw_events?
4. "What is the size of the raw_events table?"
5. "Generate an SQL query that calculates the sum and the p95 of all number columns in raw_metrics for all VIP users from users_info"
6. "Why did the queries on raw_events recently become much slower?"

Limitations & Security Considerations

• All tools are currently read-only and cannot modify or delete data from your lakehouse
• Currently supported catalogs:
  • AWS Glue
  • Apache Iceberg™ REST Catalog (coming soon!)

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.