> ## Documentation Index
> Fetch the complete documentation index at: https://docs.xpander.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Postgres

> Connect Postgres to xpander and give agents its 8 actions: how to create the API key and connect it, and which actions to hold for approval.

<Badge color="blue">HTTP API connector</Badge>

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](/use/agents/permissions#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](/use/skills).

## Related Resources

* [Skills](/use/skills)