{"id":"bf0caba0-ef69-46a8-97d7-4f22128ea412","task_name":"Run Query in SQL Editor","summary":"This workflow guides you through executing a SQL query in Supabase's SQL Editor to retrieve data from a test table. You'll navigate to the SQL Editor, write or select a query, and run it to view results limited to 100 rows.","description":"Executes a SQL query in Supabase's SQL Editor to retrieve data from a test table with a limit of 100 rows.","tools_used":[],"agent_steps":[{"step_number":1,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb","element":{"name":"SQL Editor","role":"link","selector":"","xpath":"//html/body/div[1]/div/div/div[3]/div[1]/div[2]/div/div[1]/div/ul/div[1]/li[3]/a","attributes":{"href":"/dashboard/project/bezuunvuecuzqgutpggb/sql","data-size":"default","data-state":"closed","data-active":"false","data-sidebar":"menu-button","data-has-icon":"true"}},"value":"","keys":[],"file_paths":[],"description":"Navigate to the SQL Editor by clicking the 'SQL Editor' link in the left sidebar of your Supabase project dashboard. This opens the query interface where you can write and execute SQL commands."},{"step_number":2,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/sql/e4e43de1-5625-47eb-b377-bea2a285de2d","element":{"name":"Select * FROM test-table limit 100","role":"presentation","selector":"","xpath":"//html/body/div[1]/div/div/div[3]/div[2]/div/div/div/div/div/div[3]/div/main/div/div[2]/div/div/div[1]/div/div/div/section/div/div/div[1]/div[2]/div[1]/div[4]","attributes":{}},"value":"","keys":[],"file_paths":[],"description":"Click on the query template or example that displays 'Select * FROM test-table limit 100' to either select it as a starting point or to populate the editor with this query structure. This pre-written template saves time and ensures correct syntax."},{"step_number":3,"action_type":"type","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/sql/e4e43de1-5625-47eb-b377-bea2a285de2d","element":{"name":"Editor content","role":"textbox","selector":"","xpath":"//html/body/div[1]/div/div/div[3]/div[2]/div/div/div/div/div/div[3]/div/main/div/div[2]/div/div/div[1]/div/div/div/section/div/div/div[1]/textarea","attributes":{"aria-label":"Editor content"}},"value":"","keys":[],"file_paths":[],"description":"Type or paste your SQL query into the editor content area. If you're using the template from the previous step, you can modify it here to adjust the table name, add WHERE clauses, or change the LIMIT value as needed."},{"step_number":4,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/sql/e4e43de1-5625-47eb-b377-bea2a285de2d","element":{"name":"Run ⌘ ↵","role":"button","selector":"","xpath":"//html/body/div[1]/div/div/div[3]/div[2]/div/div/div/div/div/div[3]/div/main/div/div[2]/div/div/div[3]/div/div/div[1]/div[2]/div[3]/div/button[2]","attributes":{"type":"button","data-size":"tiny","data-testid":"sql-run-button"}},"value":"","keys":[],"file_paths":[],"description":"Execute your query by clicking the 'Run' button (displayed with a keyboard shortcut icon ⌘ ↵). The SQL Editor will send your query to the Postgres database and display results in the panel below."},{"step_number":5,"action_type":"type","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/sql/e4e43de1-5625-47eb-b377-bea2a285de2d","element":{"name":"Editor content","role":"textbox","selector":"","xpath":"//html/body/div[1]/div/div/div[3]/div[2]/div/div/div/div/div/div[3]/div/main/div/div[2]/div/div/div[1]/div/div/div/section/div/div/div[1]/textarea","attributes":{"aria-label":"Editor content"}},"value":"","keys":[],"file_paths":[],"description":"Review or modify your query further by typing additional SQL commands or adjustments into the editor content area. This allows you to refine your query, add filters, or test variations without clearing previous results."}]}