Materialize is wire-compatible with PostgreSQL and can integrate with many SQL clients and other tools that support PostgreSQL. To help you connect to Materialize using various clients and tools, the following references are available:

Materialize Tools

• mz - Materialize CLI
• mz-debug (Debug tool)

SQL clients/client libraries

• SQL clients
• Client Libraries

See also the following integration guides for BI tools:

• Deepnote
• Excel
• Hex
• Metabase
• Power BI
• Tableau
• Looker

HTTP and WebSocket

• Connect to Materialize via HTTP
• Connect to Materialize via WebSocket

AI agents

• MCP Server for Agents — built-in endpoint for exposing real-time data products to AI agents
• MCP Server for Observability — built-in endpoint for AI-powered troubleshooting via system catalog
• MCP Server (Python) — standalone Python server with stdio and sse transport support, for use outside the built-in endpoints
• Coding Agent Skills

Foreign data wrapper

• Foreign data wrapper