Skip to content
MCP server

LakehouseBox

Query Iceberg tables hosted in Europe with read-only SQL from Claude or ChatGPT

Install
Pricing
Freemium
Platforms
API, CLI
Runs
Remotely
Version
0.4.4
Listing updated
1 day ago

About LakehouseBox

LakehouseBox is a freemium MCP server for databases. It runs as a hosted remote server, so there is nothing to install locally.

The hosted server connects an assistant to tables in LakehouseBox, an Iceberg catalogue run from Frankfurt. The recommended order is to list tables, describe a table, then run a query. The server can also read files such as photos. Writes are off by default: a connection approved with write access can save results as tables or add, correct and remove rows with SQL.

Access is by OAuth 2.1 or an agent key. A person approves each connection and chooses all catalogs or selected ones, at read or read-write. Errors come back with a code and a remedy, for example read_only when a statement is not a SELECT, and queries time out at 20 seconds. A person without an account can let the client create a temporary catalog capped at 1 GB that is deleted after 72 hours unless kept.

Administration is left to the lhbox command line tool and API.

Install

Run in a terminal

claude mcp add --transport http lakehousebox https://mcp.lakehousebox.com/mcp

Add to Settings → Connectors → Add custom connector

https://mcp.lakehousebox.com/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "lakehousebox": {
      "url": "https://mcp.lakehousebox.com/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "lakehousebox": {
      "type": "http",
      "url": "https://mcp.lakehousebox.com/mcp"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "lakehousebox": {
      "serverUrl": "https://mcp.lakehousebox.com/mcp"
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "lakehousebox": {
      "type": "http",
      "url": "https://mcp.lakehousebox.com/mcp"
    }
  }
}

Tools this server provides (7)

Taken from the project documentation; the running server may differ.

list_tables
Lists tables to start exploring.
describe_table
Shows a table's columns and freshness.
query
Runs read-only SQL.
query_rw
Runs write SQL when write scope is granted.
document_table
Writes documentation for a table, needs write scope.
set_agents_md
Sets a catalog's AGENTS.md, needs write scope.
keep_account
Returns a link and code to keep a temporary account.

What it does

Read-only SQL
Run SELECT-style queries on the provider's side.
Table discovery
Find tables and see columns and freshness.
Write on approval
Save results as tables or change rows with approved write scope.
Scoped OAuth grants
Choose which catalogs a connection can read or write.
Actionable errors
Each failure returns a code and a remedy.
Trial catalog
Start without an account in a temporary 1 GB catalog.

Good for

  • Ask questions of company analytics tables from a chat
  • Let a scheduled agent read data with an agent key
  • Look at photos stored in a catalog
  • Save a query result as a new table

Pricing

Freemium

Free monthly allowances, then pay per use; storage billed at EUR 0.10 per GB in the worked example

Prices change. Check lakehousebox.com before you buy.

LakehouseBox FAQ

Is it free?

Each of storage, compute and AI tokens has a free monthly allowance, then usage is charged, for example 5 GB storage and 10 CPU-hours free.

Can it change data?

Only with write approved at consent, using query_rw and related tools.

What are the query limits?

Queries time out at 20 seconds and server-side memory is capped at 1.5 GB by default.

Where is data hosted?

Frankfurt, Germany; agent models run in Paris, France.

Is LakehouseBox free?

LakehouseBox has a free plan, with paid plans for more usage or features.

How do I add LakehouseBox to Claude Code?

Run this command in your terminal: claude mcp add --transport http lakehousebox https://mcp.lakehousebox.com/mcp

What are the best alternatives to LakehouseBox?

The closest alternatives to LakehouseBox are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

Alternatives to LakehouseBox

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data