LakehouseBox
Query Iceberg tables hosted in Europe with read-only SQL from Claude or ChatGPT
- 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/mcpAdd to Settings → Connectors → Add custom connector
https://mcp.lakehousebox.com/mcpAdd to ~/.cursor/mcp.json
{
"mcpServers": {
"lakehousebox": {
"url": "https://mcp.lakehousebox.com/mcp"
}
}
}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

Agent-Native Analytics
MCP serverOpen-source analytics app where an AI agent builds charts and dashboards from your data
- Remote
- Open source
- 7.7K GitHub stars
- Analytics and data

Google Ads + Meta Ads + SEO/GEO MCP
MCP serverHosted 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

Tapetide - Indian Stock Market MCP
MCP serverIndian NSE and BSE stock market data for AI assistants through 48 MCP tools
- 17 tools
- Remote
- Freemium
- 150 GitHub stars
- Finance and payments

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

World Monitor
MCP serverLive geopolitical intelligence dashboard with an API and MCP server for agents
- Remote
- Freemium
- Analytics and data

CompanyData
MCP serverSearch and enrich company records from official registers via the CompanyData API
- 3 tools
- Remote
- Paid
- 3 GitHub stars
- Analytics and data