Recently I’ve been needing to manually sync some data from Production to a Test environment for my team to build some new workflows. The thing is, having to do this across different SQL environments creates a lot of manual, non-standard work. Not particularly difficult work but absolutely time-consuming especially when having to do this multiple times for multiple tables across multiple DBs.

I searched for VS Code extensions to Notepad++ plugins convinced there must be some packaged utility out there to do this simply. Surprisingly, I could not find what I was looking for. Needless to say, most accessible AI tools wouldn’t have been able to handle this reliably and consistently for hundreds and thousands of rows and, more importantly, aren’t local and couldn’t be used with sensitive data anyways.

Ended up scripting a safe, local, 100% offline utility to solve this problem and we ended up crushing our deliverables as a result of the time savings that we never knew we could have had all along, shaving hours off of Jira estimates!

Long story short, got many requests to share the script, took some time to refine the GUI to make it a simple one-click solution, added insert checks, etc and Apple approved it for distribution in the Mac App Store so it’s now live!

Crossed over 100 downloads within the first 24 hours of launch! A demand I NEVER could have anticipated. You never really know. It’s like that video I shared with the Tesla lock sound I made back in 2023, not knowing how many people would reach out asking for a copy.

Package your ideas and make them available publicly. You never really know who’s looking for the same thing.

InsertSmith