# Alephgrid

> Alephgrid is an open-source MCP server for analytics and data. Let agents read Alephgrid workbooks with read-only SQL and verifiable result receipts. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** self-hosted, Web, Linux, macOS
- **Website:** https://alephgrid.dev/docs/agents-mcp/
- **Repository:** https://github.com/alephgrid/alephgrid
- **MCP Registry name:** dev.alephgrid/alephgrid
- **Categories:** analytics and data, databases
- **Listing updated:** 2026-11-14

## About

Alephgrid is an open-source spreadsheet built for tables with tens of millions of rows, backed by a DuckDB file on your own machine. Its MCP connection gives an agent the same services and authorization as a person, with no separate execution path. Space owners create a named connection scoped to all workbooks in a space or just some, with a lifetime of 1 to 366 days; the token starts with agc_ and is shown once.

Agents can list workbooks, search the catalogue, read schema cards with five sample values per column, preview up to 500 rows, read sheet ranges up to 5,000 cells and run read-only DuckDB SQL. Replies show the first 100 rows with a handle for more. Every result is stored for 24 hours with a receipt holding the SHA-256 of the result and request, the workbook revision and the engine versions, and verify_result recomputes it to detect staleness.

The only change an agent can ask for is saving a query, which waits for a person to approve it. Revoking a connection ends access at once, and an activity log lists each tool call. The docs note that what an agent reads goes to its model provider.

## Features

- **Scoped connections:** Limit an agent to chosen workbooks and a set number of days.
- **Schema cards:** Columns, types, row counts and sample values per workbook.
- **Read-only SQL:** DuckDB queries with up to 10,000 rows held behind a handle.
- **Result receipts:** Hashes, workbook revision and engine versions stored for 24 hours.
- **Result verification:** verify_result recomputes a result and reports if it is stale.
- **Approval for saves:** Proposed saved queries need a person to approve them.

## Good for

- Let an agent answer questions from a large CSV or Parquet workbook
- Audit exactly what an agent queried and read
- Run a saved analysis by name
- Check whether an earlier answer still matches current data
- Give a contractor's agent access to one workbook only

## Tools

- `list_workbooks`: Workbooks the connection may read, with tables and sheets.
- `search_catalog`: Tables, columns, sheets, saved queries and analyses matching words.
- `describe_workbook`: Schema cards with columns, types, row counts and sample values.
- `preview_table`: Up to 500 rows of a table with chosen columns, filters and sort.
- `read_sheet`: Shown values and formulas of a sheet range up to 5,000 cells.
- `run_query`: Read-only DuckDB SQL with up to 10,000 rows kept behind a handle.
- `explain_query`: The engine's plan for a read-only query without running it.
- `run_saved_query`: Runs a saved query by name or id.
- `run_analysis`: Runs an analysis by name or id.
- `fetch_result`: More rows of a result by handle.
- `verify_result`: Recomputes a result and compares it with its receipt.
- `job_status`: Status of requests still running.
- `cancel_job`: Cancels a running request.
- `propose_saved_query`: Asks to save a query, applied only if a person approves.
- `proposal_status`: Status of a saved-query proposal.

## FAQ

### Can an agent edit my data?

No. In this release agents only read; saving a query waits for a person to approve it.

### How do I revoke access?

Revoke the connection in the space menu; access ends at once and results with it.

### Does data stay local?

Workbooks run on your machine or server, but what an agent reads goes to its model provider under that provider's terms.

### Which clients work?

Claude Code over Streamable HTTP, and stdio clients through the alephgrid program; Claude Desktop is not tested yet.

### Is Alephgrid free?

Yes. Alephgrid is open source, so you can use and self-host it for free.

### What are the best alternatives to Alephgrid?

The closest alternatives to Alephgrid 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/alephgrid
