Skip to main content
Native Redshift MCP setup in Sidecar is coming soon. Today, you can register a remote Redshift MCP endpoint through Sidecar’s custom connector. AWS Labs publishes an Amazon Redshift MCP Server that discovers provisioned clusters and serverless workgroups, explores metadata, and runs single-statement read-only queries.

Plan the deployment

The AWS Labs setup starts the server as a local stdio process. Sidecar cannot run that command. To use it with Agent Console, deploy it behind a service or bridge that provides:
  • An HTTPS MCP Streamable HTTP endpoint
  • A stable bearer token for Sidecar
  • Access to AWS through an IAM role or another AWS credential-provider-chain method
  • Network access to the Redshift Data API and any required private resources
The finished URL should look like https://redshift-mcp.example.com/mcp. It must meet Sidecar’s custom endpoint requirements.
Do not expose the local AWS Labs server directly to the internet and do not place long-lived AWS access keys in Sidecar’s Bearer token field. That field authenticates Sidecar to your MCP gateway, not the gateway to AWS.

Configure gateway network access

Sidecar’s registration and health checks reach your hosted MCP gateway from 44.236.246.98/32. Agent Console calls the same gateway from Anthropic’s infrastructure. Permit both sources at the gateway’s firewall and authentication layer. Use the current outbound addresses. The gateway connects onward to AWS and Redshift with its own workload identity and network. Allowing Anthropic at the gateway does not grant it direct access to your Redshift database. A successful local or Sidecar discovery check does not prove that the runtime can reach the gateway.

Configure AWS access

Attach a dedicated IAM role to the hosted MCP workload. The AWS Labs server documents these permissions as its starting point:
Scope the resources and conditions more narrowly for your environment where the AWS actions support it. In the workload, set the region explicitly—for example, AWS_REGION=us-east-1. Prefer an attached IAM role over static AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY values.

Configure database access

IAM permission to call the Redshift Data API does not grant access to data. Create a least-privilege database identity with USAGE on allowed schemas and SELECT on allowed tables and views. The Redshift warehouse integration guide includes SQL for a read-only sidecar_user, schema grants, future-table grants, and a grant-statement generator. Reuse it only when the MCP server should have the same access as Sidecar’s metadata integration. Avoid granting CREATEUSER solely for the AWS Labs review_cluster tool. The AWS Labs guide notes that this tool needs elevated system-view access. Omit or filter it at your hosted MCP layer when agents only need metadata discovery and read-only queries. If you cannot filter it, leave the elevated privileges ungranted so the tool cannot perform the review.

Validate the server before hosting

Use the official local configuration to confirm AWS and Redshift permissions before adding the HTTP bridge:
This configuration is for local validation only. The value you register in Sidecar must be the hosted Streamable HTTP URL, not this command.

Register the hosted endpoint

  1. In Sidecar, select Integrations → MCP Servers.
  2. Click Add MCP, then select Custom server.
  3. Enter values like these:
  1. Click Add server.
  2. Confirm that the server status is Connected and review the discovered tools.
Continue by granting the server to an agent and selecting it for jobs.

Verify Agent Console access

After granting the hosted server and enabling it for a job, start a new manual run. Ask the agent to use the Redshift MCP query tool for SELECT 1 and a SELECT from one permitted table with LIMIT 1. Supply the exact cluster or workgroup, database, schema, and table. Expand the MCP calls in the run transcript. Confirm successful query results from the intended database, and complete any required approval. An empty table can return zero rows successfully. See runtime verification.

Troubleshooting

Confirm that you registered the public or privately routable HTTPS /mcp endpoint. A local uvx command or localhost URL is not reachable from Sidecar. Check the gateway’s TLS certificate, firewall, and request timeout.
Confirm the agent grant and job selection, then start a new run. Check that the gateway permits Anthropic’s outbound requests and accepts the stored bearer credential. A Connected badge can retain an earlier Sidecar result. Send support the run URL, timestamp and time zone, and sanitized gateway error if initialization still fails.
Check the workload’s AWS region and IAM permissions for provisioned Redshift and Redshift Serverless discovery. Confirm that the attached IAM role is the identity the server is actually using.
Check the Data API credential actions and the Redshift database user’s USAGE and SELECT grants. Cluster discovery and database query access use separate permissions.