How do I install the Mz Profile skill?

Run npx skillmds@latest add materializeinc/mz-profile in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Mz Profile safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Mz Profile?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Mz Profile free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Mz Profile?

materializeinc (@materializeinc) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Mz Profile by materializeinc — Agent Skill

Name: Mz Profile
Author: materializeinc

Mz Profile

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries, high CPU/memory in Materialize. Also "slow" or "using too much memory" without explicit profile mention.

File contents

Profiling Materialize

CPU profiling

Prefer profiling with samply, which produces Firefox Profiler-compatible flame graphs.

Attach to a running process: samply record -p PID
Record environmentd from startup: bin/environmentd --wrapper "samply record"
Record clusterd processes from startup: bin/environmentd -- --orchestrator-process-wrapper "samply record"

Samply opens a browser tab with an interactive flame graph when recording finishes.

On macOS, enable codesigning for Instruments support: bin/environmentd --enable-mac-codesigning

Memory profiling

Valgrind doesn't work on Materialize as it's too slow to yield results. Heaptrack works, but is slow.

Run heaptrack on environmentd processes: bin/environmentd --reset --no-default-features --wrapper "heaptrack --raw" Run heaptrack on clusterd processes: bin/environmentd --reset --no-default-features -- --orchestrator-process-wrapper "heaptrack --raw" Use heaptrack --interpret on the .raw.zst file to analyze.

Set MALLOC_CHECK_=3 MALLOC_PERTURB_=123 (and compile with --no-default-features on Linux to use the system allocator instead of jemalloc) to detect some memory corruption issues.

Analyze the size of binary functions

nm --demangle=rust --print-size --size-sort --radix=d BINARY to determine the binary size of symbols in BINARY. Produces a potentially large output, which should be redirected and analyzed separately. Filter with cut -d' ' -f2- | sort | sort -k3 | uniq to just learn about the size of symbols.

Frequently asked questions