# Expanso S3 To Postgres

> Load JSON files from S3 into PostgreSQL with upsert support

- Skill: `expanso-io/expanso-s3-to-postgres-2` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add expanso-io/expanso-s3-to-postgres-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/expanso-io/expanso-s3-to-postgres-2/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: expanso-io (https://skillmd.com/u/expanso-io)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/expanso-io/expanso-s3-to-postgres-2

---


# S3 to PostgreSQL

Load JSON files from S3 into PostgreSQL with automatic schema mapping, upserts, and batching.

## Category

`data-routing`

## Quick Start

```bash
export AWS_ACCESS_KEY_ID=your-key
export AWS_SECRET_ACCESS_KEY=your-secret
export S3_BUCKET=your-bucket
export POSTGRES_DSN=postgres://user:pass@localhost:5432/db
./run.sh
```