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 |
Instructions
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.
Capabilities
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 | {} |
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'). |
| sigma_create_folderC | Create a folder. |
| sigma_update_fileA | Update file properties (name, parentId for moving). |
| sigma_list_tagsA | List all tags in the organization. |
| sigma_create_tagA | Create a new tag (used for version promotion like 'Production', 'Staging'). color: Tag color, required by the Sigma API. One of: cyan, grass, violet, plum, amber, bronze. Defaults to 'cyan'. |
| sigma_delete_tagA | Delete a tag. Requires confirm=True. |
| sigma_list_user_attributesA | List all user attributes (used for row-level security and dynamic parameters). |
| sigma_create_user_attributeA | Create a user attribute for RLS or dynamic parameters. name: Attribute name (e.g. 'Region', 'CustomerID'). default_value: Default string value assigned when no override exists. description: Optional description of the attribute. |
| sigma_set_user_attribute_for_teamsB | Set a user attribute value for specific teams. assignments: List of objects, each with 'teamId' (str) and 'value' (str). Example: [{"teamId": "abc123", "value": "US"}] |
| sigma_set_user_attribute_for_tenantsA | Set a user attribute value for specific tenants. assignments: List of objects, each with 'tenantOrganizationId' (str) and 'value' (str). Example: [{"tenantOrganizationId": "org123", "value": "US"}] |
| sigma_get_user_attribute_usersA | Get all user assignments for a user attribute. |
| sigma_get_user_attribute_teamsB | Get all team assignments for a user attribute. |
| sigma_get_user_attribute_tenantsA | Get all tenant assignments for a user attribute. |
| sigma_update_user_attribute_for_usersA | Revoke a user attribute assignment for specific users. Requires confirm=True. user_ids: List of user IDs whose attribute assignments should be removed. Example: ["user-uuid-1", "user-uuid-2"] To assign (not revoke), use sigma_set_user_attribute_for_users instead (direct POST to /v2/user-attributes/{id}/users not yet exposed as a dedicated tool — use sigma_create_grant with a raw body as a workaround). |
| sigma_update_user_attribute_for_teamsA | Revoke a user attribute assignment for specific teams. Requires confirm=True. team_ids: List of team IDs whose attribute assignments should be removed. Example: ["team-uuid-1", "team-uuid-2"] |
| sigma_update_user_attribute_for_tenantsA | Revoke a user attribute assignment for specific tenants. Requires confirm=True. tenant_org_ids: List of tenant organization IDs whose attribute assignments should be removed. Example: ["org-uuid-1", "org-uuid-2"] |
| sigma_delete_user_attribute_for_userA | Delete a user attribute assignment for a specific user. DESTRUCTIVE. Requires confirm=True. |
| sigma_delete_user_attribute_for_teamA | Delete a user attribute assignment for a specific team. DESTRUCTIVE. Requires confirm=True. |
| sigma_delete_user_attribute_for_tenantA | Delete a user attribute assignment for a specific tenant. DESTRUCTIVE. Requires confirm=True. |
| sigma_list_workspacesC | List all workspaces. |
| sigma_get_workspaceC | Get workspace details. |
| sigma_create_workspaceC | Create a new workspace. |
| sigma_delete_workspaceA | Delete a workspace. Requires confirm=True. |
| sigma_list_workspace_grantsA | List permission grants on a workspace. |
| sigma_grant_workspace_accessC | Grant workspace access. grant_type: 'member' or 'team'. permission: 'view', 'explore', 'organize' (Contribute), or 'edit' (Manage). |
| sigma_delete_workspace_grantA | Delete a permission grant from a workspace. DESTRUCTIVE. Requires confirm=True. |
| sigma_list_account_typesA | List all account types (license types) in the organization. |
| sigma_list_grantsA | List grants for a specific file/workbook/data model by inodeId. Required: inodeId. |
| sigma_create_grantA | Create or update a grant. Body must include inodeId, granteeId, permission, type. |
| sigma_list_translationsA | List organization translation files. |
| sigma_sync_all_tables_in_schemaA | Sync all tables in a warehouse schema so they become visible in Sigma. |
| sigma_copy_workbook_to_memberA | Copy a workbook into a member's My Documents folder. name: Optional name for the copied workbook. Defaults to the original workbook name. |
| sigma_materialize_and_waitB | Trigger materialization and poll until complete or timeout. |
| sigma_onboard_memberA | Onboard a new member: create account then add to teams. |
| sigma_bulk_assign_team_membersA | Add multiple members to a team in one call. |
| sigma_deploy_template_to_folderA | Full deployment: instantiate a template into a folder, then optionally swap its sources. |
| sigma_promote_workbookA | Promote a workbook by tagging it (e.g., 'Production'). Creates tag if it doesn't exist. tag_color: Color for newly created tags. One of: cyan, grass, violet, plum, amber, bronze. Ignored if the tag already exists. Defaults to 'cyan'. |
| sigma_export_and_downloadA | Export a workbook/element and download the result. Polls until ready. format: 'csv', 'pdf', 'xlsx', 'png'. layout: 'portrait' or 'landscape' (pdf only). parameters: Sigma control overrides e.g. {'DateRange': 'min:2024-01-01,max:2024-01-31'}. max_bytes: maximum allowed response size (default 10 MB). Returns size info without content if exceeded. Returns base64-encoded file content on success. |
| sigma_reassign_workbook_ownershipA | Transfer all workbooks from one member to another. Resolves members by email, finds all workbooks owned by old owner, then PATCHes /v2/files/{id} to reassign. dry_run=True (default) reports what would change without making changes. |
| sigma_list_workbooks_shared_with_memberA | List all workbooks accessible to a member with full workbook metadata. Cross-references member's file list against the full workbook catalog. |
| sigma_list_all_input_tablesA | Scan all workbooks to find input-table elements. Returns a list of input tables with their workbook, page, and element context. Errors on individual workbooks/pages are collected rather than silently swallowed. |
| sigma_change_member_emailC | Change a member's email address via PATCH /v2/members/{id}. |
| sigma_bulk_sync_tenant_connectionsA | Sync connections across all tenant organizations. Lists all tenants, then for each tenant: obtains a tenant-scoped token, lists their connections, and syncs each one. Requires multi-tenant auth (for_tenant method). Uses bounded concurrency. NOTE: Requires PyJWT and the for_tenant() method (Phase C). Returns an error if token exchange is not available. |
| sigma_list_tenants_paginatedA | List all tenants using cursor-based pagination (nextPageToken model). Unlike offset-based pagination, tenants use cursor tokens. Returns the complete list of all tenant organizations. |
| sigma_get_tenant_scoped_infoA | Demonstrate tenant token exchange by calling /whoami through a tenant-scoped client. Uses RFC 8693 token exchange to obtain a tenant-scoped token, then calls the whoami endpoint to verify the scoped identity. |
| sigma_api_capabilitiesA | Describe what the Sigma REST API can and cannot do programmatically. |
| sigma_list_all_workbooksA | List ALL workbooks in the organization, automatically following pagination. |
| sigma_list_all_membersA | List ALL members in the organization, automatically following pagination. |
| sigma_list_all_teamsA | List ALL teams in the organization, automatically following pagination. |
| sigma_list_all_filesA | List ALL files/folders in the organization, automatically following pagination. |
| sigma_list_all_reportsA | List ALL reports in the organization, automatically following pagination. |
| sigma_list_all_data_modelsA | List ALL data models in the organization, automatically following pagination. |
| sigma_formula_pitfallsA | Return a curated reference of common Sigma formula pitfalls — column reference syntax, type requirements, NULL handling, aggregate vs row-level context, date function argument order, and metrics vs calculated columns. Use this before writing any Sigma formula expression. |
| sigma_search_docsA | Search Sigma Computing documentation using AI-powered semantic search. Returns relevant doc passages with source URLs. Use this to answer questions about Sigma features, configuration, formulas, administration, embedding, and best practices. read_only_hint: True |
| sigma_get_doc_pageA | Fetch a specific Sigma documentation page as clean Markdown. Pass the page slug (e.g. 'create-a-workbook') or a section path (e.g. 'docs/create-a-workbook'). Returns the full page content. read_only_hint: True |
| sigma_list_recent_webhooksB | List recently recorded incoming Sigma webhook events. read_only_hint: True |
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