materialize-redshift-create SKILL.md skillA

materialize-redshift-create from estuary/agent-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add estuary/agent-skills/materialize-redshift-create@git:20260505.8873932

Pins git:20260505.8873932 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
estuary/agent-skills
Path
skills/materialize-redshift-create/SKILL.md
Versions recorded
1
Latest version
git:20260505.8873932, committed May 5, 2026
Size
7,389 bytes
Repository stars
7
License
Apache-2.0

Create a Redshift materialization to stream Estuary collections into Amazon Redshift tables. Use when setting up Redshift as a destination for captured data. Use when user says "send to Redshift", "materialize to Redshift", "Redshift destination", or "load into Redshift".

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Create Redshift Materialization

Create a Redshift materialization using flowctl to stream data from Estuary collections into Amazon Redshift tables.

**Applies to**: materialize-redshift (Redshift Provisioned and Serverless)

## Step 0: Load Connector Documentation

Before proceeding, fetch the official connector docs for prerequisites, config reference, and setup instructions.

**Load the docs page:**
https://docs.estuary.dev/reference/Connectors/materialization-connectors/amazon-redshift/

Use WebFetch to load this page. It covers:

- Prerequisites (Redshift cluster, S3 bucket, IAM credentials)
- Full config property reference
- SSH tunnel configuration
- Network access and IP allowlisting

**Search Kapa for tribal knowledge** (if the Estuary MCP is configured):

```
Search kapa ai knowledge sources for "materialize redshift common issues"
```

If Kapa MCP is not configured, the user can set it up: https://docs.estuary.dev/features/mcp-integration/

This skill provides the **flowctl workflow** and **troubleshooting** that docs don't cover.

## Step 1: Gather Requirements

Before writing any YAML, ask the user:
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add estuary/agent-skills/materialize-redshift-create@sha256:b7161babfbd00338

The line at the top of this page pins the label git:20260505.8873932, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_xepkyxeqim2bp3ig.svg)](https://markdownregistry.com/a/art_xepkyxeqim2bp3ig)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on May 5, 2026.

versioncommittedcommitsizeaudit
git:20260505.8873932 latest2026-05-05 8873932 7,389 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (7389 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

estuary/agent-skills · 7 stars · license Apache-2.0 · pushed 2026-11-04 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_xepkyxeqim2bp3ig
GET https://markdownregistry.com/api/v1/resolve?ref=estuary/agent-skills/materialize-redshift-create
GET https://markdownregistry.com/api/v1/blob/b7161babfbd00338f5044cab68a619ab368dc0786a05fdfc27b16a64c8511d58

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from estuary/agent-skills

capture-alpaca-create SKILL.md skill
estuary/agent-skills · skills/capture-alpaca-create/SKILL.md · Create an Alpaca capture using flowctl to stream stock trade data into Estuary collections. Use when setting up an…
git:20260924.c6e4810 · audit A · 7 stars
capture-generic-create SKILL.md skill
estuary/agent-skills · skills/capture-generic-create/SKILL.md · Create a capture for ANY Estuary connector using dynamic schema discovery. Use when the user wants to capture from a…
git:20260924.c6e4810 · audit A · 7 stars
capture-http-ingest-create SKILL.md skill
estuary/agent-skills · skills/capture-http-ingest-create/SKILL.md · Create an HTTP Ingest (webhook) capture to receive data via HTTP POST requests. Use when setting up webhooks from…
git:20260924.c6e4810 · audit A · 7 stars
capture-hubspot-create SKILL.md skill
estuary/agent-skills · skills/capture-hubspot-create/SKILL.md · Create a HubSpot Real-Time capture using flowctl to stream CRM data into Estuary collections. Use when setting up a…
git:20260924.c6e4810 · audit A · 7 stars
capture-mongodb-create SKILL.md skill
estuary/agent-skills · skills/capture-mongodb-create/SKILL.md · Create a MongoDB CDC capture using flowctl. Use when setting up real-time streaming from MongoDB Atlas, DocumentDB, or…
git:20260924.c6e4810 · audit A · 7 stars
capture-mysql-create SKILL.md skill
estuary/agent-skills · skills/capture-mysql-create/SKILL.md · Create a MySQL CDC capture using flowctl with binlog replication. Use when setting up streaming from MySQL, Amazon RDS…
git:20260924.c6e4810 · audit A · 7 stars
capture-postgres-create SKILL.md skill
estuary/agent-skills · skills/capture-postgres-create/SKILL.md · Create a new PostgreSQL CDC capture from scratch using flowctl. Covers all Postgres variants (vanilla, Aurora, RDS…
git:20260924.c6e4810 · audit A · 7 stars
capture-sqlserver-create SKILL.md skill
estuary/agent-skills · skills/capture-sqlserver-create/SKILL.md · Create a SQL Server CDC capture using flowctl. Use when setting up real-time streaming from SQL Server, Azure SQL…
git:20260924.c6e4810 · audit A · 7 stars
derivation-aggregate-metrics SKILL.md skill
estuary/agent-skills · skills/derivation-aggregate-metrics/SKILL.md · Create an Estuary derivation that continuously aggregates metrics (daily totals, running counts, min/max, lifetime…
git:20260707.6b608bf · audit A · 7 stars
derivation-basics SKILL.md skill
estuary/agent-skills · skills/derivation-basics/SKILL.md · Foundation for writing Estuary derivations — what they are, language choice (SQL/TypeScript/Python), project layout…
git:20260707.6b608bf · audit A · 7 stars
derivation-filter-transform SKILL.md skill
estuary/agent-skills · skills/derivation-filter-transform/SKILL.md · Create an Estuary derivation for stateless filtering, field selection, and per-document field transformation. Use for…
git:20260707.6b608bf · audit A · 7 stars
derivation-flatten-array SKILL.md skill
estuary/agent-skills · skills/derivation-flatten-array/SKILL.md · Create an Estuary derivation that flattens a nested array into one output document per array element. Use for…
git:20260707.6b608bf · audit A · 7 stars

Every file in estuary/agent-skills

Browse by kind, by grade A, or by owner.