What is Mcp Bauplan

mcp-bauplan is a minimalist Model Context Protocol MCP server designed to interact with data tables and execute Bauplan queries, managing a data store of Iceberg tables in S3.

Use cases

Use cases for mcp-bauplan include querying data for analytics, managing data schemas, and integrating with applications that require data retrieval and manipulation from Iceberg tables.

How to use

To use mcp-bauplan, configure the Claude Desktop settings by editing the configuration file to include the MCP server details. Then, run the server using the specified command and transport method (SSE or STDIO).

Key features

Key features include the ability to list all tables in the configured namespace, retrieve table schemas, and execute SELECT queries on specified tables. It supports both SSE and STDIO transports.

Where to use

mcp-bauplan can be used in data management and analytics environments where interaction with Iceberg tables is required, particularly in cloud storage solutions like S3.

mcp-bauplan

A mimimalist Model Context Protocol MCP server to interact with data tables and running Bauplan queries.

Bauplan manages a data store of Iceberg tables in S3.

Features

• Get Bauplan data tables and their schemas in the configured namespace
• Query Bauplan data tables using SQL (SELECT only)

It supports both SSE and STDIO transports.

Tools

The server implements the following tools to interact with Bauplan data tables:

• list_tables:
  • Lists all the tables in the configured namespace
• get_schema:
  • Get the schema of a data tables
• run_query:
  • Run a SELECT query on the specified table

Configuration

1. Create _or edit the Claude Desktop configuration file located at:

   • On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
   • On Windows: %APPDATA%/Claude/claude_desktop_config.json

2. Add the following:

3. Replace /path/to/uvx with the absolute path to the uvx executable. Find the path with which uvx command in a terminal. This ensures that the correct version of uvx is used when starting the server.

4. Restart Claude Desktop to apply the changes.

Run the stand-alone SSE server

Create a .env file from .env.example and then execute the following command:

$ uvx --env-file /path/to/.env mcp-bauplan --transport sse --port 9090

Note the use of nvx and not uvx will fetch mcp-bauplan from the default registry https://pypi.org.

Future Development

Development - work in progress

1. Documentation of Bauplan (SDK and Platform) as Resource
2. Automation of Bauplan Execution - more commands and run a pipeline
3. Query Generation
4. Code Generation Using Templates
5. Data Governance & Compliance
6. Testing & Validation
7. Integration Ecosystem

Setup

1. Prerequisites:

   • Python 3.10 or higher.
   • A Bauplan API key (request here).
   • uv package manager (installation).

2. Clone the Repository:

git clone https://github.com/marcoeg/mcp-bauplan
cd mcp-nvd

3. Set Environment Variables:

   • Create a .env file in the project root:

     BAUPLAN_API_KEY=your-api-key
     BAUPLAN_BRANCH=your-branch
     BAUPLAN_NAMESPACE=your-namespace
     

4. Install Dependencies:

uv sync
uv pip install -e .

Run with the MCP Inspector

cd /path/to/the/repo
source .env

CLIENT_PORT=8077 SERVER_PORT=8078 npx @modelcontextprotocol/inspector \
     uv run mcp-bauplan

Note: omit CLIENT_PORT=8077 SERVER_PORT=8078 if the standard ports are not conflicting.

Then open the browser to the URL indicated by the MCP Inspector, typically http://localhost:8077?proxyPort=8078

Switch freely between stdio and sse transport types in the inspector. To use sse you need to run the server as explained below.

Testing with the SSE transport

Run the Server:

cd /path/to/the/repo
source .env

uv run mcp-bauplan --transport sse --port 9090

• Runs with SSE transport on port 9090 by default.

Then open the browser to the URL indicated by the MCP Inspector. Select SSE Transport Type.