redshift-mcp-server
by amitds1997·★ 1·Score 28
A simple MCP server for executing SQL queries on Amazon Redshift clusters with username/password authentication.
Overview
This is a specialized MCP server that enables connection to Amazon Redshift databases through the Model Context Protocol. It focuses on providing SQL query capabilities while maintaining security by suggesting read-only user configurations. The server has been tested with outputs up to 100+ rows and uses uv as the runtime environment for deployment.
Try asking AI
After installing, here are 5 things you can ask your AI assistant:
When to choose this
Choose this when you need AI to query Redshift data and prefer using username/password authentication instead of more complex authentication methods.
When NOT to choose this
Avoid this if you need write access to Redshift or if you're using a different authentication method like IAM roles.
Comparable tools
Installation
Installation
- Clone the repository to your local machine
- Install uv following the [official guide](https://docs.astral.sh/uv/getting-started/installation/)
- Configure your MCP client with the following settings:
{
"command": "uv",
"args": [
"--directory",
"<path_to_redshift_mcp>",
"run",
"server.py"
],
"env": {
"REDSHIFT_DB": "<db-name>",
"REDSHIFT_USER": "<redshift_user>",
"REDSHIFT_PASSWORD": "<redshift_password>",
"REDSHIFT_HOST": "<redshift-host-uri>",
"REDSHIFT_PORT": "5439"
}
}FAQ
- What is the maximum output size this server can handle?
- The server has been tested with outputs up to 100+ rows. For larger outputs, performance may vary depending on the total size of the output.
- Is it safe to use a regular user account with this server?
- While the server includes validations to prevent DDL statement execution, it's recommended to use a read-only user for connecting to the Redshift cluster as a security best practice.
Compare redshift-mcp-server with
Last updated · Auto-generated from public README + GitHub signals.