PostgreSQL for your team's AI workspace.

Connect once

SQL access with org-level guardrails.

Postgres holds operational and product data. Connect with a read-only database user in Faction so chat can query tables without every teammate storing connection strings locally.

Postgres connector is not ready yet

This connector is disabled on the hosted gateway. The upstream package `@modelcontextprotocol/server-postgres@0.6.2` is archived/deprecated and its bundled `pg` v8 crashes (exit 1) when querying Supabase: it does full TLS chain verification and rejects Supabase's self-signed cert. We confirmed a raw `pg` connection succeeds only with `sslmode=no-verify` (TLS on, chain verification off), and Faction now rewrites Supabase URLs to that — but the MCP server process still exits during query handling on the gateway, so chat queries fail. TODO before enabling: (1) replace the archived server with a maintained Postgres MCP server (or fork that accepts an `ssl: { rejectUnauthorized:false }` option / honors `sslmode=no-verify`), (2) confirm tool discovery and a `query` round-trip end-to-end on `gateway.runfaction.com`, (3) flip status back to `live`. Notes: use the Supabase **Session pooler** URI (`aws-0-<region>.pooler.supabase.com:5432`, user `postgres.<project-ref>`) — direct `db.<project>.supabase.co` URLs are IPv6-only and unreachable from the Docker MCP runtime. For Supabase projects, prefer the Supabase catalog connector.

Use cases

• Ad hoc analytics

  Answer one-off counts and breakdowns for ops and leadership.

• Support lookups

  Find a record or order line during an escalation.

• Data quality checks

  Spot null rates or duplicate rows before a report goes out.

How it works

Add PostgreSQL to your organization

Install PostgreSQL from the catalog, add it to workspaces, and let teammates chat with shared access.

• An admin connects PostgreSQL from the integration catalog.
• Add the connector to the workspaces that need it.
• Teammates open chat with the tools you enabled. No per-person setup.

FAQs

• Is PostgreSQL available in Faction today?

  PostgreSQL is in the catalog but needs additional setup before your org can install it.

• How does authentication work?

  Faction uses API key for this connector. Credentials stay on Faction, not on member laptops.

• Who can use this integration?

  Teammates in the workspaces you choose. Everyone else keeps working without extra setup.

• Can we choose what each team gets access to?

  Yes. Add the connector to the workspaces that need it and pick which tools are on for each team.