Amazon Redshift Agent
Query, optimize, and monitor your Redshift data warehouse through natural language.
What it does
The Redshift specialized agent gives every team member direct access to your data warehouse without writing SQL. Ask questions about schemas, query performance, storage utilization, and cost patterns. The agent understands Redshift-specific optimizations — sort keys, distribution styles, WLM queues — and translates business questions into efficient queries automatically.
Why a supervised agent — not a raw connector?
Key Capabilities
How It Works
Connect
Provide your Redshift cluster endpoint and credentials. The agent catalogs your schemas, tables, and views.
Configure
Define access policies, set cost thresholds, and specify which schemas are queryable.
Ask
Users ask questions in plain English from the Personal Assistant. The agent generates and runs optimized SQL.
Improve
The agent learns your data model, common queries, and naming conventions to deliver better results over time.
Use Cases
Business analysts querying warehouse data without SQL expertise
Data teams monitoring query performance and identifying slow queries
Finance tracking Redshift compute costs and optimizing spend
Engineering teams exploring schema changes and impact analysis
Invoked from your Personal AI Assistant
Users never interact with this agent directly. They ask a question through their Personal AI Assistant, and xpander routes it to the Amazon Redshift agent automatically. The specialized agent handles execution within its constrained surface — validated, auditable, and isolated from every other system. One question in, structured answer out.