You can connect to a running
materialized process from your favorite shell
using a compatible command-line client.
|User||Any valid role (usually
Changed in v0.7.0: Materialize requires that you name a valid user when you connect. Previously, Materialize did not support the concept of roles, so it accepted all user names.
||Vanilla PostgreSQL CLI tool||
psqlare 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.
You can connect to
mzcli -h <host>
You could use any of the following formats to connect to
psql postgres://materialize@<host>:6875/materialize psql -U materialize -h <host> -p 6875 materialize psql -U materialize -h <host> -p 6875 -d materialize psql user=materialize host=<host> port=6875 dbname=materialize