Agent skill

Mz Profile

by MaterializeInc in MaterializeInc/materialize

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries…

Custom licenceAuto-check passedDevelopment

Install Mz Profile

skills CLI
$ npx skills add MaterializeInc/materialize --skill mz-profile -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install MaterializeInc/materialize mz-profile --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/MaterializeInc/materialize.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/mz-profile .claude/skills/mz-profile && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
mz-profile
GitHub stars
6.4k
Token cost
~480 tokens
SKILL.md length
185 words
Files
1
Skills in repo
15
Repo updated
First seen
Licence
Custom licence

At a glance

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries…

  • Tasks that involve Performance optimization
  • SKILL.md covers CPU profiling, Memory profiling and Analyze the size of binary…
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Tasks that involve Query optimization

What it does

Mz Profile is an agent skill from MaterializeInc/materialize. 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.

Its SKILL.md is about 480 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Development, covering Performance optimization and Query optimization. It works with Rust and PostgreSQL. The repository describes itself as: The live data layer for apps and AI agents. Create up-to-the-second views into your business, just using SQL.

When your agent uses it

  • Tasks that involve Performance optimization
  • Tasks that involve Query optimization

Example prompts

  • “profile Materialize”
  • “check memory usage”
  • “analyze binary size”
  • “/mz-profile”

What it can do on your machine

Read from SKILL.md and the folder at commit b760ecc. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • github.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Mz Profile loads about 480 tokens when it runs. Until then it costs about 78 tokens; SKILL.md has 185 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~78
When it runs · the whole SKILL.md, loaded when a task matches
~480

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 185 words (~480 tokens).

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

— opening of SKILL.md by MaterializeInc, Custom licence
name
mz-profile

Read the full SKILL.md on GitHub

Files

Just SKILL.md in .agents/skills/mz-profile of MaterializeInc/materialize.

Open the folder on GitHubat commit b760ecc

Compare with similar skills

Mz Profile next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Mz Profile compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Mz Profile this skillMaterializeInc/materialize6.4k—~480Automated safety check: PassCustom licence
Performance OptimizationHack23/cia239—~1.9kAutomated safety check: PassApache-2.0
Veloxdb Scalable Performanceveloxbase/veloxdb646—~1.7kAutomated safety check: PassMIT
Paro Optimizerzunor/paro105—~979Automated safety check: PassApache-2.0
Database OptimizerJeffallan/claude-skills12k—~1.6kAutomated safety check: PassMIT
SQL Optimizationgithub/awesome-copilot40k2 repos~2.3kAutomated safety check: PassMIT

Similar skills

  • Application performance tuning, JVM optimization, database query tuning, Vaadin UI performance

    239 GitHub stars~1.9k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Guides scalability and performance work for VeloxDB's Tauri + Rust PostgreSQL backend and React + TanStack frontend.

    646 GitHub stars~1.7k tokensUpdated 8 days ago
    DatabasesAuto-check passed
  • Paro Optimizer

    zunor/paro

    Design, refactor and diagnose Paro's staged optimizer, using EXPLAIN COMPILE for planning and EXPLAIN ANALYZE for execution.

    105 GitHub stars~979 tokensUpdated today
    DatabasesAuto-check passed
  • Database Optimizer

    Jeffallan/claude-skills

    Tunes PostgreSQL and MySQL performance by analyzing slow queries and execution plans, designing indexes, rewriting queries and adjusting configuration, one validated change at a time.

    12k GitHub stars~1.6k tokensUpdated 5 days ago
    DatabasesAuto-check passed
  • SQL Optimization

    github/awesome-copilot

    Official

    Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…

    40k GitHub starsUsed in 2 repos~2.3k tokens
    DatabasesAuto-check passed
  • Odoo Performance Tuner

    sickn33/agentic-awesome-skills

    Expert guide for diagnosing and fixing Odoo performance issues: slow queries, worker configuration, memory limits, PostgreSQL tuning, and profiling tools.

    47k GitHub starsUsed in 2 repos~1.2k tokens
    DatabasesAuto-check passed

More from MaterializeInc/materialize

All 15 skills in this repo
  • Mz Release Signoff

    MaterializeInc/materialize

    Verify a release candidate on the Grafana dashboards and sign off in release.

    6.4k GitHub stars~7.2k tokensUpdated today
    Auto-check passed
  • Mz Benchmark

    MaterializeInc/materialize

    Add/modify/debug Materialize perf benchmark scenarios. An agent skill from MaterializeInc/materialize.

    6.4k GitHub stars~2.8k tokensUpdated today
    Auto-check passed
  • Mz Commit

    MaterializeInc/materialize

    Trigger: "commit", "prepare commit", "create PR", "push", "open pull request", or mentions committing, pre-commit checks, pull requests in Materialize.

    6.4k GitHub stars~2.3k tokensUpdated today
    Auto-check passed
  • Mz Dbt Release

    MaterializeInc/materialize

    Cut a dbt-materialize PyPI release: bump the version in version.py and setup.py, date the Unreleased CHANGELOG entry, and open the release PR with a Ship: <url body.

    6.4k GitHub stars~1.2k tokensUpdated today
    Auto-check passed
  • Mz Debug CI

    MaterializeInc/materialize

    Investigate CI failures on PR via gh + Buildkite MCP or bk CLI.

    6.4k GitHub stars~3.9k tokensUpdated today
    Auto-check passed
  • Mz Limits Test

    MaterializeInc/materialize

    Add/modify/debug limits test. An agent skill from MaterializeInc/materialize.

    6.4k GitHub stars~808 tokensUpdated today
    Auto-check passed

Works with

Questions about Mz Profile

What does Mz Profile do?

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries…. Mz Profile is an agent skill from MaterializeInc/materialize. 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.

When should I use Mz Profile?

Mz Profile fits situations like: tasks that involve Performance optimization; tasks that involve Query optimization.

How do I install Mz Profile in Claude Code?

Run `npx skills add MaterializeInc/materialize --skill mz-profile -a claude-code`. Or copy the skill folder (.agents/skills/mz-profile in MaterializeInc/materialize) into .claude/skills/mz-profile in your project. Claude Code loads it when a task matches its description.

How do I install Mz Profile in Codex?

Run `npx skills add MaterializeInc/materialize --skill mz-profile -a codex`. Or copy the skill folder (.agents/skills/mz-profile in MaterializeInc/materialize) into .agents/skills/mz-profile in your project. Codex loads it when a task matches its description.

Can I use Mz Profile in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add MaterializeInc/materialize --skill mz-profile -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/mz-profile, .gemini/skills/mz-profile, .github/skills/mz-profile and .opencode/skills/mz-profile in your project.

What does Mz Profile need to run?

SKILL.md names no scripts, command-line tools or credentials: Mz Profile is instructions for the agent only.

Does Mz Profile access the network?

SKILL.md names 1 domain. As links in the text: github.com. This is read from the text; nothing was executed.

Is Mz Profile safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Mz Profile use?

Mz Profile has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Mz Profile use?

About 480 tokens (SKILL.md is roughly 1.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Mz Profile?

Skills that share tags, products or a category with Mz Profile: Performance Optimization (Hack23/cia, 239 stars), Veloxdb Scalable Performance (veloxbase/veloxdb, 646 stars), Paro Optimizer (zunor/paro, 105 stars) and Database Optimizer (Jeffallan/claude-skills, 12k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Mz Profile?

MaterializeInc (a GitHub organization) maintains it in MaterializeInc/materialize, which has 6,377 GitHub stars. The repository holds 15 skills in this directory. The repository was last updated on October 8, 2026.

Source: MaterializeInc/materialize on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.