🍟 a notebook sql client. what you get when have a lot of sequels.
Switch branches/tags
Nothing to show
Clone or download
bijection Merge pull request #63 from 20after4/issue-62
Handle serialized utf8 byte arrays
Latest commit b541e65 Jun 28, 2018
Failed to load latest commit information.
data initial release Sep 14, 2017
public initial release Sep 14, 2017
src Handle serialized utf8 byte arrays Jun 27, 2018
.gitignore initial release Sep 14, 2017
CONTRIBUTING.md initial release Sep 14, 2017
LICENSE.md license Sep 20, 2017
README.md Update README.md Oct 2, 2017
electron.js initial release Sep 14, 2017
nwb.config.js initial release Sep 14, 2017
package.json cleanup sexql Oct 17, 2017
yarn.lock fix #47 Oct 16, 2017



a sql notebook

Franchise is a lightweight but powerful SQL tool with a notebook interface. You can use it online at franchise.cloud.

Franchise is pretty cool

  • There's no sign up and no install
    • For editing CSVs, JSON, XLSX files, we've integrated js-xlsx, and sql.js so you can query data entirely locally in your browser
    • 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
  • Compare queries side by side

Running Locally (Development Mode)

There's an online version of franchise right here. There are also instructions for building franchise to static files here.

Otherwise, here's how to run franchise in development mode:

  1. If you don't have npm or yarn, install yarn.

  2. Open up a terminal and run

    git clone --depth 1 https://github.com/HVF/franchise.git
  3. cd into the project directory

    cd franchise
  4. Install the project dependencies

    yarn install

    (you can also run npm install)

  5. Start the dev server

    yarn start

    (you can also run npm start)

  6. Open up a browser and go to http://localhost:3000

  7. Edit some files in franchise/src.

    When you save your edits, and the browser will automatically reload.

  8. (optional) Add a bunch of great functionality and send a PR!