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

Capabilities

Features and capabilities supported by this server

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').

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