Home / estuary / agent-skills · skills/materialize-postgres-create/SKILL.md · GitHub

materialize-postgres-create skillA

materialize-postgres-create is agent-read markdown (skill) from estuary/agent-skills: Create a PostgreSQL materialization to stream Estuary collections into PostgreSQL tables. Use when setting up PostgreSQL as a destination for captured data. Use when user says "send to Postgres", "materialize to PostgreSQL", "Postgres destination", or "load into Postgres"..

Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.

What the file says

# Create PostgreSQL Materialization

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

**Applies to**: materialize-postgres (all variants: vanilla, RDS, Aurora, Cloud SQL, Supabase, AlloyDB, Neon)

## 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/PostgreSQL/

Use WebFetch to load this page. It covers:

- Prerequisites (user creation, permissions, schema setup)
- Full config property reference
- SSH tunnel configuration
- SSL configuration
- Advanced options (delta updates, hard deletes, sync schedule)

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

```
Search kapa ai knowledge sources for "materialize postgres 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
…

Read the whole file at its exact version.

How to install

Latest version
mdr add estuary/agent-skills/materialize-postgres-create@git:20260505.8873932
Exact content
mdr add estuary/agent-skills/materialize-postgres-create@sha256:1395af55e92e153f

Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.

Badge

mdr badge

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

1 badge views in 30 days

Versions

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

Audit of the latest version

A  17 of 17 checks passed. Deterministic, no model, 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 (7097 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-09-17 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_cwgvvhlmil5mqtq4
GET https://markdownregistry.com/api/v1/resolve?ref=estuary/agent-skills/materialize-postgres-create
GET https://markdownregistry.com/api/v1/blob/1395af55e92e153f215b784a8f7c2e6aba219214cffb22f9c647be6479e45ae4

Your agent 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.

More from estuary/agent-skills

capture-alpaca-create 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:20260616.babbd39 · audit A · 7 stars
capture-generic-create 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:20260505.8873932 · audit A · 7 stars
capture-http-ingest-create 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:20260505.8873932 · audit A · 7 stars
capture-hubspot-create 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:20260715.610f71c · audit A · 7 stars
capture-mongodb-create 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:20260505.8873932 · audit A · 7 stars
capture-mysql-create 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:20260505.8873932 · audit A · 7 stars
capture-postgres-create 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:20260505.8873932 · audit A · 7 stars
capture-sqlserver-create 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:20260505.8873932 · audit A · 7 stars
derivation-aggregate-metrics 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
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
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
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.