Basis — Claude Code MCP server for Excel: features and setup
The Basis MCP server for Claude Code reads Excel workbooks, checks formulas, and supports model edits. It handles requests to inspect workbook data and compare changes.
Apache-2.0 updated 2026-11-15
claude mcp add --env BASIS_API_KEY=<BASIS_API_KEY> --env BASIS_BASE_URL=<BASIS_BASE_URL> --transport stdio mcp -- npx -y @basis1/mcpWhat Basis does
Basis gives an agent tools to inspect Excel workbooks, evaluate formulas, and trace cell dependencies. A workbook can also be opened as a session so the agent can change input values and read the resulting outputs. File inputs accept path, url, or base64.
The server uses the Basis API, and files sent to its tools are uploaded there. Running the package requires Node.js 20.19 or later, a BASIS_API_KEY, and a network connection. npx fetches the package on its first run. The hosted MCP endpoint cannot access local files through path.
What it helps with
- inspect the contents of an Excel workbook
- check formulas and trace cell dependencies
- find cell-level changes between two workbooks
- change model inputs and read the resulting values
Example prompts for the agent
- Inspect
model.xlsxand summarize its workbook structure. - Check the formulas in
forecast.xlsxand trace their cell dependencies. - Compare
before.xlsxwithafter.xlsxand list changed cells.
How to install Basis
1Platform CLI
claude mcp add --env BASIS_API_KEY=<BASIS_API_KEY> --env BASIS_BASE_URL=<BASIS_BASE_URL> --transport stdio mcp -- npx -y @basis1/mcpReplace <…> with your own values
2Platform CLI: remote server
claude mcp add --transport http mcp https://api.basis1.tech/mcp1Platform CLI: remote server
codex mcp add mcp --url https://api.basis1.tech/mcp2Platform CLI
codex mcp add mcp --env BASIS_API_KEY=<BASIS_API_KEY> --env BASIS_BASE_URL=<BASIS_BASE_URL> -- npx -y @basis1/mcpReplace <…> with your own values
Config file
{
"mcpServers": {
"mcp": {
"url": "https://api.basis1.tech/mcp"
}
}
}{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@basis1/mcp"
],
"env": {
"BASIS_API_KEY": "<BASIS_API_KEY>",
"BASIS_BASE_URL": "<BASIS_BASE_URL>"
}
}
}
}Replace <…> with your own values
Config file
{
"servers": {
"mcp": {
"type": "http",
"url": "https://api.basis1.tech/mcp"
}
}
}{
"servers": {
"mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@basis1/mcp"
],
"env": {
"BASIS_API_KEY": "<BASIS_API_KEY>",
"BASIS_BASE_URL": "<BASIS_BASE_URL>"
}
}
}
}Replace <…> with your own values
1Platform CLI: remote server
gemini mcp add -t http mcp https://api.basis1.tech/mcp2Platform CLI
gemini mcp add -e BASIS_API_KEY=<BASIS_API_KEY> -e BASIS_BASE_URL=<BASIS_BASE_URL> mcp npx -y @basis1/mcpReplace <…> with your own values
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Basis
How do I install Basis in Claude Code?
Run claude mcp add mcp -e BASIS_API_KEY=<BASIS_API_KEY> -- npx -y @basis1/mcp. Node.js 20.19 or later and a Basis API key are required.
What does Basis do?
It gives an agent tools to read Excel workbooks, examine formulas and dependencies, and compare workbook changes. It also supports sessions for changing model inputs and reading results.
What does Basis need to run?
It requires Node.js 20.19 or later, a BASIS_API_KEY, and a network connection. Workbooks sent to its tools are uploaded to the Basis API.