IcebergMCP

Table of Contents

• Installation

• 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:

Cursor

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

2. Add the following:

Configuration

• 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

• 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

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:

Contributing

IcebergMCP

Table of Contents

• Installation

• 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:

Cursor

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

2. Add the following:

Configuration

• 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

• 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

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:

Contributing