Skip to content
MCP-BridgeMCP-Bridge
Cloud InfrastructureAuto-generatedScore: 46

Redshift Data API Service MCP Server

<p>You can use the Amazon Redshift Data API to run queries on Amazon Redshift tables. You can run SQL statements, which are committed if the statement succeeds. </p> <p>For more information about the Amazon Redshift Data API and CLI usage examples, see <a href="https://docs.aws.amazon.com/redshift/l

Quick Answer

  1. 1. The Redshift Data API Service MCP server lets Claude, Cursor, and VS Code interact with the Redshift Data API Service API through natural language.
  2. 2. Setup: Add the config to claude_desktop_config.json, set your environment variables, and restart.
  3. 3. 10 operations available including BatchExecuteStatement, CancelStatement, DescribeStatement, and more.
  4. 4. Quality score: 46/99 — fair source quality and documentation coverage.

Overview

Category: Cloud Infrastructure

Auth: None

Endpoints: 10

Transport: STDIO

Command: npx -y @mcp/amazonaws-com-redshift-data

Spec: v2019-12-20

Setup time: ~30 sec (no auth)

Environment Variables

REDSHIFT_DATA_API_SERVICE_API_KEY

Example: your_redshift_data_api_service_api_key

One-Click Install

Copy the snippet for your MCP client and paste it in — zero editing required.

Claude Desktop

Add to claude_desktop_config.json

{
  "mcpServers": {
    "amazonaws-com-redshift-data": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp/amazonaws-com-redshift-data"
      ],
      "env": {
        "REDSHIFT_DATA_API_SERVICE_API_KEY": "your_redshift_data_api_service_api_key"
      }
    }
  }
}
Deep link

Cursor

Settings → MCP Servers → Add

{
  "mcpServers": {
    "amazonaws-com-redshift-data": {
      "url": "https://mcpbridge.org/config/amazonaws-com-redshift-data.json"
    }
  }
}

Saves as .cursor/mcp.json in the download. Move it to your project root.

Deep link install →

VS Code

Use with MCP extension

{
  "mcpServers": {
    "amazonaws-com-redshift-data": {
      "url": "https://mcpbridge.org/config/amazonaws-com-redshift-data.json"
    }
  }
}

MCP Server Configuration

Add this to your claude_desktop_config.json or Cursor MCP settings.

{
  "mcpServers": {
    "amazonaws-com-redshift-data": {
      "command": "npx",
      "args": ["-y","@mcp/amazonaws-com-redshift-data"],
      "env": {
      "REDSHIFT_DATA_API_SERVICE_API_KEY": "your_redshift_data_api_service_api_key"
}
    }
  }
}

What You Can Build

With the Redshift Data API Service MCP server, your AI assistant can:

  • Access 10 API operations through natural language
  • Read, create, and modify cloud infrastructure resources without writing HTTP requests
  • Chain multiple operations in a single conversation for complex workflows
  • Combine with other MCP servers for cross-tool automation

Endpoints

POST/#X-Amz-Target=RedshiftData.BatchExecuteStatement

BatchExecuteStatement

POST/#X-Amz-Target=RedshiftData.CancelStatement

CancelStatement

POST/#X-Amz-Target=RedshiftData.DescribeStatement

DescribeStatement

POST/#X-Amz-Target=RedshiftData.DescribeTable

DescribeTable

POST/#X-Amz-Target=RedshiftData.ExecuteStatement

ExecuteStatement

POST/#X-Amz-Target=RedshiftData.GetStatementResult

GetStatementResult

POST/#X-Amz-Target=RedshiftData.ListDatabases

ListDatabases

POST/#X-Amz-Target=RedshiftData.ListSchemas

ListSchemas

POST/#X-Amz-Target=RedshiftData.ListStatements

ListStatements

POST/#X-Amz-Target=RedshiftData.ListTables

ListTables

Documentation →

Authentication

No authentication required. This MCP server can be used without API keys.

Spec Version

Version: 2019-12-20

Spec version published with the OpenAPI document. Config auto-updates when the spec changes.

Page last updated: June 13, 2026

Quality Score

46/99Fair
  • +Auto-generated (+12)
  • +Has documentation (+12)
  • +OpenAPI spec available (+8)
  • +10 endpoints (+14)

Own this API?

Claim your listing to update description, links, and category — and get a verified badge.

Claim this listing →

Similar APIs

Other APIs in the Cloud Infrastructure category.

Supabase API

Manage Supabase projects, databases, authentication, and storage through your AI agent.

API Key

Cloudflare API

Manage Cloudflare DNS, CDN, Workers, and security settings through your AI agent.

API Key

Vercel API

Deploy projects, manage domains, and monitor deployments through your AI agent.

Bearer Token

DigitalOcean API

# Introduction The DigitalOcean API allows you to manage Droplets and resources within the DigitalOcean cloud in a simple, programmatic way using conventional HTTP requests. All of the functionality that you are familiar with in the DigitalOcean control panel is also available through the API, all