materialize-mcp-server
0
Materialize MCP Server transforms Materialize indexed views into fully-typed, callable tools using the Model Context Protocol. It offers stability and security by defining operational data products and ensures performance and cost transparency by logging tool usage.
Materialize MCP Server
Transform your Materialize indexed views into callable tools via the Model Context Protocol (MCP). Define secure and stable data tools by creating SQL views and indexing them.
- Stable: Define once and use repeatedly.
- Typed: Input and output schemas derived from the index.
- Secure: Callable only if view/index is created.
Installation
Install locally using uv.
Why not execute_sql?
- Avoids brittleness in production by removing variability and ensuring stable business logic.
- Provides explicit performance and cost by logging usage per tool.
Quickstart
Run the server with default settings using uv.
Configuration
Table outlining server configuration options and defaults.
Defining a Tool
- Write a view for business logic.
- Index the desired query columns.
- Comment for discoverability.
Refresh server to list tool.