MaterializeInc/agent-skills

MaterializeInc/agent-skills

Skill Claude CodeCodex

Materialize documentation for SQL syntax, data ingestion, concepts, and best practices. Use when users ask about Materialize queries, sources, sinks, views, or clusters.

MaterializeInc/agent-skills

Skill Claude CodeCodex

Analyze a Materialize environment via the MCP Developer endpoint, and/or configure an MCP client (Claude Code, Cursor, VS Code, Zed, Continue, Windsurf, Claude Desktop) to connect to the materialize-developer server. For analysis: check environment health, investigate performance, troubleshoot stale materialized…

MaterializeInc/agent-skills

Skill Claude CodeCodex

Use when reading or editing .sql files in an mz-deploy project (a directory with project.toml) — resolve object references, columns, and types with the LSP tool instead of grepping. Covers go-to-definition, hover, and document/workspace symbols for Materialize SQL.

MaterializeInc/agent-skills

Skill Claude CodeCodex

Using the dbt-materialize adapter to manage Materialize streaming pipelines with dbt. Covers materializations (source, sourcetable, view, materializedview, sink, table, seed), profile configuration, index creation, blue/green deployments (deployinit, deploypromote, deploycleanup), cluster management, strict mode, and…

MaterializeInc/agent-skills

Skill Claude CodeCodex

Use when a Materialize object is behind wall-clock time — high lag in mzwallclockgloballag, a stale or lagging materialized view, index, or sink, a freshness alert, results that keep showing old data, or a dataflow whose output cannot keep up with its input.

MaterializeInc/agent-skills

Skill Claude CodeCodex

Using the Materialize Terraform provider to manage Materialize resources declaratively. Covers clusters, sources (Kafka, Postgres, MySQL, SQL Server), sinks (Kafka, Iceberg), connections, materialized views, indexes, tables, roles, grants, secrets, network policies, and cloud-only resources (users, SSO, SCIM, app…

MaterializeInc/agent-skills

Skill Claude CodeCodex

Terraform modules for deploying self-managed Materialize on AWS (EKS), Azure (AKS), and GCP (GKE). Covers networking, Kubernetes clusters, managed PostgreSQL, object storage, the Materialize operator, and Materialize instance configuration. Use this skill whenever the user asks about deploying self-managed Materialize…

MaterializeInc/agent-skills

Skill Claude CodeCodex

Using the mz-deploy CLI to manage a declarative SQL project for Materialize — project layout and the stage/wait/promote deployment lifecycle. Use this skill whenever the user is working in an mz-deploy project (a directory containing project.toml), asks how to deploy SQL changes to Materialize safely, or mentions…

MaterializeInc/agent-skills

Skill Claude CodeCodex

Designing and reviewing the semantic layer of a Materialize SQL code base as a canonical ontology — a shared raw database, a shared core database, and one database per use case. Use this skill when a user asks how to structure or organize Materialize schemas and databases, wants to define canonical semantic objects…