Schema | Excel Analytics MCP Server

Excel Analytics MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`EXCEL_MCP_HOME`	No	Override the base directory where data, tools, and configuration are stored (defaults to ~/Documents/Excel Analytics/).

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
list_datasetsA	Show all loaded tables with row/column counts.
describe_datasetB	Column names, types, sample values, and basic stats for a table.
queryA	Run a read-only SQL query against the database. Only SELECT queries allowed.
summarizeC	Quick statistical summary of a table or a specific column.
save_analysisC	Save a SQL template as a reusable named tool. `parameters should be a JSON string like: {"param": {"type": "string", "description": "...", "default": ...}}`
create_toolC	Create a custom Python tool (sandboxed). The code must define a run(db, **kwargs) function. `parameters should be a JSON string like: {"param": {"type": "string", "description": "...", "default": ...}}`
list_my_toolsB	Show all user-created tools (saved analyses and custom tools).
edit_toolC	Update an existing saved analysis or custom tool.
delete_toolB	Remove a user-created tool.
test_toolB	Run a tool with given parameters and return results. params should be a JSON string of the parameters to pass.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/blakethom8/excel-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server