# HVF/franchise

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

Repository: https://github.com/HVF/franchise
Canonical: https://ross.abutalabs.com/products/franchise
Homepage: https://franchise.cloud
Language: JavaScript
License: MIT
License Family: permissive
Topics: sql, mysql, postgresql, bigquery, database
Last push: 2022-12-10T20:04:54+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 3319, "days_push": 1362, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4000, forks 263 (observed 2026-08-28T04:08:32.006198+00:00)

## What it is
Franchise is an open-source SQL notebook client with a lightweight notebook interface for querying and visualizing data. It runs in the browser with local SQLite processing for CSV/JSON/XLSX files, and connects to PostgreSQL, MySQL, or BigQuery via a local bridge so data never touches third-party servers.

## Use cases
- query sql databases in a notebook interface
- explore csv json xlsx files with sql in the browser
- visualize query results as charts and maps
- compare sql queries side by side
- share sql analysis as a standalone html document
- connect to postgresql mysql or bigquery without installing a heavy client

## When to choose
- you want a no-install, no-signup sql scratchpad that runs locally
- you need quick ad-hoc querying and charting of files or databases
- you care that query data never leaves your machine
- you want to share query results as a portable html notebook

## When to avoid
- you need a full-featured database administration tool with schema management
- you require collaborative multi-user notebooks or scheduled dashboards
- you need support for databases beyond PostgreSQL, MySQL, BigQuery, and SQLite
- you need an actively developed project with frequent updates

## Facets
- artifact type: application
- maturity: maintenance
- function: database, data-visualization, charts, gui
- domain: databases, data-visualization, developer-tools, data-science
- platform: browser, cross-platform
- tags: sql-notebook, sql-client, notebook-interface, postgresql, mysql, bigquery, sqlite, csv, xlsx, electron, self-hosted, privacy, web-server, docker, desktop, javascript

## Member repositories
- HVF/franchise (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:32.006198+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:24:08.650406+00:00, confidence not recorded.
  - readme: https://github.com/HVF/franchise (fetched 2026-08-28T04:08:32.006198+00:00, sha 4f0cb35566b5)
  - homepage: https://franchise.cloud (fetched 2026-08-29T09:17:34.531362+00:00, sha 69e2c5fd3a55)
- Data as of 2026-08-30T08:39:29.467469+00:00.