BaskQL

Data and analyticsBask app

About BaskQL

Read-only SQL over your own orders, patients, treatments and payments. Save queries, chart the results and export them.

What you can do with BaskQL

  • Run read-only SQL over your orders, patients, treatments, payments, coupons, webhooks, workflows and more. Only SELECT and WITH statements run.
  • Bask filters every table to your store before your query runs, so there is no store column to filter on.
  • Switch results to a bar, line, area or pie chart and export the chart as a PNG, or export table results as CSV.
  • Saved holds your saved queries and a history of what you ran. Generate writes SQL from a description, and Fix with AI proposes a correction to a failed query. Both use AI credits.
  • Ready-made metrics such as revenue, refunds and net_revenue give you consistent definitions. net_revenue is collected money with refunds subtracted.

Set up BaskQL

  1. Open BaskQL under Apps in your Bask sidebar. The first time, Bask creates a read-only database user for your store.
  2. Browse the Tables tab to see the columns available to your store.
  3. Write a query in the editor and run it with Cmd-Enter.
  4. Choose Save, name the query and keep it under Saved. Use Update to save later changes.
  5. Switch the results to Chart and pick the axes to visualize them.
  6. Use Export CSV for table results.

Good to know

  • Results stop at 10,000 rows, a query has 30 seconds to finish, and the workspace allows 60 queries a minute across your store.
  • Timestamps are stored in UTC, so convert inside the query for local reporting.
  • Tables for flows, sites and web analytics need Studio enabled for your store.

Who it is for

Written for a developer or analyst who needs custom reports. If you do not write SQL, hand it to your developer.

How it installs

Added to your subscription