Thanks, we'll be in touch shortly

SQL Notebooks

Fast, local, and built for your Mac.
For DuckDB, Postgres & MySQL.

Launch Imminent
brew tap sidequery/sidequery && brew install sidequery
Sidequery SQL Notebook

Beautiful charts.
By default.

Transform query results into stunning visualizations in code.
Or use the UI, or AI ✨

The power of DuckDB.
And friends.

Analyze & visualize millions or billions of rows right on your Macbook from CSV, Parquet, JSON files

Connect to your Postgres or MySQL databases and join against your data from files— federated joins.

Your data stays on your machine by default, 100% privacy. Or offload heavier workloads to Motherduck.

WITH customers AS (
  SELECT * FROM postgres.customers
),
orders AS (
  SELECT * FROM mysql.orders
),
promotions AS (
  SELECT * FROM 'q4_promotions.csv'
)
SELECT
  c.customer_name,
  o.order_total,
  p.discount_rate
FROM orders o
JOIN customers c ON o.customer_id = c.id
LEFT JOIN promotions p ON o.promo_code = p.code
WHERE o.order_date >= '2024-01-01';
SQL Notebook Example

Cruft-free Notebooks

Organize related queries and charts into a notebook.

Reference prior queries as if they were tables, as if one big CTE.

Edit queries in your favorite text editor or IDE.

Coming Soon Publish dashboards to the web to share

FAQ

Is this free?

Yes, 100% free in its current form. Paid features are tbd.

What databases does Sidequery support?

It supports DuckDB, which can also connect to Postgres and MySQL compatible databases via extensions.

Are other data warehouses supported?

Do they support they Postgres or MySQL protocl? Maybe. Otherwise, no.

Does this support jupyter notebooks & python?

No; this was an explicit design choice. SQL notebooks with no compromises.

What is the file format?

sqlnb is a new standard based on plain SQL that allows specification of dashboard & charts. If a couple features are avoided, it gracefully degrades in other SQL environments and can be used with any editor.

Does this support Windows? Linux?

No

What versions of macOS are supported?

macOS Sequoia and beyond

Can I publish my findings to share with my team?

Soon :)

What is a federated query?

Ever wanted to join a table in Postgres or MySQL against a CSV file, or maybe to each other? Fear no more, federated queries let you do this.

Where did the old Sidequery go?

You can still access it at lite.sidequery.dev