Materialize Logo

CLI Connections

You can connect to a running materialized process from your favorite shell using a compatible command-line client.

Connection details

Detail Info
Database materialize
Port 6875
SSL Not supported yet

Supported tools

Tool Description Install
mzcli Materialize-specific CLI GitHub
psql Vanilla PostgreSQL CLI tool postgresql or postgresql-client
WARNING! Not all features of psql are supported by Materialize.

Other tools built for PostgreSQL can often be made to work with Materialize with minor modifications, but are unlikely to work out of the box. File a GitHub issue if there is a PostgreSQL tool you would like us to consider supporting.


mzcli example

You can connect to materialized with mzcli using:

mzcli -h <host>

psql example

You could use any of the following formats to connect to materialized with psql:

psql postgres://<host>:6875/materialize
psql -h <host> -p 6875 materialize
psql -h <host> -p 6875 -d materialize
psql host=<host> port=6875 dbname=materialize