Skip to content
Postgres logo

Postgres MCP server

The world's most advanced open-source relational database

Postgres is not a separate install. One Activepieces MCP server exposes it alongside 760+ other apps, behind a single URL.

Tools
6
Works with
Any MCP client
Auth
Custom auth
License
MIT, open source
Updated
August 2026

About the Postgres MCP server

Connect Postgres once in Activepieces and every action it ships becomes a tool your assistant can call, behind the same server URL as the rest of your apps. Your agent reaches Postgres and 760+ other apps over a single connection, on our cloud or a self-hosted install.

Tools

Postgres tools your AI can run

Once connected, your assistant can call any of these Postgres actions by asking in plain language.

  • Find Rows

    Reads rows from a table

    6 fields

  • Insert Row

    Inserts a new row into a table

    3 fields

  • Update Row

    Updates one or more rows in a table

    5 fields

  • Delete Row

    Deletes one or more rows from a table

    4 fields

  • Get Tables

    Returns the tables in the database

  • Run Query

    Run Query

    6 fields

Triggers

Postgres events your agent can watch

These start a run the moment something happens in Postgres, so work gets picked up on its own.

  • New Row

    triggered when a new row is added

    4 fields

Give your assistant Postgres

Connect Postgres once and every tool above is callable from Claude, Cursor or any MCP client, behind the same server URL as 760+ other apps. Free to start.

Postgres MCP, answered.

No. That is the point of it. One Activepieces server exposes Postgres alongside every other piece you connect, so your client keeps a single connection.

Yes. Activepieces is open source and free to start, and the MCP server is included on every plan, from the free cloud tier to any self-hosted deployment.

Connect Postgres in Activepieces, enable the server under Settings → MCP Server, then paste your server URL into your client config. It authenticates over OAuth on first use.

It can call 6 tools, including Find Rows, Insert Row, Update Row, and chain them with steps in other apps inside the same run.

Connections use OAuth2 with limited scopes and are stored under 256-bit encryption, with no API to read them back, so an agent gets scoped access rather than your keys.