# pinterest/querybook

Querybook is a Big Data Querying UI, combining collocated table metadata and a simple notebook interface.

Repository: https://github.com/pinterest/querybook
Canonical: https://ross.abutalabs.com/products/querybook
Homepage: https://www.querybook.org
Language: TypeScript
License: Apache-2.0
License Family: permissive
Topics: metastore, analyses, hive, presto, notebook, typescript, flask, celery, charting
Last push: 2026-08-20T20:20:47+00:00

## Health v2 (maintenance only)
Score: 67/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 8, longevity 100
- inputs: {"age_days": 2372, "days_push": 13, "days_rel": 499, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2280, forks 298 (observed 2026-08-28T04:06:33.793244+00:00)

## What it is
Querybook is an open-source big data IDE from Pinterest that combines a collaborative notebook interface (DataDocs) with table metadata from a metastore. It lets users compose SQL queries with autocompletion, visualize results with charts, schedule recurring analyses, and share documentation across query engines like Presto, Hive, and Snowflake.

## Use cases
- run ad-hoc SQL queries against Presto and Hive clusters
- build dashboards from scheduled notebook queries
- browse and document table metadata from a Hive metastore
- collaborate with teammates on shared query notebooks
- visualize query results as charts without leaving the tool
- track data lineage and frequent query patterns
- export query results to Google Sheets or S3

## When to choose
- your team needs a self-hosted collaborative SQL notebook UI for big data engines
- you want table metadata, autocomplete, and lineage integrated with your metastore
- you need scheduled query reports with charting and Slack/email notifications
- you want a pluggable query interface supporting many engines via SQLAlchemy

## When to avoid
- you only need a lightweight local SQL client for a single database
- you require a fully managed cloud BI product with no infrastructure to run
- your workflows are primarily non-SQL (e.g., Python-only analysis notebooks)

## Facets
- artifact type: application
- maturity: active
- function: search-engine, data-visualization, scheduling, web-framework, plugin-system, developer-tools
- domain: big-data, data-science, analytics, databases, self-hosted, developer-tools
- platform: self-hosted, python
- tags: sql-notebook, query-editor, hive-metastore, presto, datadoc, collaboration, data-lineage, celery, flask, elasticsearch, docker, web-server, nodejs

## Member repositories
- pinterest/querybook (main) score 67

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:33.793244+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-30T02:41:22.851705+00:00, confidence not recorded.
  - readme: https://github.com/pinterest/querybook (fetched 2026-08-28T04:06:33.793244+00:00, sha 23dd6eb69256)
  - homepage: https://www.querybook.org (fetched 2026-08-29T10:22:08.754138+00:00, sha f78990347d82)
  - site_page: https://www.querybook.org/docs (fetched 2026-08-29T10:22:08.756737+00:00, sha fa4c3bb1716f)
  - site_page: https://www.querybook.org/docs/setup_guide/quick_setup (fetched 2026-08-29T10:22:08.758616+00:00, sha 7fa6f395ad91)
  - site_page: https://www.querybook.org/docs/integrations/plugins (fetched 2026-08-29T10:22:08.760351+00:00, sha 385ea6e52d90)
  - site_page: https://www.querybook.org/docs/setup_guide/connect_to_query_engines (fetched 2026-08-29T10:22:08.762564+00:00, sha 6b45b6ee6634)
  - site_page: https://www.querybook.org/docs/setup_guide/deployment_guide (fetched 2026-08-29T10:22:08.764604+00:00, sha 1efbf8e7561d)
  - site_page: https://www.querybook.org/docs/developer_guide/developer_setup (fetched 2026-08-29T10:22:08.766688+00:00, sha 650bfed533b9)
  - site_page: https://www.querybook.org/docs/changelog (fetched 2026-08-29T10:22:08.768685+00:00, sha cebb56cd3aa3)
- Data as of 2026-08-30T08:39:29.467469+00:00.