Agent endpoint configuration

Available configuration parameters

The following configurations are available for the /api/mcp/agent endpoint:

Parameter	Default	Description
`enable_mcp_agent`	`true`	Enable or disable the `/api/mcp/agent` endpoint. When disabled, requests return `HTTP 503 (Service Unavailable)`.
`enable_mcp_agent_query_tool`	`false`	Enable or disable the `query` tool, which allows for queries with joins. Enabling the `query` tool can have performance impact, information leakage via query execution errors, catalog-level discovery of operational metadata.
`mcp_max_response_size`	`1000000`	Maximum response size in bytes. Queries exceeding this limit return an error.

The materialize-agent endpoint is enabled by default. To disable it:

Contact Materialize support to enable/disable the MCP agent endpoint for your environment.

Enable the endpoint using one of these methods:

Option 1: Configuration file

system_parameters:
  enable_mcp_agent: "false"

Option 2: Terraform

Set the parameter via the Materialize Terraform module:

system_parameters = {
  enable_mcp_agent = "false"
}

Option 3: SQL

Connect as mz_system and run:

ALTER SYSTEM SET enable_mcp_agent = false;

NOTE: These parameters are only accessible to the mz_system and mz_support roles. Regular database users cannot view or modify them.