{"repo":"vahid110/sqlxport","free":true,"listed":false,"github":"https://github.com/vahid110/sqlxport","clone":"git clone https://github.com/vahid110/sqlxport.git","description":"sql2parquet: A modern CLI tool to export SQL query results from PostgreSQL or Amazon Redshift directly to Parquet files, with optional upload to S3 or MinIO.","language":"Python","stars":15,"topics":["athe","aws","csv","data-export","delta-lake","duckdb","minio","parquet","redshift","s3"],"license":"MIT","category":"databases-storage","readme_excerpt":"sqlxport Modular CLI + API tool to extract data from PostgreSQL, Redshift, SQLite (and more), exporting to formats like Parquet/CSV, with optional S3 upload and Athena integration. --- ✅ Features 🔄 Run custom SQL queries against PostgreSQL, Redshift, SQLite 📦 Export to Parquet or CSV ( --format ) 🩣 Upload results to S3 or MinIO 🔄 Redshift UNLOAD support ( --export-mode redshift-unload ) 🧹 Partition output by column 📜 Generate Athena CREATE TABLE DDL 🔍 Preview local or remote Parquet/CSV files ⚙️ .env support for convenient config 🐍 Reusable Python API --- ❓ Why SQLxport? SQLxport simplifies data export workflows and is designed for automation: ✅ One command gives you SQL → Parquet/CSV → S3 🧱 Works locally, in CI, or inside Docker 🪢 Connects to Athena, MinIO, Redshift easily 🔌 Clean format and database plugin model 🧪 Fully tested, scriptable, production-ready --- 📦 Installation --- 🚀 Usage Choose Export Mode --export-mode Compatible DB URLs Description ------------------------ ---------------------------------- -------------------------- postgres-query postgresql:// , postgres:// SELECT + local export redshift-unload redshift:// UNLOAD to S3 sqlite-query sqlite:///path.db For local/lightweight testing --- CLI Examples Basic Export S3 Upload Partitioned Export Redshift UNLOAD Mode --- 🐍 Python API --- 🧪 Running Tests --- 🔧 Environment Variables Supports .env or exported shell variables: Generate a template with: --- 🛠 Roadmap ✅ Modular export modes ✅ CSV and p","default_branch":null,"files":null,"tree":[],"storefront":"/r/vahid110","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/vahid110/sqlxport/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}