Redshift Data API Service MCP Server
The Amazon Redshift Data API Service is a managed, serverless endpoint provided by Amazon Web Services (AWS) that enables programmatic execution of SQL commands against Amazon Redshift data warehouses.
Quick Start Summary
The Redshift Data API Service MCP server is a Model Context Protocol bridge that connects AI assistants — including Claude Desktop, Cursor, Windsurf, and VS Code Copilot — to the Redshift Data API Service API through natural language. It exposes 10 API endpoints as callable tools, such as BatchExecuteStatement, CancelStatement, DescribeStatement, and more. No authentication is required — setup takes approximately 30 seconds. The server uses STDIO transport and can be installed by running npx -y @mcp/amazonaws-com-redshift-data. This integration is sourced from the auto Redshift Data API Service OpenAPI specification (v2019-12-20) and has a quality score of 46/99 (fair documentation coverage).
Server Details
- Category
- Cloud Infrastructure
- Authentication
- None
- Endpoints
- 10 operations
- Transport
- STDIO
- Spec Version
- v2019-12-20
- Install Command
npx -y @mcp/amazonaws-com-redshift-data
Environment Variables
REDSHIFT_DATA_API_SERVICE_API_KEYExample: your_redshift_data_api_service_api_key
Top Endpoints
/#X-Amz-Target=RedshiftData.BatchExecuteStatementBatchExecuteStatement
/#X-Amz-Target=RedshiftData.CancelStatementCancelStatement
/#X-Amz-Target=RedshiftData.DescribeStatementDescribeStatement
/#X-Amz-Target=RedshiftData.DescribeTableDescribeTable
/#X-Amz-Target=RedshiftData.ExecuteStatementExecuteStatement
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"
}
}
}
}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.
VS Code
Use with MCP extension
{
"mcpServers": {
"amazonaws-com-redshift-data": {
"url": "https://mcpbridge.org/config/amazonaws-com-redshift-data.json"
}
}
}Endpoints Explorer
Search and browse the 10 operations supported by this server.
Multi-Language Code Examples
Executable code snippets for calling Redshift Data API Service endpoints in curl, TypeScript, or Python.
curl -X POST "https://api.apis.guru/v2/specs/amazonaws.com/redshift-data/2019-12-20/#X-Amz-Target=RedshiftData.BatchExecuteStatement" \ -H "Content-Type: application/json" \ # No auth required
Manual Configuration
Directly add this block to your JSON config file, or use the hosted config registry URL.
{
"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"
}
}
}
}Authentication Details
No authentication required. This MCP server runs out-of-the-box.
Documentation Links
Error Handling & HTTP Status Code Matrix
Common status codes, error causes, and resolution steps when invoking Redshift Data API Service endpoints.
400 Bad RequestCause: Malformed payload parameters or missing required fields.
Resolution: Verify request schema in Endpoints tab before calling tool.
401 UnauthorizedCause: Missing or invalid API key credentials.
Resolution: Set environment variable in MCP client config under env object.
403 ForbiddenCause: Insufficient scope permissions for requested resource.
Resolution: Verify key permissions in developer dashboard.
404 Not FoundCause: Resource URL path or requested entity ID does not exist.
Resolution: Check path variables and parameters.
429 Rate Limit ExceededCause: API rate limit quota exceeded.
Resolution: Implement exponential backoff retry in tool call.
500 Internal ErrorCause: Upstream server runtime fault.
Resolution: Inspect STDIO stderr output for log trace.
Quality Score
Checked against our protocol-compliance rules.
Specification Version: v2019-12-20
Page compiled on: June 13, 2026
Own this API?
Verify ownership of this listing to control the description, configuration details, and documentation links. Choose between free manual verification or instant premium placement.
Option 1: Free Verification
Slow manual review. Requires creating a GitHub issue with verified documentation or domain verification.
- • Verified badge on page
- • Standard search sorting
- • 2-3 business days review
Option 2: Featured Upgrade($9/mo)
Instant verification plus premium styling, featured badges, and directory placement boost.
- • ★ Featured star & amber highlight border
- • Top of directory search placement
- • Instant activation via claim token
📖 Detailed MCP Integration Guide
A technical breakdown of capabilities, agent workflows, and security/configuration best practices.
redshift-data:ExecuteStatement, redshift-data:DescribeStatement, and related permissions. The principle of least privilege is paramount: grant only the specific permissions needed (e.g., redshift-data:GetStatementResult but not redshift-data:BatchExecuteStatement if only querying). The MCP server implementation should securely manage and rotate AWS credentials, never exposing them in logs or error messages. Developers should also configure appropriate network security, ensuring the Redshift cluster is accessible only from trusted endpoints, and consider using the --secret or --credential-file options in the MCP server setup to handle sensitive configuration outside of environment variables. Regularly auditing statement history via ListStatements and implementing query timeouts are additional best practices to prevent unintended data exposure or runaway resource consumption.Similar APIs
Other APIs in the Cloud Infrastructure category.
Supabase API
Manage Supabase projects, databases, authentication, and storage through your AI agent.
API KeyCloudflare API
Manage Cloudflare DNS, CDN, Workers, and security settings through your AI agent.
API KeyVercel API
Deploy projects, manage domains, and monitor deployments through your AI agent.
Bearer TokenDigitalOcean API
The DigitalOcean API is a comprehensive, RESTful interface provided by DigitalOcean, a leading cloud infrastructure provider focused on simplifying cloud computing for developers, startups, and enterprises. It serves as the programmatic backbone for managing the entire DigitalOcean ecosystem, enabling users to provision, configure, and control cloud resources such as Droplets (virtual private servers), Kubernetes clusters, managed databases, networks, storage volumes, and application platforms. Core capabilities include full lifecycle management of these resources, from creation and scaling to monitoring and deletion, mirroring the functionality available in the DigitalOcean control panel. Its primary use cases range from automating infrastructure setup for CI/CD pipelines and enabling infrastructure-as-code practices to supporting dynamic application scaling and resource optimization for SaaS products, e-commerce sites, and development environments. The API is designed for both developers seeking to automate their cloud operations and businesses that require programmable, scalable cloud infrastructure without the complexity of larger hyperscale providers.
Related MCP Server Integrations
Supabase API MCP Setup
Manage Supabase projects, databases, authentication, and storage through your AI agent.
Cloudflare API MCP Setup
Manage Cloudflare DNS, CDN, Workers, and security settings through your AI agent.
Vercel API MCP Setup
Deploy projects, manage domains, and monitor deployments through your AI agent.
DigitalOcean API MCP Setup
The DigitalOcean API is a comprehensive, RESTful interface provided by DigitalOcean, a leading cloud infrastructure provider focused on simplifying cloud computing for developers, startups, and enterprises. It serves as the programmatic backbone for managing the entire DigitalOcean ecosystem, enabling users to provision, configure, and control cloud resources such as Droplets (virtual private servers), Kubernetes clusters, managed databases, networks, storage volumes, and application platforms. Core capabilities include full lifecycle management of these resources, from creation and scaling to monitoring and deletion, mirroring the functionality available in the DigitalOcean control panel. Its primary use cases range from automating infrastructure setup for CI/CD pipelines and enabling infrastructure-as-code practices to supporting dynamic application scaling and resource optimization for SaaS products, e-commerce sites, and development environments. The API is designed for both developers seeking to automate their cloud operations and businesses that require programmable, scalable cloud infrastructure without the complexity of larger hyperscale providers.
Access Analyzer MCP Setup
The AWS Identity and Access Management Access Analyzer API provides a powerful, policy-as-code service that automatically identifies resources accessible from outside your AWS account or organization. At its core, the service continuously evaluates resource-based policies—such as Amazon S3 bucket policies, AWS Identity and Access Management (IAM) roles, Amazon KMS key policies, and AWS Lambda function policies—using logic-based reasoning to determine which resources grant access to unknown external principals. Its primary use case is for security and compliance teams within enterprises to proactively detect unintended data exposure, enforce least privilege principles, and audit cross-account and cross-service access. The API endpoints allow programmatic control to create, configure, and query analyzers, manage archive rules for storing findings, and generate custom policy documents, making it a foundational tool for automating cloud security posture management at scale.