Excel Analytics MCP Server
Server Configuration
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/). |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
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. |
| create_toolC | Create a custom Python tool (sandboxed). The code must define a run(db, **kwargs) function. |
| 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. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
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