HVF/franchise

Created Jan 9, 2021 · View the HVF/franchise repository page

🍟 a notebook sql client. what you get when have a lot of sequels.

Want this for your repo?

Render a free sample of any GitHub repo in seconds.

Visualize your own →

Contributors

16

Lines of Code

286

From

Sep 14, 2017

To

Nov 13, 2019

About HVF/franchise

Franchise is a lightweight SQL notebook interface that lets you write, execute, and visualize SQL queries without requiring sign-up or installation. The tool supports multiple data sources including local file formats like CSV, JSON, and XLSX files through in-browser processing, as well as connections to PostgreSQL, MySQL, and BigQuery databases through a secure terminal bridge that keeps your data private.

The application features a unique notebook-style layout that allows you to compare multiple queries side by side by dragging and dropping cells on the same line, and you can generate charts from query results with a single click. It's available as both a web application and can be run locally in development mode, deployed as static files, containerized with Docker, or built as an Electron desktop application for Linux, macOS, and Windows.

Franchise is designed for anyone working with SQL databases or data files who wants a more interactive and visual alternative to traditional command-line SQL clients. The project is built with JavaScript and emphasizes usability and privacy by processing data locally in the browser whenever possible rather than routing it through external servers.

Share this video