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
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.
pg_catalog
in Materialize (#9720), you must turn off automatic database introspection in DataGrip to connect.
