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_datasets | Show all loaded tables with row/column counts. |
| describe_dataset | Column names, types, sample values, and basic stats for a table. |
| query | Run a read-only SQL query against the database. Only SELECT queries allowed. |
| summarize | Quick statistical summary of a table or a specific column. |
| save_analysis | Save a SQL template as a reusable named tool. parameters should be a JSON string like: {"param": {"type": "string", "description": "...", "default": ...}} |
| create_tool | 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_tools | Show all user-created tools (saved analyses and custom tools). |
| edit_tool | Update an existing saved analysis or custom tool. |
| delete_tool | Remove a user-created tool. |
| test_tool | 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 | |