What's new

No new changelog entries since v0.2.1. Add notes manually before publishing.

Install

macOS — the .dmg is unsigned. After dragging Squill to /Applications, remove the Gatekeeper quarantine attribute once:

xattr -dr com.apple.quarantine /Applications/Squill.app

Or, no terminal: double-click Squill, hit Cancel, then System Settings → Privacy & Security → Open Anyway.

Windows — the .msi is unsigned. SmartScreen may warn — click More info → Run anyway.

Linux — .AppImage is portable (chmod +x and run). .deb / .rpm for system install.

What's new

No new changelog entries since v0.1.1. Add notes manually before publishing.

Install

macOS — the .dmg is unsigned. On first launch, macOS will block the app. To fix this, either:

• Right-click the app → Open, then confirm the dialog. One-time step.
• Or run this in Terminal:

  xattr -cr /Applications/Squill.app

Windows — the .msi is unsigned. SmartScreen may warn — click "More info" → "Run anyway".

Linux — .AppImage is portable (chmod +x and run). .deb / .rpm for system install.

What's new

No new changelog entries since v0.1.0. Add notes manually before publishing.

Install

macOS — the .dmg is unsigned. On first launch, right-click the app → Open, then confirm. One-time step.

Windows — the .msi is unsigned. SmartScreen may warn — click "More info" → "Run anyway".

Linux — .AppImage is portable (chmod +x and run). .deb / .rpm for system install.

What's new

2026-02-02

• The Squill app has been verified by Google, which means you can now sign in with your Google account without any "unverified app" warnings. This means Squill is ready to be used by anyone with a Google account, and you can trust that your data is handled securely.

2026-02-09

• You can now sign in with GitHub in addition to Google. If your GitHub email matches an existing Google account, they're automatically linked — no duplicate accounts.

2026-02-11

• Support for long schemas
  • Gracefully handle connections with hundreds of projects.
  • Moved from localStorage to IndexedDB for storing schema information, to avoid hitting the 5MB limit of localStorage.
• BigQuery
  • Use the resource manager API to list projects, instead of the BigQuery API. This way all projects which have BigQuery enabled are listed, even those where the user does have a BigQuery user role.
  • Corrected issue where only first 50 datasets and tables were shown in the schema browser.

2026-02-16

• Auto-completion in the query editor now supports substring matches, and not just prefix matches.
• Streamlined some CSS to make zooming/moving smoother in the canvas.
• Light/dark mode will now change automatically when based on system preference.
• Added STARTS_WITH, ENDS_WITH, CONTAINS_SUBSTR to BigQuery keyword suggestions.
• Large numbers in the results pane are now properly formatted by using comma separators.

2026-02-28

• BigQuery projects can now be (un)selected to simplify auto-completion suggestions.
• Fixed an issue where not all BigQuery datasets were being loaded for auto-completion.
• Shift+Tab can now be used to unindent lines in the query editor.
• The Cmd+click on a table name in the query editor can be disabled in the settings.
• Boolean values are color-coded in the results pane to ease readability.
• Double-clicking on query editor's splitter now centers the splitter vertically.
• Copy-pasting a query editor will now preserve the splitter's position.
• The location of the query editor's splitter is now saved following a page refresh.
• The local DuckDB connection is now always selectable from the menu dropdown.

2026-03-01

• A tab notification is now shown when a query succeeds/fails after the user has switched to another tab.
• A vocal notification is now played when a long-running query finishes executing, which can be disabled in the settings.
• Disabled viewport culling, because it was causing more rendering harm than good.
• Fixed issue where query editor scroll positions would flicker when zooming in and out.
• Long values that overflow in the results pane are now shown in a tooltip on hover.
• Stress-tested the app with 100+ SQL boxes in the DOM, and made various optimizations to keep a smooth experience.
• Selecting multiple SQL boxes and pressing Cmd+Enter will now run all of them.
• Auto-complete for column names now works with table aliases.
• Filtering auto-complete suggestions now highlights the matching portion of the text.

2026-03-03

• Query execution plans can now be visualized, by clicking the magnifying glass in the query editor.
• The schema explorer now displays table metadata, such as row counts and clustering keys.
• Users can move around the canvas when hovering a box, by maintaining the Cmd key and dragging with the mouse.
• Inserting a new line in the query editor now automatically add indentation to match the previous line.
• The query editor now has a button to format the code.
• SQLGlot is called while to catch syntax errors before the running the code.

2026-03-10

• Next page results are pre-fetched in anticipation, which makes turning pages smoother.
• Collaboration works! It's fresh out of the oven so many tweaks will happen.

2026-03-16

• There's now a new button to explode a query into one box per CTE, thanks to SQLGlot in the browser.
• When a query B references a query A, query B automatically adds A as a CTE before execution.
• Fixed an issue where BigQuery JSON fields were not properly detected, and thus were not displayed as intended in the row viewer.
• JSON fields now contain a link to jsonhero.io.
• Added a new setting that allows running downstream dependencies automatically -- disabled by default.

2026-03-17

• Added support for ClickHouse.
• Added support for MySQL.

2026-03-18

• DuckDB files can now be imported into the canvas.
• Upgraded SQL fixer model from gpt-4o-mini to gpt-4.1 for improved accuracy.

2026-04-08

• MCP server: connect Claude Code, Cursor, or VS Code to your Squill workspace.
• Server-first canvas: Pro users get server-side box persistence with real-time WebSocket sync.
• Google Docs-style sharing: restrict canvas access to specific emails.
• Menu bar redesign: classic OS-style menus (Canvas, New, Connection, Tools) with settings panel.
• New shortcut: ⌘J to create a SQL box and focus the editor.

Install

macOS — the .dmg is unsigned. On first launch, right-click the app → Open, then confirm. One-time step.

Windows — the .msi is unsigned. SmartScreen may warn — click "More info" → "Run anyway".

Linux — .AppImage is portable (chmod +x and run). .deb / .rpm for system install.