Developer endpoint configuration

Available configuration parameters

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

Parameter	Default	Description
`enable_mcp_developer`	`true`	Enable or disable the `/api/mcp/developer` endpoint. When the endpoint is disabled, requests return HTTP 503 (Service Unavailable).
`mcp_max_response_size`	`1000000`	Maximum response size in bytes. Queries exceeding this limit return an error.

The developer endpoint is enabled by default. To disable it:

Contact Materialize support to disable the MCP developer endpoint for your environment.

Disable the endpoint using one of these methods:

Option 1: Configuration file

system_parameters:
  enable_mcp_developer: "false"

Option 2: Terraform

Set the parameter via the Materialize Terraform module:

system_parameters = {
  enable_mcp_developer = "false"
}

Option 3: SQL

Connect as mz_system and run:

ALTER SYSTEM SET enable_mcp_developer = false;

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

The privileges required to use this endpoint are:

USAGE on system catalog schemas and SELECT on system catalog objects. These privileges are granted by default.
If agents also need access to replica-specific metrics from mz_introspection, USAGE privileges on the corresponding cluster.