Overview

The PostgreSQL connector makes database schemas and table contents searchable in PipesHub. Teams can ask questions about structured operational data alongside documents, tickets, and code without writing SQL.

How it works

PipesHub connects using a read-only database user, via either basic credentials or a connection string. It reads schemas, tables, columns, data types, keys, relationships, and CREATE TABLE statements, then optionally indexes row content up to a configurable limit (default 1,000 rows per table).

Configure

• Create a dedicated read-only user with SELECT privileges on the target schemas and tables

• Enter host, port, database, username, and password or a postgresql:// connection string with URL-encoded special characters

• Select which schemas and tables to include

• Set the max rows per table and toggle whether to index table contents

• Choose sync strategy and interval, then save to begin indexing