# Materialize

> Use this tool when you need to automatically generate MCP resources from a Materialize database cluster, enabling effortless lookups and queries through parameterized URLs. It solves the problem of manual resource configuration for teams using Materialize, allowing them to expose indexed views through natural language interaction. Ideal for use cases where dynamic URI templates and handlers are required, providing a clean interface for AI assistants to query materialized views.

Canonical page: https://skillsregistry.net/skills/sjwiesman-materialize  
JSON: https://api.skillsregistry.net/v1/skills/sjwiesman-materialize

## Description

Automatically creates MCP resources based on indexes in a Materialize database cluster. The server dynamically generates URI templates and handlers for each index found in the catalog, enabling lookups through parameterized URLs like 'materialize://customers/123'. Built with FastMCP and asyncpg, it provides a clean interface for querying materialized views through AI assistants without manual resource configuration. Particularly valuable for teams using Materialize who want to expose their indexed views through natural language interaction.

## Trust

- **Trust score (0–1):** 0.99
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-28

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/sjwiesman-materialize)
- **Repository:** <https://github.com/sjwiesman/mcp-materialize>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "sjwiesman-materialize"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/sjwiesman-materialize` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/sjwiesman-materialize/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt