Skip to main content
HTTP API connector An HTTP API described by an OpenAPI spec, not an MCP server. Calls go through xpander’s function endpoint https://functions.xpander.ai/postgres, which fronts the Postgres API, and carry an API key in the x-pg-connection-string header.

​
What the skill can do

API connector: 8 actions, as they appear in the skill panel. 8 of them create, change or delete something in Postgres; mark those under These actions need approval when you add the skill to an agent.
  • Schema discovery (5): Postgre Sqlschema Discovery Get Table Columns By Schema Table, Postgre Sqlschema Discovery List Tables By Schema Name, Postgre Sqlschema Discovery Get Constraints By Schema Table, Postgre Sqlschema Discovery List Indexes By Schema Table, Postgre Sqlschema Discovery List Schemas In Database
  • Statement execution (1): Postgre Sqlstatement Execution Execute Sql Statement
  • Query execution (1): Postgre Sqlquery Execution Run Read Only Query
  • Connection validation (1): Postgre Sqlconnection Validation Validate Connection String

​
Connect Postgres

In Xpander Chat, open the agent’s settings, click Add skill, and search for Postgres. The connect dialog asks for a connection name and whether the connection is for the Organization (one shared account) or Personal (your own account, so the agent acts with your permissions where systems allow). On an agent other people use, a personal connection runs their requests as you unless the binding requires each person’s own sign-in; see whose credential a shared agent uses. Postgres connects with an API key. Create the key in Postgres, paste it into the dialog, and click Connect. The key goes to the vault; the agent references it and never sees the value. Calls go to https://functions.xpander.ai/postgres.

​
Give an agent the Postgres skill

Once Postgres is connected, any agent you can edit may be given the skill: open the agent’s settings, click Add skill, and choose Postgres. Enable only the action groups the agent needs, and mark the actions that should wait for a named person’s sign-off under These actions need approval. Which skills exist for your organization, and who may add them, is decided by your admins; see Skills.