Accelerating SQL analytics with Amazon Redshift MCP server

As information analysts and engineers, we frequently discover ourselves switching between a number of instruments to discover database schemas, perceive desk constructions, and execute queries throughout totally different Amazon Redshift information warehouses. Utilizing pure language to discover metadata and information can simplify this course of, however an AI agent usually wants the extra context of your Redshift cluster configurations and schemas to efficiently uncover and construct the perfect execution path.

That is the place the Mannequin Context Protocol (MCP) can act as a bridge between the AI agent and your Redshift clusters to supply the required data to raised assist pure language interfaces to your information. MCP is an open customary that permits AI purposes to securely connect with exterior information sources and instruments, offering them with wealthy, real-time context about your particular atmosphere. In contrast to static instruments, MCP permits AI brokers to dynamically uncover database constructions, perceive desk relationships, and execute queries with full consciousness of your Amazon Redshift setup.

To handle these challenges and unlock the total potential of conversational information evaluation, Amazon Internet Providers (AWS) launched the Amazon Redshift MCP server, an open supply answer that innovates the way you work together with Amazon Redshift information warehouses. The Amazon Redshift MCP server integrates seamlessly with Amazon Q Developer command line interface (CLI), Claude Desktop, Kiro, and different MCP-compatible instruments. It could possibly allow uncover, discover, and analyze your Amazon Redshift metadata and information via pure language conversations with an AI assistant that actually understands your database atmosphere.

On this publish, we stroll via establishing the Amazon Redshift MCP server and display how an information analyst can effectively discover Redshift information warehouses and carry out information evaluation utilizing pure language queries.

What’s the Amazon Redshift MCP Server?

The Amazon Redshift MCP server is a MCP implementation that gives AI brokers with protected, structured entry to Amazon Redshift assets. It allows:

• Cluster discovery – Mechanically uncover each provisioned Redshift clusters and serverless workgroups
• Metadata exploration – Browse databases, schemas, tables, and columns via pure language
• Protected question execution – Execute SQL queries in READ ONLY mode with built-in security protections
• Multi-cluster assist – Work with a number of clusters and workgroups concurrently for information reconciliation duties

The MCP server acts as a bridge between Amazon Q CLI and your Amazon Redshift infrastructure, translating pure language requests into acceptable API calls and SQL queries. The next diagram illustrates the high-level structure.

The next video demonstrates the answer outlined on this publish.

Conditions

Earlier than you start, guarantee you’ve got the next:

System necessities

• Python 3.10 or newer
• uv bundle supervisor (set up information)
• Amazon Q CLI or different instruments akin to Claude Desktop put in and configured

AWS necessities

Required IAM permissions

The person id wants the next IAM permissions in your entry insurance policies:

{   "Model": "2012-10-17",   "Assertion": [     {       "Effect": "Allow",       "Action": [         "redshift:DescribeClusters",         "redshift-serverless:ListWorkgroups",         "redshift-serverless:GetWorkgroup",         "redshift-data:ExecuteStatement",         "redshift-data:BatchExecuteStatement",         "redshift-data:DescribeStatement",         "redshift-data:GetStatementResult"       ],       "Useful resource": "*"     }   ] }

Set up and configuration

The next part covers the steps required to put in and configure Amazon Redshift MCP server.

Set up required dependencies

Full the next steps to put in required dependencies:

1. Set up the uv bundle supervisor for those who haven’t already:

# macOS/Linux curl -LsSf https://astral.sh/uv/set up.sh | sh # Home windows powershell -c "irm https://astral.sh/uv/set up.ps1 | iex"

2. Set up Python 3.10 or newer:

uv python set up 3.10

Configure the MCP server

The MCP server will be configured utilizing a number of MCP supported purchasers. On this publish we talk about the steps utilizing Amazon Q Developer CLI and Claude Desktop.Full the next directions to arrange Amazon Q Developer CLI in your host machine and entry the Amazon Redshift MCP Server:

1. Set up the Amazon Q Developer CLI.
2. Configure the Amazon Redshift MCP server in your Amazon Q CLI configuration. Edit the MCP configuration file at ~/.aws/amazonq/mcp.json:

{   "mcpServers": {     "awslabs.redshift-mcp-server": {       "command": "uvx",       "args": ["awslabs.redshift-mcp-server@latest"],       "env": {         "AWS_PROFILE": "default",         "AWS_REGION": "us-east-1",         "FASTMCP_LOG_LEVEL": "INFO"       },       "disabled": false,       "autoApprove": []     }   } }

For additional particulars on set up, discuss with the Set up part within the Amazon Redshift MCP server README.md.

