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 Developers — built-in endpoint for AI-powered troubleshooting via system catalog
• Coding Agent Skills

Foreign data wrapper

• Foreign data wrapper