Skip to main content
Glama
christianclaudio

mcp-server-sigma

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SIGMA_CLIENT_IDYesYour Sigma API client ID.
SIGMA_MCP_PROFILENoTool registration subset: core (36 tools), admin (52), embed (55), full (155).full
SIGMA_API_BASE_URLYesRegion-specific Sigma API host URL.
SIGMA_MCP_READONLYNoSet 1 to register only read-only tools (83 tools). Models cannot alter org state.0
SIGMA_CLIENT_SECRETYesYour Sigma API client secret.
SIGMA_MCP_LOG_FORMATNoSet json for structured JSON logging with duration metrics (duration_ms).text
SIGMA_ALLOWED_TENANTSNoComma-separated allowlist of tenant org IDs permitted for RFC 8693 token exchange.
SIGMA_STRICT_TENANT_ALLOWLISTNoSet 1 to fail closed (HTTP 403) if a tenant request is made without an explicit allowlist entry.0
SIGMA_MCP_ALLOW_BULK_DESTRUCTIVENoSet 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

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
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

NameDescription
provision_tenant_dashboardGuide the agent through deploying a Sigma template into a folder and swapping data sources for a target tenant.
audit_organization_permissionsGuide the agent through auditing organization members, team memberships, and assigned user attributes.
prepare_data_modelGuide the agent in defining a production data model specification, columns, and relations.
onboard_team_memberGuide the agent through creating a new member, assigning team memberships, and verifying home folder setup.
swap_warehouse_sourceGuide the agent through re-binding workbook or template data sources to a new connection or table.
audit_tenant_connectionsGuide the agent through reviewing multi-tenant connections and running dry-run syncs.

Resources

Contextual data attached and managed by the client

NameDescription
Sigma Formula ReferenceCurated reference guide for writing valid Sigma formulas.
Sigma API CapabilitiesOverview of supported and unsupported Sigma API operations.
Sigma Documentation IndexFull index of all Sigma documentation pages with URLs. Use to discover available doc pages.
resource_webhooks_recentReturn recent webhook events received by the server.

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/christianclaudio/mcp-server-sigma'

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