New Server: Amazon Redshift

[techy-sharmila]

Describe the feature

Add a new server to connect to Amazon Redshift to query.

Use Case

Chat assistants that requires to connect to multiple data stores including 3rd party data stores require a common approach to connect to them. Having a MCP server for the AWS data stores will help this integration.

Proposed Solution

Create a MCP server for Amazon Redshift similar to the one for Snowflake. Another thought would be to create a core server that would help with connecting to the data stores on AWS.

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

[gss2002]

I built one recently with the help of AI over the past few weeks written in Python that integrates with Bedrock to run queries is it ideal no. but serves the purpose

[krokoko]

Hi @techy-sharmila , thank you for this RFC. We were thinking about grouping some of these RFCs (like #112 ) into one RFC for an MCP server for RDBMS. Would this work for you ?

[tuanknguyen]

I created a Redshift MCP a while ago for my personal use case. Let me know if you think we can generalize to all RDBMS https://github.com/tuanknguyen/redshift-mcp-server cc @krokoko