How it works
The Postgres connector indexes table metadata for a given database and schema: it lists tables frominformation_schema and stores each table’s structure as a simplified CREATE TABLE DDL (column names and types). It does not index row-level table data.
Indexed content is refreshed on the connector’s normal schedule (typically daily, like other connectors).
Setting up
Authorization
Postgres uses a standard TCP connection with database credentials. Create a credential with:- Host — hostname or IP of your Postgres server (e.g.
db.example.com) - Port — Postgres port (default is usually
5432) - User — role that can connect and read catalog metadata for the target schema
- Password — password for that role
information_schema.tables and information_schema.columns for the schema you configure. Prefer a dedicated user with minimal rights when possible.
Ensure the Hymalaia deployment can reach the host (firewall, VPN, security groups, etc.).
Indexing
1
Open Postgres connector
In the Hymalaia Admin Panel, open the Postgres connector.
2
Configure authorization
In Step 1, set up credentials:
- Select an existing Postgres credential, or click Create New
- Enter Host, Port, User, and Password
3
Save configuration
Click Create (or equivalent) to save the credential configuration.
4
Continue with selected credential
Ensure the correct credential is selected, then click Continue.
5
Specify database and schema
In Step 2, specify:
- Database — the database name to connect to (e.g.
analytics) - Schema — the schema whose tables you want indexed (e.g.
public)
6
Finish connector setup
Choose a connector name, set document access, assign groups if needed, then create the connector. Indexing will run on the connector schedule (typically daily).