Franchise – Open Source Notebook for SQL
ranchise is a lightweight but powerful SQL tool with a notebook interface. You can use it online at franchise.cloud. There’s no sign up and no install: a) For editing CSVs, JSON, XLSX files, we’ve integrated js-xlsx, and sql.js so you can query data entirely locally in your browser; and b) For connecting to PostgreSQL, MySQL, or BigQuery, just run a single command in your terminal to open a bridge that allows Franchise to directly connect to your database. Your data never touches a third party server. Chart with a single click and compare queries side by side. With their unique notebook layout engine, you can drag and drop cells on the same line to compare views. No sign up, no install. Chart with a single click. Compare queries side by side. Download your work and share it with anyone. This will be added to the tools section of Research Resources Subject Tracer™.