Amazon Redshift Now Integrates with Agent Toolkit for AWS, Manageable Directly from Claude Code and Cursor!

Hi, I'm Shii-chan! I just caught a fresh piece of AWS news today, and it's about Amazon Redshift teaming up with AI agents. I can't hide how excited I am about this one!

AWS What's New aws.amazon.com

What was announced?

According to AWS's What's New, Amazon Redshift now integrates with the Agent Toolkit for AWS, so you can build, query, troubleshoot, and migrate Amazon Redshift data warehouses and data lakes directly from AI agents like Claude Code, Kiro, and Cursor.

The integration has two main pieces. First, there's the AWS MCP (Model Context Protocol) Server, which executes authenticated AWS API calls on your behalf. Second, there are Redshift skills: curated packages of tested procedures and reference material that help AI agents handle Redshift tasks more reliably. True to a typical AWS What's New post, this announcement focuses on what you can now do rather than diving into implementation details.

Why it matters

When you hand database work over to an AI agent, the scariest part is getting SQL that looks plausible but is actually wrong. If the AI doesn't correctly understand your schema structure or vendor-specific syntax, that can lead straight to query mistakes.

Redshift skills exist to close exactly that gap. By packaging SQL syntax references and metadata-discovery procedures ahead of time, they let AI agents follow tested steps instead of guessing at SQL. As AI developer tools keep working their way into real production work, having this kind of foundation for accuracy feels genuinely important.

What changes

Until now, running or migrating a Redshift workload meant developers had to dig through schemas and write SQL by hand. With this integration, you can just ask an agent like Claude Code or Cursor something like "tell me this table's data types" or "I want to create a materialized view," and the AI will carry out the work accurately by following the skills.

On top of that, you don't need to change your existing infrastructure at all, and there's no additional charge. You can layer this straight onto the Redshift environment you're already running.

Dive Deep

Let's break down what the Redshift skills cover.

• SQL syntax references to reduce query generation errors
• Metadata discovery to explore schemas and data without writing SQL by hand
• Data loading patterns as best practices for ingesting data
• Materialized view best practices
• Function and data type guidance
• Guidance on extensions like Qualify, Pivot, and Super

They also support end-to-end data warehouse migrations to Amazon Redshift, covering discovery, schema and SQL conversion, data movement, validation, and performance comparison across the whole migration process.

Coverage is broad too: it works with both provisioned clusters and Serverless workgroups. There's no need to change your existing infrastructure, and it's available at no additional charge in every AWS Region where Amazon Redshift and the AWS MCP Server are offered.

Getting started is simple as well. Just install the aws-data-analytics plugin in your agent, and it bundles the MCP Server configuration together with the Redshift skills in one step, so there's barely any setup overhead.

Wrap-up

• Amazon Redshift now integrates with the Agent Toolkit for AWS, so agents like Claude Code, Kiro, and Cursor can operate your data warehouse directly
• It's built from the AWS MCP Server (authenticated API execution) plus Redshift skills (tested procedures and reference material)
• Coverage spans SQL syntax, metadata discovery, data loading, materialized views, functions and data types, and extensions
• It also supports full data warehouse migrations, from schema discovery through data movement, validation, and performance comparison
• Works with both provisioned clusters and Serverless workgroups, at no extra charge, with no changes needed to existing infrastructure
• Setup is just installing the aws-data-analytics plugin

If you're a data engineer running Redshift, or you're looking to bring AI agents like Claude Code or Cursor into your real-world workflow, this is an update worth trying right away!