Amazon Redshift MCP
Run SQL queries and manage data in Amazon Redshift data warehouses using the Redshift Data API.
Overview
| Catalog ID | mcp-redshift |
| Category | database |
| Auth method | API key |
| Blast radius | moderate |
| Trust | Verified — published by cendriix |
| Version | 1.0.0 |
| Regions | us-east-1, eu-west-1 |
Tools
| Tool | Description |
|---|---|
run_query | Execute a SQL query against Redshift. |
list_schemas | List schemas in the database. |
describe_table | Get the schema of a table. |
copy_from_s3 | Load data from S3 into a table. |
get_query_status | Check status of a running query. |
Tool parameters
run_query
Execute a SQL query against Redshift.
| Parameter | Type | Description | |
|---|---|---|---|
query | string | required | SQL query |
database | string | optional | Database name |
describe_table
Get the schema of a table.
| Parameter | Type | Description | |
|---|---|---|---|
table_name | string | required | Table name |
schema | string | optional | Schema name |
copy_from_s3
Load data from S3 into a table.
| Parameter | Type | Description | |
|---|---|---|---|
table_name | string | required | Target table |
s3_path | string | required | S3 URI (s3://…) |
iam_role | string | required | IAM role ARN |
format | string | optional | Data format |
get_query_status
Check status of a running query.
| Parameter | Type | Description | |
|---|---|---|---|
query_id | string | required | Query execution ID |
Installing
- In Cendriix, go to Settings → MCPs
- Find Amazon Redshift and click Install
- Paste your API key after installing. It is validated, then encrypted at rest in a secrets vault scoped to your tenant.
- Click Test Connection to run a health check and list available tools
Authentication. Paste your API key after installing. It is validated, then encrypted at rest in a secrets vault scoped to your tenant.
Blast radius
This MCP is classified moderate. This MCP can create and update records in the connected service, but cannot delete infrastructure.
Every tool invocation is recorded in your Audit Log. You can remove this MCP at any time from Settings → MCPs, which revokes tool access immediately.
Further reading
- MCP Marketplace — browse and install MCPs
- Policies & Guardrails — approval gates and blast radius
- Audit Log — review tool invocations
Last updated on