# LakehouseBox

> LakehouseBox is a freemium MCP server for databases. Query Iceberg tables hosted in Europe with read-only SQL from Claude or ChatGPT. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Platforms:** API, CLI
- **Website:** https://lakehousebox.com/docs/mcp/
- **MCP Registry name:** com.lakehousebox/lakehousebox
- **Categories:** databases, analytics and data
- **Listing updated:** 2026-11-16

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://mcp.lakehousebox.com/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "lakehousebox": {
      "url": "https://mcp.lakehousebox.com/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

## Tools

- `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.

## 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

- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Google Ads + Meta Ads + SEO/GEO MCP](https://ai-powered.com/mcp/google-ads-meta-ads-seo-geo-mcp): Google Ads + Meta Ads + SEO/GEO MCP is a freemium MCP server for marketing and seo.
- [Tapetide - Indian Stock Market MCP](https://ai-powered.com/mcp/tapetide-indian-stock-market-mcp): Tapetide - Indian Stock Market MCP is a freemium MCP server for finance and payments.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [World Monitor](https://ai-powered.com/mcp/world-monitor): World Monitor is a freemium MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.
- [ChartAnt](https://ai-powered.com/mcp/chartant): ChartAnt is a freemium MCP server for design and media.
- [Quantivex Research](https://ai-powered.com/mcp/quantivex-research): Quantivex Research is a free MCP server for finance and payments.

---
Source: https://ai-powered.com/mcp/lakehousebox
