Turn CSV Files into SQL Statements for Quick Database Transfers
This package lets you unload a CSV from a warehouse, turn that CSV into SQL statements creating a temp table and inserting data with a CLI command, and copy those SQL statements into your query editor so you can start using the data in a different warehouse. Useful for when you need to join data together that's stored in two separate data warehouses (e.g. finance and product data).
Turn CSV Files into SQL Statements for Quick Database Transfers launched on May 28, 2024 with 13 votes, #1,049 of 4,539 launches that month and more than 75% of that year's launches. The site was still online in September 2026, 2 years on.
In plain words
This package converts CSV files into SQL statements that create temporary tables and insert data, enabling quick transfers between data warehouses via a CLI command. Users can export a CSV from one warehouse, generate the corresponding SQL, and paste it into another warehouse to join data across separate systems. It addresses the workflow challenge of combining data stored in different warehouses, such as finance and product data, without manual data transformation steps.
written from the facts on this page · September 2026
From the sources
This package takes a CSV and generates SQL statements to create a temp table and insert the data within it into the temp table. Good when you need to move data between warehouses for ad hoc analysis and the warehouses are not otherwise connected. - ryanwithawhy/generate_temp_table_sql
Does a similar job
all alternatives →- CCConvert CSV files into MySQL insert scripts2014 · database-import-scriptor.appspot.com · ▲41
Comma Separated Values (CSV) to Unicode Separated Values (USV)2024 · crates.io · ▲208crates.io serves as a central registry for sharing crates, which are packages or libraries written in Rust that you can use to enhance your projects
- DTDropbase – Turn your CSV files into live databases in seconds2020 · dropbase.castodia.com · ▲26
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 27d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 25d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 23d ago · openbot.run
Talanoa▲345Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 20d ago · talanoa.email
CoreSpeed▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 28d ago · corespeed.io
Source: Show HN post ↗
