stream-jsonl-to-postgres
CommunityEfficiently import large gzipped JSONL files into Postgres with asyncpg COPY
Authorruskibeats
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenge of importing large gzipped JSONL files into Postgres databases efficiently, avoiding the need for full disk decompression or loading everything into memory.
Core Features & Use Cases
- Streamlined Import: Directly streams gzipped JSONL files into Postgres using asyncpg COPY.
- Batch Processing: Utilizes async batch processing to handle large data volumes without overloading memory.
- Use Case: Ideal for large-scale data imports like Open Food Facts exports, log files, or OpenStreetMap data without the overhead of pandas or intermediate file formats.
Quick Start
To import a gzipped JSONL file into a table named 'my_table', use the command: import_jsonl_to_postgres 'path_to_file.jsonl' 'my_table'
Dependency Matrix
Required Modules
asyncpg
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: stream-jsonl-to-postgres Download link: https://github.com/ruskibeats/t1d/archive/main.zip#stream-jsonl-to-postgres Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.