Skip to content
Amazon Redshift logo

Amazon Redshift MCP server

Fully managed cloud data warehouse from AWS.

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

Tools
5
Works with
Any MCP client
Auth
Custom auth or Connection
License
MIT, open source
Updated
November 2026

About the Amazon Redshift MCP server

Connect Amazon Redshift 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 Amazon Redshift and 770+ other apps over a single connection, on our cloud or a self-hosted install.

Tools

Amazon Redshift tools your AI can run

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

  • Insert Rows

    Inserts one or more rows into a table.

    2 fields

  • Update Rows

    Updates every row where a column equals a value.

    4 fields

  • Delete Rows

    Deletes every row where a column equals a value.

    3 fields

  • Find Rows

    Finds rows where a column equals a value.

    4 fields

  • Run Query

    Runs one SQL statement.

    3 fields

Triggers

Amazon Redshift events your agent can watch

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

  • New Row

    Triggers when a new row is added to a table.

    2 fields

  • New or Updated Row

    Triggers when a row is added or its timestamp column changes.

    2 fields

Give your assistant Amazon Redshift

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

Amazon Redshift MCP, answered.

No. That is the point of it. One Activepieces server exposes Amazon Redshift 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 Amazon Redshift 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 5 tools, including Insert Rows, Update Rows, Delete Rows, 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.