GUIDE, read 10 Nov 2026
Servers differ on whether writes ship at all, whether they are off by default, and what stops a write once an agent calls it
Some servers ship read-only by default and need an opt-in for writes
The Amazon Redshift MCP Server is read-only by default per the AWS Labs README, and read-write mode must be selected with ACCESS_MODE. The README adds that the database user's privileges are the security boundary, not the server.
Per the README of the DataHub MCP Server, mutation tools are disabled by default and need TOOLS_IS_MUTATION_ENABLED=true. The community mcp-snowflake-server disables write operations by default and enables them only with --allow-write, per its README. Collibra's README says its data quality tools (18 tools, several that write or delete) are off by default behind a --data-quality flag.
Per the README of the Fivetran MCP Server, FIVETRAN_SCOPE defaults to read and can be raised to read/write or read/write/delete, and a DISALLOWED_ACTIONS list denies resource and action pairs. Select Star's page lists seven tools, all search, get or traverse operations, and the directory records its access as read-only.
Some servers ship writes in the default tool list
On other servers the write tools are present from the first connection and the control is a role, a header or a tier. Per Airbyte's docs, read-only mode is enabled with the X-MCP-Readonly-Mode header or ?read-only=true, which shows only read-only tools and hides run and cancel sync tools. Per Monte Carlo's docs, an x-mcp-readonly header hides write tools such as update_alert and the create_or_update monitor tools, and blocks calls to them.
SYNQ's docs describe four permission tiers (read-only, write, governance, deploy), and write tools do not appear in the client if the user granted only read-only access. Atlan's security page says an optional read-only mode removes every write, admin and lifecycle tool while keeping search and lineage, and that it is requested from Atlan support.
Looker's tools in MCP Toolbox include creating or deleting LookML project files and switching Looker into dev mode, so per the Toolbox index access is not read-only by default. Omni lists putApp, patchApp and publishDraft; per Omni's docs, edits land on a shared draft until publishDraft runs, and Organization Admins can enable or disable tool capabilities individually.
Confirmation is documented in five different forms
The Redshift README says each write in read-write mode prompts for confirmation through MCP elicitation unless UNSAFE_SKIP_WRITE_CONFIRMATION is set. Collibra's README describes a confirm checkpoint for destructive data quality tools, where confirm=false is the read-only default. Per Euno's docs, deletes need confirm=true and write tools such as catalog creates ask for client confirmation.
Per Atlan's tools page, tools that change anything propose first and wait for approval before writing. Per Tableau's docs, the mutating flow tools (run-flow, run-flow-task, cancel-flow-run) are preview-and-confirm tools, and delete-content is admin-only and two-phase. Microsoft's README describes --readonly as a safe mode that prevents any write to the semantic model, with --readwrite as the default and a confirmation prompt.
Fivetran's README is explicit that write and delete confirmation is advisory only and that the server does not enforce it. The Sifflet server has two state-changing tools, open_incident_by_id and close_incident_by_id, and the README and docs page describe no per-call permission prompt (none found on 10 Nov 2026). Secoda's docs list run_sql and do not describe a read-only mode (none found on 10 Nov 2026).
Tool annotations are published by some servers and treated as hints by others
MCP tool annotations such as readOnlyHint and destructiveHint tell a client how a tool behaves. Per the docs for the Cube MCP server, nine tools are annotated destructive and that clients honoring annotations always ask before running them. The same page says chat is annotated read-only but runs the Analytics Chat agent, which can create reports or delete folders without confirmation, so the annotation understates what it can do.
In Tableau's source, query-datasource is annotated readOnlyHint true and destructiveHint false. In ThoughtSpot's tool definitions, search_objects and get_data carry the same pair of values. In the MCP Toolbox BigQuery docs, the source options readOnly and writeMode set the behavior: with readOnly true and writeMode blocked, only SELECT is allowed and the tool is annotated readOnlyHint true.
Snowflake's docs state that tool annotations are client hints and not security controls, and that RBAC is the control. The Toolbox docs list a Read-Only Tools page covering engine-level protocol locks, tool suppression and MCP annotations. Whether a client acts on an annotation is a property of the client, so the annotation tells an engineer what the publisher intended and not what the client will enforce.
Write scope can be narrowed below the server level
Several servers limit writes by place instead of by tool. Per Cube's docs, writeDataModelFile and deleteDataModelFile reject any branch that is not a dev branch, so file writes never touch production, and a merge to the default branch goes through a tool that prompts for confirmation. Per Microsoft's Learn page, with only Build permission the Power BI server can only run DAX queries, and Write permission is needed to change model objects.
Per Airbyte's tools page, permanent deletes only work when the resource name contains delete-me or deleteme. Per Hex's docs, editing a cell needs Can Edit or Full Access on that project, even for Admins. Per Euno's docs, context benchmark tools are accepted only for an account admin persona. BigQuery's allowedDatasets option restricts the Toolbox tools to listed datasets, and BIGQUERY_MAXIMUM_BYTES_BILLED caps bytes scanned per query.
The control that holds sits where the credential is checked
A header or flag in a client config stops the tool list from showing a write tool. A role or privilege stops the write at the system that owns the data. Airbyte's docs say headers can only hide tools and cannot grant permissions the user's Airbyte role lacks. Snowflake's docs list distinct privileges: USAGE on the MCP server plus SELECT on the semantic view, or USAGE on the Cortex Search service, agent or UDF.
The table puts several servers' documented controls side by side. It records what each publisher wrote and does not grade the controls.
| Server | Write tools shipped | Documented control |
|---|---|---|
| Airbyte MCP (hosted) | deploy, update, delete, run sync | Read-only header or query parameter; role limits |
| Amazon Redshift MCP Server (AWS Labs) | execute_query in read-write mode | ACCESS_MODE; elicitation prompt per write |
| Collibra MCP Server | edit_asset, create_asset, 18 data quality tools | Data quality tools off by default; confirm flag |
| Cube MCP server | report, workbook, data model file tools | Nine destructive annotations; dev branch only |
| DataHub MCP Server | tags, terms, owners, domains | Off unless TOOLS_IS_MUTATION_ENABLED=true |
| Fivetran MCP Server | connections_write, connections_delete | FIVETRAN_SCOPE; denylist; confirmation advisory |
| Select Star MCP Server | none found on 10 Nov 2026 | Seven search, get and traverse tools |
| SYNQ MCP | create, delete and save tools | Four permission tiers chosen at consent |
Sources
- AWS Labs Redshift MCP README, read 10 Nov 2026
- DataHub MCP README, read 10 Nov 2026
- Community mcp-snowflake-server README, read 10 Nov 2026
- Collibra MCP README, read 10 Nov 2026
- Fivetran MCP README, read 10 Nov 2026
- Select Star MCP docs, read 10 Nov 2026
- Airbyte MCP advanced configuration, read 10 Nov 2026
- Airbyte MCP tools, read 10 Nov 2026
- Monte Carlo MCP reference, read 10 Nov 2026
- SYNQ MCP docs, read 10 Nov 2026
- Atlan MCP security page, read 10 Nov 2026
- Atlan MCP tools page, read 10 Nov 2026
- MCP Toolbox llms.txt index, read 10 Nov 2026
- Omni MCP tools, read 10 Nov 2026
- Euno MCP setup docs, read 10 Nov 2026
- Tableau MCP docs intro, read 10 Nov 2026
- Power BI Modeling MCP README, read 10 Nov 2026
- Microsoft Learn Power BI authoring MCP, read 10 Nov 2026
- Sifflet MCP README, read 10 Nov 2026
- Secoda MCP docs, read 10 Nov 2026
- Cube MCP server docs, read 10 Nov 2026
- Tableau queryDatasource source, read 10 Nov 2026
- ThoughtSpot tool definitions, read 10 Nov 2026
- MCP Toolbox BigQuery source, read 10 Nov 2026
- MCP Toolbox BigQuery prebuilt config, read 10 Nov 2026
- Snowflake-managed MCP docs, read 10 Nov 2026
- Hex MCP server docs, read 10 Nov 2026
Last reviewed 10 Nov 2026.