Registry /
aws / awslabs-redshift-mcp-server
Install & Compatibility
Where this runs
tested against v0.0.24 · pip install
no network on importno background threads
Install × environment matrix
Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux
py 3.9
✕ build_error
✕ build_error
108MB installed
● package 108MB
Code
Verified usage
Verified import paths — ran on the pinned version, not inferred.
awslabs.redshift-mcp-server
✓ command: uvx awslabs.redshift-mcp-server@latest
The Redshift MCP server is typically run as a command-line application by an MCP client (e.g., Amazon Q, Claude Desktop, Cursor IDE), not imported as a Python library for direct function calls. This 'import' reflects how clients configure its execution.
To quickly start using the Redshift MCP server, configure your MCP client (e.g., in `~/.aws/amazonq/mcp.json` for Amazon Q CLI) with the above JSON block. Ensure your AWS credentials are configured (e.g., via `AWS_PROFILE` or `AWS_ACCESS_KEY_ID`/`AWS_SECRET_ACCESS_KEY` environment variables, or AWS CLI configuration). You must also specify the Redshift cluster identifier, database name, and an AWS region.
{
"mcpServers": {
"awslabs.redshift-mcp-server": {
"type": "stdio",
"command": "uvx",
"args": ["awslabs.redshift-mcp-server@latest"],
"env": {
"AWS_PROFILE": "my-redshift-profile",
"AWS_DEFAULT_REGION": "us-east-1",
"REDSHIFT_CLUSTER_IDENTIFIER": "my-redshift-cluster",
"REDSHIFT_DATABASE": "dev",
"FASTMCP_LOG_LEVEL": "INFO"
}
}
}
}
Debug
Known issues
gotchaThe Redshift MCP server primarily supports READ ONLY SQL query execution. Write operations (INSERT, UPDATE, DELETE) are not directly supported through the standard tools for safety and protection.fixPlan for read-only analytical workloads. For write operations, use traditional Redshift connection methods or other AWS services.
affects: All versions
gotchaBy default, all users interacting with the MCP server share a single Redshift identity. This makes it challenging to enforce fine-grained, per-user group-based access controls within Redshift, as everyone connects as the same database user.fixConsider advanced configurations like `REDSHIFT_DB_USER_AUTO_DERIVE` or custom wrapper servers to map individual IAM identities to Redshift database users and groups, if supported by the client and server version.
affects: All versions
gotchaIf a SQL query executed through the Redshift MCP server fails (e.g., due to syntax errors or non-existent tables), the underlying Redshift session can enter a persistent 'Transaction Aborted Error' state. Subsequent queries will also fail until the MCP connection is reset.fixEnsure SQL queries are valid and test them carefully. If an error occurs, restarting the MCP client or the session is often required to clear the aborted transaction state.
affects: Prior to fix(redshift-mcp-server): Handle transaction abort errors properly #1495
Upgrade
Version history
0.0.24latest on PyPI · released Jun 2, 2026
Audit
Dependencies
uvoptionalRecommended package manager for installation and running MCP servers.