SQL clients

Materialize is wire-compatible with PostgreSQL, which means it integrates with most SQL clients that support PostgreSQL (see Tools and Integrations). In this guide, we’ll cover how to connect to your Materialize region using common SQL clients.

`psql`

WARNING! Not all features of psql are supported by Materialize yet, including some backslash meta-commands (#9721).

Start by double-checking whether you already have psql installed:

psql --version

Assuming you’ve installed Homebrew:

brew install libpq

Then symlink the psql binary to your /usr/local/bin directory:

brew link --force libpq

Start by double-checking whether you already have psql installed:

psql --version

sudo apt-get update
sudo apt-get install postgresql-client

The postgresql-client package includes only the client binaries, not the PostgreSQL server.

For other Linux distributions, check out the PostgreSQL documentation.

Start by double-checking whether you already have psql installed:

psql --version

Download and install the PostgreSQL installer certified by EDB.

DBeaver

To connect to Materialize using DBeaver, follow the documentation to create a connection and use the PostgreSQL database driver with the credentials provided in the Materialize UI.

DataGrip

To connect to Materialize using DataGrip, follow the documentation to create a connection and use the PostgreSQL database driver with the credentials provided in the Materialize UI.

NOTE: As we work on extending the coverage of pg_catalog in Materialize (#9720), you must turn off automatic database introspection in DataGrip to connect.