PostgreSQL

PostgreSQL integration

Relational database queries via PostgreSQL.

All integrations · Settings → Integrations

What is PostgreSQL?

PostgreSQL is an open-source relational database used for structured data, SQL queries, and transactional applications. It powers many web apps, analytics pipelines, and internal tools with tables, indexes, and roles you configure.

Assistant

The PostgreSQL MCP reference server would let the assistant run read-only SQL and inspect schema metadata against a database connection you provide. Inserts, updates, deletes, and DDL would stay approval-gated by default.

  • Run read-only SELECT queries against allowed schemas
  • Inspect tables, columns, and indexes
  • Execute INSERT, UPDATE, DELETE, or DDL only with approval

Workflows

Workflow steps for PostgreSQL are not available in this release. The assistant can still use MCP tools when the integration is connected.

How to connect

  1. Open Settings → Integrations.
  2. On the PostgreSQL card, choose Connect.
  3. Sign in with the provider when prompted and allow the access Dailify requests.
  4. Pick a default policy for new tools (Require approval is recommended).

PostgreSQL is not available to connect yet. The steps above apply when it ships.

Permissions and safety

  • New MCP tools default to Require approval unless you choose Auto-run when connecting.
  • After connecting, open Manage on the integration card to change permissions per discovered tool.
  • The assistant only sees data your provider account can access — Dailify does not broaden OAuth scope beyond what you grant.