SquirrelTable is a desktop application that can run MySQL queries over SSH and generate CSV and XLSX files. Useful for QA where queries need to be run repeatedly and files handed off. Typical usage within a team might be to have a directory of SQL files syncing over cloud storage that one person can update and other people can simply open SquirrelTable and run as they need.
After installing, select a directory of SQL files and configure your database connection and SSH settings if connecting through a tunnel.
Any commented lines in SQL files will appear at the bottom of the screen under Comments rather than in-line.
After running a query, results will be displayed. You can then save the results as a CSV or XLSX.
If you want to copy your settings to another device or want to quickly set up other users, you can export your settings as a .json file. Your login information and SSH key will be encrypted. Upon importing, the SSH key is decrypted and stored alongside the imported preferences file. If you change the key file after importing, the imported key will be deleted.
Finding myself writing query after query for data analysis and QA, I was using HeidiSQL, but wanted a simpler solution for myself and needed a simpler solution to distribute to other employees. My primary use for the app is in an ecommerce environment, but the app could be useful wherever there's a regular and evolving need for data analysis and/or QA.
- Generating statistics on how often different shipping methods are used.
- Finding user errors that aren't caught, such as setting incorrect product visibility settings. Not specifically an error, but incorrect nonetheless.
- Finding users who have tried to add a third party connection, such as a shipping integration, but never finished setting it up (maybe they used the wrong account ID).
- Pulling a list of users who have been inactive but have added products. Or who haven't.
- Finding out how long, on average, it takes between users signing up for an account and adding their first product, then their third, split by user demographics.
SQL...SQuirreL :3
- Auto-refresh when files in directory change
- Ctrl+F Find in results
SquirrelTable is built on Node.js with Electron using Electron Forge.
After installing Node.js, if not already installed:
git clone https://github.com/reiniiriarios/squirrel-table.git
cd squirrel-table
npm install
npm run scss
See forge.config.js for settings. You'll need to edit as needed.
npm start
npm run make
