Amazon Redshift MCP

An open-source Model Context Protocol server provided by AWS Labs that enables AI agents to interact with Amazon Redshift. It allows agents to perform data warehouse operations, execute SQL queries, and manage analytics workloads directly within their workflows, supporting both local and remote deployment scenarios.

Package and access

Local package with source-attributed installation metadata. Koskamo does not execute packages during review.

Community listingLocal stdioSource reviewed; not executedPublished by awslabs

Vendor documentation

What you can do with it

Execute SQL queries on Amazon Redshift data warehouses
Perform data warehouse operations and analytics tasks
Integrate Redshift data access into AI agent workflows

Source and maintenance

Community listing

docker-mcp: awslabs-redshift Source repository Project website

Maintenance checked: Nov 1, 2026, 4:30 AM UTC

Packages and installation

Source-provided package data. Koskamo has not executed or live-probed this package.

mcp/redshift-mcp-server@sha256:51e3087b8a9dc118a0359d87984c2d2a7a6636063c35fc7fb270b40799fc427e

oci

mcp/redshift-mcp-server@sha256:51e3087b8a9dc118a0359d87984c2d2a7a6636063c35fc7fb270b40799fc427e package definition

{
  "transport": "stdio",
  "identifier": "mcp/redshift-mcp-server@sha256:51e3087b8a9dc118a0359d87984c2d2a7a6636063c35fc7fb270b40799fc427e",
  "registryType": "oci",
  "registryBaseUrl": "https://registry-1.docker.io"
}

Tools

Reported by the attributed source; not independently observed by Koskamo.

execute_query

Reported by the attributed source; not independently observed by Koskamo.

execute_query input schema

{
  "type": "",
  "required": null,
  "properties": null
}

list_clusters

Reported by the attributed source; not independently observed by Koskamo.

list_clusters input schema

{
  "type": "",
  "required": null,
  "properties": null
}

list_columns

Reported by the attributed source; not independently observed by Koskamo.

list_columns input schema

{
  "type": "",
  "required": null,
  "properties": null
}

list_databases

Reported by the attributed source; not independently observed by Koskamo.

list_databases input schema

{
  "type": "",
  "required": null,
  "properties": null
}

list_schemas

Reported by the attributed source; not independently observed by Koskamo.

list_schemas input schema

{
  "type": "",
  "required": null,
  "properties": null
}

list_tables

Reported by the attributed source; not independently observed by Koskamo.

list_tables input schema

{
  "type": "",
  "required": null,
  "properties": null
}

Connect from your client

Each snippet configures the same source-provided package; replace placeholders before use.

This server is operated by the named third party. Listing and endpoint checks are not an endorsement or a security audit. Review the operator's permissions, terms, and data handling before connecting. How listings are checked and corrected.

Cursor

Merge this local stdio configuration, replace every placeholder environment value, and restart Cursor. Koskamo has not executed this package.

Cursor configuration

{
  "mcpServers": {
    "amazon-redshift-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/redshift-mcp-server@sha256:51e3087b8a9dc118a0359d87984c2d2a7a6636063c35fc7fb270b40799fc427e"
      ]
    }
  }
}

Cline

Merge this local stdio configuration, replace every placeholder environment value, and restart Cline. Koskamo has not executed this package.

Cline configuration

{
  "mcpServers": {
    "amazon-redshift-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/redshift-mcp-server@sha256:51e3087b8a9dc118a0359d87984c2d2a7a6636063c35fc7fb270b40799fc427e"
      ]
    }
  }
}

VS Code

Merge this local stdio configuration, replace every placeholder environment value, and restart VS Code. Koskamo has not executed this package.

VS Code configuration

{
  "servers": {
    "amazon-redshift-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/redshift-mcp-server@sha256:51e3087b8a9dc118a0359d87984c2d2a7a6636063c35fc7fb270b40799fc427e"
      ]
    }
  }
}

Claude Desktop

Merge this local stdio configuration, replace every placeholder environment value, and restart Claude Desktop. Koskamo has not executed this package.

Claude Desktop configuration

{
  "mcpServers": {
    "amazon-redshift-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/redshift-mcp-server@sha256:51e3087b8a9dc118a0359d87984c2d2a7a6636063c35fc7fb270b40799fc427e"
      ]
    }
  }
}

Let your agent find its tools

Find servers like Amazon Redshift MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.

Connect Koskamo Explore workflows