Getting started

Open the sample database and get a feel for the app.

Docs

Install

Current version: 0.1.4. See the release notes.

Quit Query Anvil before replacing an existing installation. Keep your data folder; the updated app uses your saved connections and drafts.

Your Lemon Squeezy receipt gives you access to the downloads. The Mac build works on Apple Silicon and Intel Macs running macOS 14 or later. The Windows build is for 64-bit Windows 10 or later. Linux packages target Ubuntu 24.04 on 64-bit Intel and AMD computers.

  • Mac: unzip the download and move Query Anvil.app to Applications.
  • Windows: run the setup installer. If you prefer the portable ZIP, extract the whole folder and open Query Anvil.exe. Keep its accompanying files in that folder.

The Windows download is currently unsigned, so Windows or an organisation’s security policy may warn about or block it. Check with your administrator if installation is blocked; don’t disable your security protections.

Linux

Use an X11 or Wayland desktop with Vulkan graphics. An unlocked desktop Secret Service, such as GNOME Keyring, is required to store your license and saved credentials. File dialogs need your desktop’s portal service. Other distributions and ARM64 haven’t been verified.

For Ubuntu, download QueryAnvil-0.1.4-070a9c6-linux-x64.deb and install it from its folder:

sudo apt install --reinstall ./QueryAnvil-0.1.4-070a9c6-linux-x64.deb

The 4 November refresh keeps version 0.1.4. The --reinstall option replaces an earlier 0.1.4 installation with the refreshed package.

Open Query Anvil from the application menu, or run queryanvil in a terminal.

For the portable archive, download QueryAnvil-0.1.4-070a9c6-linux-x64.tar.gz, extract it and run:

tar -xzf QueryAnvil-0.1.4-070a9c6-linux-x64.tar.gz
./QueryAnvil-linux-x64/queryanvil

The archive uses your system’s libraries; it isn’t a self-contained AppImage. Keep the extracted files together and check the included Read me.txt for dependencies. Both Linux packages are unsigned.

To remove the Debian installation, run sudo apt remove queryanvil. For the archive, remove the extracted application folder. Your app data and databases remain. Deactivate the license in Settings first if you’re retiring the computer.

SHA-256 checksums

Open License in Settings to activate with the key from your receipt. See Licensing for the steps.

Try the sample

  1. Open Query Anvil.

    In Connections, choose Open the sample database. It’s a small shop database named Workshop.

  2. Pick a table.

    Choose customers in the sidebar. Select a row to see its fields in the inspector.

  3. Run a query.

    Open a query tab with ⌘T on Mac or Ctrl+T on Windows or Linux. Paste the example below and run it with ⌘Enter or Ctrl+Enter.

SELECT id, name, email
FROM customers
WHERE status = 'active'
LIMIT 20;

The sample is a local SQLite database. It doesn’t connect to a server or use any of your existing data.

Find your way around

The sidebar lists tables, views and your workspace pages. Connections switches databases, Saved queries holds queries you’ve kept, and History lists commands you’ve run.

Use Go to… or ⌘K / Ctrl+K to jump to a table or action. Settings has the full keyboard shortcut list.