Redshift MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| RS_DB | Yes | Redshift database name | |
| RS_HOST | Yes | Redshift host endpoint (e.g., your-cluster.region.redshift.amazonaws.com) | |
| RS_PASS | Yes | Redshift user password | |
| RS_PORT | No | Redshift port (default: 5439) | 5439 |
| RS_USER | Yes | Redshift read-only user | |
| MAX_ROWS | No | Maximum number of rows returned by query_data and sample_data | 500 |
| SSH_HOST | No | SSH host for tunneling (required when SSH_TUNNEL=true) | |
| SSH_USER | No | SSH user for tunneling (required when SSH_TUNNEL=true) | |
| SSH_TUNNEL | No | Set to 'true' to use an SSH tunnel to connect to Redshift in a private VPC | false |
| SSH_KEY_FILE | No | Path to SSH private key file (required when SSH_TUNNEL=true) | |
| DEFAULT_SCHEMA | No | Default schema to use when none specified | |
| ALLOWED_SCHEMAS | No | Comma-separated list of schemas accessible to the MCP server | |
| MAX_EXPORT_ROWS | No | Maximum number of rows returned by export_to_csv | 5000 |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo issues