PostgreSQL

Category

Databases

Runs in

The Phloem cloud — nothing to install

Lets you and Hamming query a PostgreSQL database with SQL, with its tables listed in Trace.

#What Phloem reads

• Schemas, tables, views, columns and foreign keys, listed in Trace for Hamming and SQL autocomplete
• System schemas (information_schema, pg_catalog) are left out

#What you need

• The server's host and port (default 5432), reachable from Phloem's cloud
• The database name
• A username and password. Best: a dedicated phloem role with SELECT on the schemas you want.

Your credentials are stored in Phloem's cloud and used only to query this database.

#What Hamming can do

• Run SQL that you or Hamming write

#Notes

• Phloem runs any statement, not only SELECT. The role's privileges decide what a query can change.
• Use a replica endpoint for heavy analysis.

#Connection fields

What the Add connector form asks for.

Updated November 6, 2026