AI agent for Amazon Redshift
Connect Amazon Redshift to your AI agent through the WorkAist MCP server.
The WorkAist Amazon Redshift connector is a production-grade Model Context Protocol (MCP) server. AI agents can read and write Amazon Redshift data — databases — through one consistent interface. Open-source under AGPL-3.0, self-hosted, with reversible PII redaction at the LLM boundary.
Authentication & setup
The Amazon Redshift connector authenticates via HTTP Basic auth.
For self-hosted or legacy services. Use an app password when the provider supports them.
Frequently paired with Amazon Redshift
FAQ
Can a WorkAist AI agent really automate Amazon Redshift end-to-end?▼
Yes. The connector exposes read and write tools through Model Context Protocol. AI agents call them through plain-language instructions in a CLAUDE.md file — no glue code.
How does this differ from using the Amazon Redshift API directly?▼
The connector adds permission isolation, audit logging, cost tracking per agent, and reversible PII redaction at the LLM boundary. It also presents Amazon Redshift as part of a unified Knowledge Graph alongside your other tools.
What does it cost?▼
WorkAist is open-source under AGPL-3.0 and self-hosted, so the connector itself is free. You pay only for Amazon Redshift's own API costs (if any) and the LLM tokens your agent consumes.
Is my Amazon Redshift data sent to a third party?▼
No. WorkAist runs in your own infrastructure. Data flows from Amazon Redshift → your WorkAist instance → the LLM you choose. Sensitive fields can be tokenized before reaching the LLM.
What if Amazon Redshift changes its API?▼
The connector is versioned and published openly. When Amazon Redshift ships breaking changes, we bump the connector version and the marketplace UI surfaces the upgrade as a one-click apply.