30% off your first 3 months

Get the deal
Supabase logo
APP GUIDE
In your browser

How to use DuckyHelper in Supabase

In the Supabase dashboard you read a lot of SQL and rows. Ask DuckyHelper about the query or table on screen and it finds the cause and circles it. Hand it a read-only question and it does that in the dashboard (in the Mac app); a daily look at your logs on its own is not in the app yet.

Works on Mac, Windows and LinuxDoing jobs is in the Mac app
01
ASK
Works now

Find why a query returns duplicates

YOU SAY
“Why does this query return every user twice?”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Open the query in the SQL editor so the whole statement is on screen, then ask out loud.
  2. 02DuckyHelper reads the select, the tables and how they are joined.
  3. 03It circles the join condition and says one user has many orders, so each order gives a row.
  4. 04Ask for the fix and it tells you the choices, like grouping by user, as a short note.

You getYou know the join repeats users for every order, and how to keep a single row for each.

SupabaseSQL editor
1select u.id, u.email, o.plan2from users u3join orders o on o.user_id = u.id4where u.created_at > now() - interval '7 days';
The join to orders gives one row per order, so a user with two orders appears twice. Group by user.
Demo · example pageClip · 6 sStill
02
ASK
Works now

Find rows that break a rule

YOU SAY
“Which of these rows break the one-email-per-user rule?”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Open the table in the table editor so the rows and the email column show, then ask out loud.
  2. 02DuckyHelper reads the emails and compares them across the rows on screen.
  3. 03It circles the two rows that share an email and says which came first.
  4. 04Ask how to stop it happening and it explains, in plain words, what rule the table needs.

You getThe repeated emails are found, with the row ids, without sorting the table yourself.

SupabaseTable editor: profiles
idemailcreated1ana@copperwick.coNov 22ben@copperwick.coNov 33ana@copperwick.coNov 54cy@copperwick.coNov 6
Rows 1 and 3 both use ana@copperwick.co. The second one, from Nov 5, is the duplicate.
Demo · example pageClip · 5 sStill
03
JOB
On Mac

Run a read-only count

YOU SAY
“Run a count of sign-ups from last week in the SQL editor and tell me the number”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Open the project's dashboard, or say its name.
  2. 02DuckyHelper opens the SQL editor and writes one select that counts last week's rows.
  3. 03It runs the query and reads the number from the result panel.
  4. 04It tells you the number out loud and shows the query it ran.

You stay in controlIt does the job without stopping to ask. A Stop control stays on the window the whole time, Take control hands it back to you, and the task is recorded so you can watch it again.

You getThe number you needed, with the query so you can reuse it.

Count last week's sign-upsExample · Mac app
Demo · example data · Mac appClip · 7 sStill
04
ALWAYS ON
Not in the app yet

Morning check of the logs

YOU SAY
“Every morning at 8, check the API logs for errors and tell me if anything spiked”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Say it once while the dashboard is open. It does the first check on the logs you can see now.
  2. 02It learns the dashboard's own actions for opening the logs the first time, so later runs are quick.
  3. 03Turn it on from the card it offers. From then on it runs every morning at 8.
  4. 04Each run lands in the history with what it saw.

Not in the app yetAlways-on jobs are not in the app yet: this shows how one would run. Today you can ask for the same job once, in the Mac app.

You getYou start the day knowing whether the API logs show a spike, without opening them.

Make this automatic?Schedule
Morning log check
WhenEvery morning at 8
DoesOpen the API logs and look for errors since yesterday
ThenTell you if anything spiked
Demo · example data · not in the app yetClip · 7 sStill
TIPS

Getting more out of it in Supabase.

  • 01

    Select the whole query before you ask. If the statement is cut off, it can only explain the part you see.

  • 02

    For rows, sort the column you care about first, so duplicates sit side by side on screen.

  • 03

    Name the table when you ask for a count. It writes a plain select, and shows you the SQL it used.

  • 04

    Keep production questions read-only. Anything that changes data is yours to run.

FAQ

Questions about Supabase.

Do I need to connect my database to DuckyHelper?

No. There is nothing to connect. It sees what is on your screen while the pill is open, and for jobs (in the Mac app) it uses the Supabase dashboard in your browser, signed in as you. It's built not to type your passwords or card numbers.

Can it change or delete my data?

The jobs in this guide only run selects that read data. If you ask it to send or post something, it does it without stopping to ask, and you can press Stop at any moment.

Does it see my whole database?

No. Only what is on your screen while the pill is open, like the rows or the query. A job in the Mac app reads what the job needs.

Does it work on my phone?

No. DuckyHelper is an app for Mac, Windows and Linux, so it works with the dashboard in your computer's browser.

Questions and jobs

Do anything

Ask it a question or hand it a job, in any app.

Doing jobs for you is in the Mac app. Asking works on Mac, Windows and Linux.