AWS DATA SERVICES / AWS Labs
AWS Redshift MCP
Discover Redshift schemas and run bounded SQL with read-only execution as the default.
“MCP server for Amazon Redshift metadata discovery and SQL execution.”
01 / THE REASONING
Why this made the selection.
- Specialized publisher integration with documented IAM and data access boundaries.
- Combines provisioned/serverless discovery with transaction-backed read-only SQL and bounded result handling.
- The README discovers Redshift clusters and workgroups and runs SQL, with read-only as the startup default.
- It says the statement guard is not a security boundary and that database privileges are the durable control.
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- src/redshift-mcp-server/README.md
- src/redshift-mcp-server/pyproject.toml
- src/redshift-mcp-server/awslabs/redshift_mcp_server/server.py
- Root README.md and LICENSE
- LICENSE
Our findings
- The pinned entrypoint resolves access mode once at startup and refuses oversized results rather than silently truncating.
- Source and README describe read-only transaction wrapping, explicit write mode and confirmation failure when the client cannot prompt. These controls were inspected, not bypass-tested.
- The server discovers provisioned clusters and serverless workgroups and executes SQL. It is read-only unless ACCESS_MODE=read-write is selected at startup.
- The mode cannot change for the life of the process. redshift-serverless:GetWorkgroup and redshift:GetClusterCredentials are described as not needed.
- Single-statement checks do not make a write safe. The README says to treat that guard as defense in depth, not a security boundary, and to rely on the database user's privileges.
Not established by this review
- Server startup, authentication, live tool execution and security isolation were not tested.
- Published package/container parity with a source revision and hosted implementation internals were not tested.
- The server was not started and its tools were not called.
- A pin does not verify transitive dependencies.
- No tools/list or tool call was made.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Connect a server deliberately.
DOCUMENTED COMMAND
uvx awslabs.redshift-mcp-server@latest Copying does not execute this command. It may retrieve a newer version than the reviewed source.
- Configure a dedicated AWS profile and read-only database grants for the intended cluster or serverless workgroup.
- Grant the documented Redshift discovery and Data API actions, including BatchExecuteStatement for the current transaction-backed path.
- Launch in read-only mode, discover database/schema/table names, then use explicit columns, predicates and result limits.
Before you start
- Python 3.10 or newer, uv/uvx and an MCP client that can launch a local stdio process.
- An AWS account, configured credentials and access to the intended region and service resources.
Documented configuration example
Use the client and authentication context described in the setup guidance. Configuration formats vary between hosts.
{
"mcpServers": {
"awslabs-redshift": {
"command": "uvx",
"args": [
"awslabs.redshift-mcp-server@latest"
],
"env": {
"AWS_PROFILE": "redshift-reader",
"AWS_DEFAULT_REGION": "us-east-1",
"ACCESS_MODE": "read-only",
"UNSAFE_SKIP_WRITE_CONFIRMATION": "false",
"MAX_RESULT_ROWS": "1000",
"LOG_LEVEL": "WARNING"
}
}
}
} 04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/redshift-mcp-server/README.md
Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/redshift-mcp-server/pyproject.toml
Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/redshift-mcp-server/awslabs/redshift_mcp_server/server.py
Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/README.md
Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports
- Applicable licence ↗Checked
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE
Supports: license