Join waitlist
Thanks, we'll be in touch shortly

SQL Notebooks

Fast, local, and built for your Mac.
And your browser, terminal & IDE.
Works with Claude Code & Gemini CLI.

Launch Imminent
brew tap sidequery/sidequery && brew install sidequery

Bring Your Own Agent

Sidequery agent works with all ACP-compatible agents.

This means Claude Code & Gemini CLI, with more to come.

Use the AI subscription you already have.

Beautiful charts.
By default.

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

The power of DuckDB.
And friends.

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

Federated joins reduce ETL and speed up time-to-answer. Connect to your Postgres, MySQL, Snowflake & BigQuery databases and join against your data from files.

Your data stays on your machine by default, 100% privacy. Or offload bigger DuckDB-native workloads to the cloud with 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';

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

FAQ

Is this free?

Yes, 100% free to use on your desktop.

Modestly-priced team features are coming soon to make collaboration easier.

What databases are supported?

DuckDB, which can also connect to Postgres and MySQL compatible databases, BigQuery & Snowflake via DuckDB extensions.

What AI models & agents are supported?

You can connect any agent CLI that supports ACP— today that's Claude Code & Gemini CLI.

Does this support Jupyter notebooks & Python?

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

What is the file format?

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

Can I publish my analysis to the web?

Coming soon!

Do any other tools read sqlnb format?

A VS Code extension is in the works that supports both .sql file mode and notebook mode.

Does this support Windows? Linux?

Via the VS Code extension mentioned above.

What versions of macOS are supported?

macOS Sequoia and beyond

What is a federated join?

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

Where did the old Sidequery go?

You can still access it at lite.sidequery.dev