In simple English
This tool lets you search for tables, write queries, and share results in one place. You can build charts and schedule reports without leaving your browser. It runs on your own server and connects to your databases. You need some technical skill to set it up and keep it running. The project is free to use under an open-source licence.
What it is
Querybook is a self-hosted data workspace that combines table search with a notebook interface. It lets teams write SQL, track table schemas, and build dashboards.
What it is good for
Solo builders who manage data across multiple sources and want a central place to write queries and share reports.
- Brings search, query editing, and charts into one web page.
- Connects to many databases including Postgres, MySQL, and Snowflake.
- Supports team collaboration and live document sharing.
- Requires Docker (a way to run a program inside its own sealed box, so it cannot break anything else on your server) for setup.
- Needs ongoing maintenance to manage server resources and database connections.
- Heavy software designed for larger teams rather than casual single users.
Raw database clients and scattered SQL scripts
PostgreSQL
- apache/superset75k stars
Provides dashboards and data exploration, but focuses more on visualization than query notebooks.
- dbeaver/dbeaver52k stars
A free desktop program that connects to more than a hundred kinds of database and lets you browse and edit them.
- dimitri/pgloader6.5k stars
Loads data into PostgreSQL from other databases and from files, keeping going when individual rows fail.
git clone https://github.com/pinterest/querybook.git cd querybook make