mcp-server-sigma
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SIGMA_CLIENT_ID | Yes | Your Sigma API client ID. | |
| SIGMA_MCP_PROFILE | No | Tool registration subset: core (36 tools), admin (52), embed (55), full (155). | full |
| SIGMA_API_BASE_URL | Yes | Region-specific Sigma API host URL. | |
| SIGMA_MCP_READONLY | No | Set 1 to register only read-only tools (83 tools). Models cannot alter org state. | 0 |
| SIGMA_CLIENT_SECRET | Yes | Your Sigma API client secret. | |
| SIGMA_MCP_LOG_FORMAT | No | Set json for structured JSON logging with duration metrics (duration_ms). | text |
| SIGMA_ALLOWED_TENANTS | No | Comma-separated allowlist of tenant org IDs permitted for RFC 8693 token exchange. | |
| SIGMA_STRICT_TENANT_ALLOWLIST | No | Set 1 to fail closed (HTTP 403) if a tenant request is made without an explicit allowlist entry. | 0 |
| SIGMA_MCP_ALLOW_BULK_DESTRUCTIVE | No | Set 1 to enable bulk deactivate/remove operations (sigma_bulk_deactivate_members, sigma_bulk_remove_team_members) (157 total). | 0 |
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 |
|---|---|
| sigma_list_connectionsA | List all connections in the Sigma organization. Pass summary_only=True for concise token-efficient response. |
| sigma_get_connectionC | Get details for a specific connection. |
| sigma_sync_connectionA | Force Sigma to re-index a warehouse path. Pass empty list for full sync. |
| sigma_test_connectionC | Test connectivity for a connection. |
| sigma_list_columns_for_tableA | List columns for a warehouse table by its tableId. |
| sigma_list_connection_grantsB | List permission grants on a connection. |
| sigma_add_connection_grantB | Add a grant to a connection. grant_type: 'member' or 'team'. permission: 'annotate' (Can Use & Annotate) or 'usage' (Can Use). |
| sigma_delete_connection_path_grantA | Delete a grant from a connection path. DESTRUCTIVE. Requires confirm=True. |
| sigma_list_workbooksA | List all workbooks in the organization. Pass summary_only=True for concise token-efficient response. |
| sigma_get_workbookC | Get workbook metadata. |
| sigma_create_workbookB | Create an empty workbook in a folder. |
| sigma_duplicate_workbookA | Duplicate an existing workbook. workbook_id: ID of the workbook to clone. name: Name for the new cloned workbook (required by the API). destination_folder_id: ID of the destination folder. If omitted, clones into the same folder as the original. |
| sigma_delete_fileA | Delete a file/workbook/data model by its inode ID. Requires confirm=True. |
| sigma_list_workbook_pagesC | List pages in a workbook. |
| sigma_list_workbook_page_elementsA | List elements on a specific page of a workbook. |
| sigma_list_workbook_elementsB | List all elements (tables, charts, controls, etc.) in a workbook. |
| sigma_list_workbook_columnsA | List all columns across all elements in a workbook, including formulas and types. |
| sigma_list_workbook_queriesB | List generated SQL queries for all elements in a workbook. |
| sigma_list_workbook_controlsA | List control elements (filters, parameters) in a workbook. |
| sigma_list_workbook_sourcesB | List data sources used by a workbook. |
| sigma_swap_workbook_sourcesA | Swap data sources for a workbook. Use connectionMapping for connection-level swaps, sourceMapping for table-level swaps. |
| sigma_list_workbook_lineageB | List data lineage for a workbook. |
| sigma_get_workbook_version_historyB | Get version history for a workbook. |
| sigma_restore_workbook_versionC | Restore a workbook to a previous version. |
| sigma_get_element_queryC | Get the generated SQL query for a specific element in a workbook. |
| sigma_get_element_columnsA | List columns for a specific element in a workbook. |
| sigma_convert_workbook_to_reportA | Convert a workbook to a report (one-way, creates a new report). workbook_id: ID of the workbook to convert. name: Name for the new report (required by the API). destination_folder_id: Optional folder ID for the report; defaults to My Documents. |
| sigma_list_workbook_grantsC | List permission grants on a workbook. |
| sigma_grant_workbook_accessC | Grant access to a workbook. grant_type: 'member' or 'team'. permission: 'view', 'explore', 'edit'. |
| sigma_list_workbook_embedsA | List embed configurations for a workbook. |
| sigma_create_workbook_embedA | Create an embed for a workbook. embed_type: Visibility of the embed. Only 'public' is currently supported. source_type: Scope of the embed — 'workbook' (entire workbook), 'page', or 'element'. source_id: Required when source_type is 'page' or 'element'. |
| sigma_export_workbookA | Export a workbook element. If element_id is empty, exports the first page. format: 'pdf', 'png', 'csv', 'xlsx', 'json', 'jsonl'. layout: 'portrait' or 'landscape' (only for pdf/png). element_id: The specific element to export. If omitted, uses the first page element. |
| sigma_list_workbook_schedulesA | List scheduled exports for a workbook. |
| sigma_add_workbook_scheduleB | Create a scheduled export for a workbook. See Sigma docs for schedule body schema. |
| sigma_delete_workbook_scheduleA | Delete a scheduled export. Requires confirm=True. |
| sigma_materialize_elementC | Trigger materialization for a workbook. Pass elementId in body if needed. |
| sigma_get_materialization_jobC | Check status of a materialization job. |
| sigma_list_materialization_schedulesC | List materialization schedules for a workbook. |
| sigma_list_workbook_bookmarksA | List bookmarks (saved filter states) in a workbook. |
| sigma_add_workbook_bookmarkC | Add a bookmark to a workbook. |
| sigma_get_workbook_tagsA | List tags on a workbook. |
| sigma_tag_workbookA | Apply a version tag to a workbook by tag NAME (e.g. 'Production'). The Sigma API takes the tag name here, not its ID. |
| sigma_remove_workbook_tagA | Remove a tag from a workbook. Requires confirm=True. |
| sigma_list_templatesB | List all templates in the organization. |
| sigma_get_templateC | Get template details. |
| sigma_create_workbook_from_templateA | Create a workbook from a template. This brings real visuals — the only programmatic way to get charts/tables. |
| sigma_save_template_from_workbookC | Save a workbook as a reusable template. |
| sigma_swap_template_sourcesB | Swap data sources on a template. Use connectionMapping for connection-level swaps, sourceMapping for table-level swaps. |
| sigma_list_data_modelsB | List all data models in the organization. Pass summary_only=True for concise token-efficient response. |
| sigma_get_data_modelC | Get data model metadata. |
| sigma_get_data_model_specA | Get the full code representation (JSON spec) of a data model — tables, columns, metrics, relationships. |
| sigma_create_data_modelA | Create a data model from a JSON code representation. Must include name, folderId, schemaVersion, and pages with elements. |
| sigma_update_data_modelA | Update an existing data model from a JSON code representation (full replacement via PUT). |
| sigma_list_data_model_elementsC | List elements in a data model. |
| sigma_list_data_model_columnsA | List all columns across all elements in a data model. |
| sigma_swap_data_model_sourcesC | Swap data sources for a data model. |
| sigma_list_data_model_lineageA | List lineage for a data model. |
| sigma_tag_data_modelA | Apply a version tag to a data model by tag NAME. The Sigma API takes the tag name here, not its ID. |
| sigma_list_reportsC | List all reports in the organization. |
| sigma_get_reportC | Get report metadata. |
| sigma_create_reportC | Create a report. |
| sigma_duplicate_reportA | Duplicate a report. report_id: ID of the report to clone. name: Name for the new cloned report (required by the API). destination_folder_id: ID of the destination folder to clone into (required by the API). |
| sigma_list_report_sourcesA | List data sources used by a report. |
| sigma_swap_report_sourcesA | Swap data sources on a report. Use connectionMapping for connection-level swaps, sourceMapping for table-level swaps. |
| sigma_list_report_elementsC | List elements in a report. |
| sigma_list_report_queriesB | List SQL queries in a report. |
| sigma_list_report_lineageB | List lineage for a report. |
| sigma_export_reportC | Export a report. format: 'pdf', 'png', 'csv', 'xlsx'. |
| sigma_list_report_schedulesA | List scheduled exports for a report. |
| sigma_create_report_scheduleC | Create a scheduled export for a report. |
| sigma_list_deploymentsA | List all deployment policies. |
| sigma_get_deploymentB | Get a deployment policy. |
| sigma_create_deploymentC | Create a deployment policy. |
| sigma_archive_deploymentA | Delete (archive) a deployment policy. Requires confirm=True. |
| sigma_deactivate_memberA | Deactivate a member. Requires confirm=True. |
| sigma_list_deployment_documentsA | List documents in a deployment policy. |
| sigma_add_deployment_documentsB | Add workbooks/reports to a deployment policy. |
| sigma_list_tenantsB | List all tenant organizations (for multi-tenant deployments). |
| sigma_get_tenantB | Get tenant organization details. |
| sigma_create_tenantC | Create a tenant organization. |
| sigma_list_api_connectorsA | List all API connectors (custom data integrations). |
| sigma_get_api_connectorB | Get details for an API connector. |
| sigma_list_source_swap_policiesA | List all source swap policies (rules for automatic source swapping on deployment). |
| sigma_get_source_swap_policyB | Get a source swap policy. |
| sigma_create_source_swap_policyB | Create a source swap policy for automated deployments. |
| sigma_list_shared_templatesA | List templates shared with your organization from other orgs. |
| sigma_accept_shared_templateA | Accept a pending template share from another organization. |
| sigma_list_membersB | List all members in the organization. Pass summary_only=True for concise token-efficient response. |
| sigma_get_memberA | Get member details including homeFolderId. |
| sigma_create_memberA | Create a new member. member_type: 'admin', 'creator', 'viewer'. |
| sigma_update_memberB | Update member properties (firstName, lastName, memberType, isActive, etc.). |
| sigma_get_current_userA | Get the current authenticated user's details. |
| sigma_list_member_teamsA | List teams a member belongs to. |
| sigma_list_teamsB | List all teams. Pass summary_only=True for concise token-efficient response. |
| sigma_get_teamC | Get team details. |
| sigma_create_teamC | Create a new team. |
| sigma_delete_teamA | Delete a team. Requires confirm=True. |
| sigma_list_team_membersB | List members of a team. |
| sigma_update_team_membersA | Add or remove members from a team. Provide lists of member IDs. |
| sigma_list_filesA | List files/folders. Optionally filter by parentId or type ('workbook', 'folder', 'data-model', 'template'). |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| provision_tenant_dashboard | Guide the agent through deploying a Sigma template into a folder and swapping data sources for a target tenant. |
| audit_organization_permissions | Guide the agent through auditing organization members, team memberships, and assigned user attributes. |
| prepare_data_model | Guide the agent in defining a production data model specification, columns, and relations. |
| onboard_team_member | Guide the agent through creating a new member, assigning team memberships, and verifying home folder setup. |
| swap_warehouse_source | Guide the agent through re-binding workbook or template data sources to a new connection or table. |
| audit_tenant_connections | Guide the agent through reviewing multi-tenant connections and running dry-run syncs. |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| Sigma Formula Reference | Curated reference guide for writing valid Sigma formulas. |
| Sigma API Capabilities | Overview of supported and unsupported Sigma API operations. |
| Sigma Documentation Index | Full index of all Sigma documentation pages with URLs. Use to discover available doc pages. |
| resource_webhooks_recent | Return recent webhook events received by the server. |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/christianclaudio/mcp-server-sigma'
If you have feedback or need assistance with the MCP directory API, please join our Discord server