# Amazon Redshift

**Canonical:** https://apis.io/providers/amazon-redshift/  
**APIs profiled:** 5

Amazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.

## Kin Score — 48.4 / 100 (developing)

Scored 2026-08-20 under rubric 0.12.0. Trend: flat (+0.0 from 48.4).

| Facet | Score |
|---|---|
| Discoverability | 64.8 |
| Contract Quality | 64.3 |
| Governance | 9.8 |
| Contract Governance | 9.8 |
| Operational Transparency | 23.7 |
| Developer Ergonomics | 52.4 |
| Commercial Clarity | 55.3 |
| Access Clarity | 55.3 |

## Agent readiness — 35.9 (agent-ready)

| Dimension | Value |
|---|---|
| Spec Presence | yes |
| Agentic Access | derived |
| Reversibility Documented | no |
| MCP Server | no |
| Auth Clarity | yes |
| Idempotency | no |
| Error Semantics | verified |
| OpenAPI Examples | no |
| Rate Limit Signal | documented |
| Event Surface Described | no |
| Agent Skills | no |
| Well Known Catalog | no |
| Consent Identity | no |
| Agent Card | no |
| Dry Run Mode | no |

## Access

Paid (free trial) · Self-serve signup — onboarding: self-serve, pricing: paid, trial: yes (confidence: high).

## APIs (5)

- **Amazon Redshift Serverless API** — The Amazon Redshift Serverless API for managing serverless data warehouse workgroups, namespaces, and capacity without provisioning clusters.
- **Amazon Redshift Metadata API** — List databases, schemas, and tables in a Redshift data warehouse
- **Amazon Redshift Result Retrieval API** — Retrieve results from completed SQL statement executions
- **Amazon Redshift Statement Execution API** — Execute SQL statements against Amazon Redshift clusters or serverless workgroups
- **Amazon Redshift Statement Management API** — Describe, list, and cancel SQL statement executions

## Agentic access (1)

- **Amazon Redshift Agentic Access** — 10 operations · 10 acting

## Security (4)

- **Amazon Redshift Authentication** — apiKey · 1 scheme
- **Amazon Redshift Domain Security** — TLSv1.3 · HSTS · DMARC
- **Amazon Redshift Vulnerability Disclosure** — security.txt · contact published
- **Amazon Redshift Trust Center** — PCI DSS, HIPAA, FedRAMP, GDPR, FIPS 140

## Plans (1)

- **Amazon Redshift Plans Pricing**

## Use cases (5)

- **Business Intelligence Analytics** — Run complex analytical queries across petabytes of structured data for BI dashboards and reporting.
- **Data Lake Analytics** — Query data directly in Amazon S3 using Redshift Spectrum without loading it into the warehouse.
- **Real-Time Analytics** — Ingest streaming data and run near-real-time analytics on operational data for instant insights.
- **ETL Pipeline Processing** — Transform and load large datasets using SQL-based ETL operations within the data warehouse.
- **Serverless Ad-Hoc Queries** — Run on-demand analytical queries without provisioning clusters using Redshift Serverless and Data API.

## Tags

Analytics, Big Data, Cloud, Data Lake, Data Warehouse, ETL, Machine-Learning, Serverless, SQL

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/providers/amazon-redshift/). Scores are computed from the provider's own public artifacts under a published rubric.