3. Begin Amazon Q CLI to confirm the MCP server is correctly configured:

It’s best to discover the Amazon Redshift MCP server initialize efficiently within the startup logs.To arrange Amazon Q Developer CLI in your host machine and entry the Amazon Redshift MCP Server utilizing Claude Desktop, full the next steps:

4. Obtain and set up Claude Desktop to your working system
5. Open Claude Desktop and within the backside left, select the gear icon to navigate to Settings
6. Select the Developer tab and configure your MCP server by including the identical configuration as step 3 within the Amazon Q CLI setup
7. Restart Claude Desktop to activate the MCP server connection
8. Take a look at the combination by beginning a brand new dialog and asking: Present me all accessible Redshift clusters

Use case: Buyer buy evaluation

Think about a sensible situation the place an information analyst must discover buyer buy information throughout a number of Redshift clusters. The next walkthrough demonstrates how the MCP server simplifies this workflow.As an information analyst at an ecommerce firm, you must:

1. Uncover accessible Redshift clusters
2. Discover the database construction to seek out buyer and gross sales information
3. Analyze buyer buy patterns
4. Generate insights for the enterprise crew

To perform these duties, you comply with these steps:

5. Ask Amazon Q to indicate you accessible Amazon Redshift assets:

Present me all accessible Redshift clusters

Amazon Q will use the MCP server to find your clusters and supply particulars akin to cluster identifiers and kinds (provisioned or serverless), present standing and availability, connection endpoints and configuration, and node varieties and capability data.

6. Discover the database construction to know your information group:

What databases and tables can be found within the analytics-cluster?

Amazon Q will use the MCP server to systematically discover the objects within the cluster:

7. Earlier than analyzing information, perceive the desk schemas:

Present me the construction of the purchasers and orders tables in analytics-cluster

Amazon Q will use the MCP server to will study the desk columns and supply detailed schema data.

8. Analyze buyer buy patterns utilizing pure language queries:

Analyze buyer buy sample from analytics cluster. Present me the highest 10 prospects by complete buy quantity and their shopping for frequency

Amazon Q will use the MCP server to run the suitable SQL queries and supply insights.

9. The MCP server helps analyzing information throughout a number of clusters:

Examine buyer acquisition prices between the analytics-cluster and marketing-cluster information.

Amazon Q will use the MCP server to run the suitable SQL queries evaluate the information throughout analytics-cluster and marketing-cluster.

Finest Practices

The MCP server comes outfitted with a number of important security protections designed to safeguard your information and system efficiency. The READ ONLY mode serves as a important safeguard in opposition to unintended information modifications, and we advocate enabling this characteristic when relevant to your use case. To additional improve safety, the server implements question validation mechanisms that scrutinize operations for potential dangerous impacts, with user-in-loop validation being beneficial for optimum security. For useful resource administration, the server enforces useful resource limits to stop performance-impacting runaway queries, once more benefiting from user-in-loop validation for finest outcomes. By way of accessibility, the MCP functionality maintains broad availability throughout all AWS Areas the place Amazon Redshift Information API is supported, with throttling limits aligned to present Amazon Redshift Information API service quotas to make sure constant efficiency and reliability.For finest outcomes, comply with these suggestions:

1. Begin with discovery – Start by exploring cluster and database construction and tables
2. Use pure language – Describe what you wish to analyze moderately than writing SQL immediately
3. Iterate step by step – Construct complicated analyses step-by-step
4. Confirm outcomes – Cross-check vital findings with enterprise stakeholders
5. Doc insights – Save vital queries and outcomes for future reference

Conclusion

The Amazon Redshift MCP server transforms how information analysts work together with Redshift clusters by enabling pure language information exploration and evaluation via agentic tooling like Kiro and Amazon Q CLI. By eliminating the necessity to manually write SQL queries and navigate complicated database constructions, analysts can deal with producing insights moderately than wrestling with syntax and schema discovery.Whether or not you’re performing a one-time evaluation, producing common studies, or exploring new datasets, the Amazon Redshift MCP server supplies a robust, intuitive interface to your information evaluation workflows.Able to get began? Right here’s what to do subsequent:

1. Set up the MCP server following the configuration steps on this publish
2. Discover your Amazon Redshift atmosphere utilizing pure language queries
3. Begin with easy analyses and step by step construct complexity
4. Share insights together with your crew utilizing the pure language summaries
5. Present suggestions to assist enhance the MCP server capabilities

Try these weblog posts that will help you navigate utilizing pure language together with your use instances:

In regards to the authors