Amazon Redshift

https://aws.amazon.com/redshift

Needs Work

Agent Native Score

OpenAPI Spec

AWS's fully managed data warehouse service for analyzing large datasets using SQL queries and BI tools. It provides petabyte-scale analytics with columnar storage and MPP architecture.

Categories: Data Warehouse · Analytics · Database

#4 of 4 in Data Warehouse · #112 of 117 in Analytics · #68 of 69 in Database

Checklist Breakdown

9 of 33 checks passed. 14 unscored.

Discovery 63%

Can an agent find and understand this tool without a web search?

✓ Published OpenAPI/Swagger spec

✗ Has llms.txt or llms-full.txt

✗ Has an MCP server (official or well-maintained)

✗ MCP server listed in a public registry

✓ API reference docs are publicly accessible

✓ Docs include runnable code examples

✓ Has a public changelog or release notes

✓ Has a public status page

Auth & Onboarding 17%

Can an agent create an account and get credentials without human intervention?

✗ Signup does not require CAPTCHA

✗ Signup does not require phone verification

✗ Supports API key auth (not only OAuth)

✗ API key obtainable without manual approval

✗ No mandatory billing info to start

✓ Can sign up without creating an organization

Pricing 60%

Can an agent operate autonomously without upfront payment or contracts?

✗ Has a free tier

✓ Usage-based pricing available

✓ No minimum contract or commitment

✓ Pricing page is public (no 'contact sales')

✗ Free tier sufficient for testing (not just a trial)

Agent Tooling Not yet scored

How well does the API work for non-human consumers?

— SDK available in 2+ languages

— Structured error responses (JSON with error codes)

— Idempotency support on write endpoints

— Pagination on list endpoints

— Webhook/event support

— Sandbox or test mode available

— Rate limit headers in responses

— Consistent REST resource naming

Reliability Not yet scored

Does the tool fail gracefully when an agent makes a mistake?

— Meaningful error messages (not just 500)

— 429 responses include Retry-After header

— Documented uptime SLA (99.9%+)

— Graceful degradation under rate limits

— Request IDs in responses for debugging

— API versioning supported

Reviewer Notes

Redshift has good AWS documentation and OpenAPI specs via boto3, making discovery reasonable, but lacks a dedicated MCP server. Account creation requires AWS account setup with identity verification and payment method, preventing autonomous agent signup. Agent tooling is solid through boto3 SDK with structured responses, and AWS infrastructure provides high reliability. The main weakness is pricing—clusters require minimum committed resources and upfront costs, making autonomous operation expensive without human budget oversight. Best suited for enterprise agents with pre-authorized AWS access.

Amazon Redshift

Let your agents find tools like Amazon Redshift