Skills
.Work. You
Rest

expanso-s3-to-postgres

Official

Load S3 JSON to PostgreSQL

Data & Analytics#aws#json#etl#s3#data loading#postgres
Authorexpanso-io
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill automates the process of loading JSON files from Amazon S3 into a PostgreSQL database, including handling schema mapping and data upserts.

Core Features & Use Cases

  • Automated Data Ingestion: Reads JSON files from a specified S3 bucket and prefix.
  • Schema Mapping & Transformation: Parses JSON lines and maps them to PostgreSQL columns, including generating UUIDs and adding metadata.
  • Upsert Support: Supports loading data into a PostgreSQL table with options for batching.
  • Use Case: Streamline ETL processes by automatically ingesting and updating records from S3-based JSON data into your PostgreSQL data warehouse.

Quick Start

Configure your AWS and PostgreSQL credentials and run the skill to load data from your S3 bucket into PostgreSQL.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: expanso-s3-to-postgres
Download link: https://github.com/expanso-io/expanso-skills/archive/main.zip#expanso-s3-to-postgres

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.