Materialize Developer Analysis

Analyze a Materialize environment via the MCP Developer endpoint and produce a structured report with health status, performance findings, and optimization recommendations.

The developer endpoint exposes two read-only tools:

• query_system_catalog — SELECT/SHOW/EXPLAIN restricted to system catalog tables (mz_*, pg_catalog, information_schema). Does not take a cluster argument; runs on the catalog server cluster (mz_catalog_server). Use for most catalog lookups.
• query (added in Materialize v26.30) — SELECT/SHOW/EXPLAIN against any object the role can access, including user objects on a named cluster. Required for EXPLAIN ANALYZE (it must run on the MV/index's cluster) and for reading user data directly. May be hidden when the operator has disabled enable_mcp_developer_query_tool.

Connecting an MCP client to materialize-developer