{"id":"82919517-e958-45b2-bfe3-814d7d8aa40f","task_name":"Create table","summary":"Create a new PostgreSQL table in Supabase by defining a table name, adding a named column with a text data type, setting a default value, and saving the configuration. Use this workflow when you need to set up a new data structure for storing information in your Supabase project.","description":"Creates a new table in Supabase with a named column, sets its data type to text, assigns a default value, and saves the table.","tools_used":[],"agent_steps":[{"step_number":1,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"New table","role":"button","selector":"","xpath":"//html/body/div/div/div[1]/div[3]/div[2]/div/div/div/div/div/div[1]/div/div/div/div[2]/div/div[1]/div[2]/button","attributes":{"name":"New table","type":"button","title":"Create a new table","data-size":"tiny","data-state":"closed"}},"value":"","keys":[],"file_paths":[],"description":"Begin creating a new table by clicking the 'New table' button in the Supabase dashboard. This action opens the table creation dialog where you will define the table's name and initial structure."},{"step_number":2,"action_type":"type","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Name","role":"textbox","selector":"","xpath":"//*[@id=\"name\"]","attributes":{"id":"name","type":"text","data-size":"medium","data-testid":"table-name-input"}},"value":"","keys":[],"file_paths":[],"description":"Enter the desired name for your table in the 'Name' field. Choose a descriptive, lowercase name (following PostgreSQL conventions) that clearly represents the data the table will store, such as 'users', 'products', or 'orders'."},{"step_number":3,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Add column","role":"button","selector":"","xpath":"//html/body/div[3]/div[1]/div[5]/div/div[3]/button","attributes":{"type":"button","data-size":"tiny"}},"value":"","keys":[],"file_paths":[],"description":"Click the 'Add column' button to begin defining columns for your table. This creates a new column entry in the table schema where you can specify the column name, data type, and optional default value."},{"step_number":4,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Column name","role":"textbox","selector":"","xpath":"//html/body/div[3]/div[1]/div[5]/div/div[2]/div[5]/div[2]/div[2]/div/div/div/div/div/input","attributes":{"type":"text","data-size":"small","aria-label":"Column name","placeholder":"column_name"}},"value":"","keys":[],"file_paths":[],"description":"Click on the 'Column name' input field to activate it for editing. This field is where you will type the name of your first custom column."},{"step_number":5,"action_type":"type","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Column name","role":"textbox","selector":"","xpath":"//html/body/div[3]/div[1]/div[5]/div/div[2]/div[5]/div[2]/div[2]/div/div/div/div/div/input","attributes":{"type":"text","data-size":"small","aria-label":"Column name","placeholder":"column_name"}},"value":"","keys":[],"file_paths":[],"description":"Type the name of your column in the 'Column name' field. Use a descriptive, lowercase name that indicates the data it will hold, such as 'email', 'title', or 'description'."},{"step_number":6,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Choose a column type...","role":"combobox","selector":"","xpath":"//html/body/div[3]/div[1]/div[5]/div/div[2]/div[5]/div[2]/div[3]/div/div/button","attributes":{"type":"button","data-size":"small","data-state":"closed"}},"value":"","keys":[],"file_paths":[],"description":"Click on the 'Choose a column type...' dropdown to open the data type selector. This allows you to select the appropriate PostgreSQL data type for your column."},{"step_number":7,"action_type":"type","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"","role":"combobox","selector":"","xpath":"//*[@id=\"radix-:rcd:\"]","attributes":{"id":"radix-:rcd:","type":"text","placeholder":"Search types..."}},"value":"","keys":[],"file_paths":[],"description":"Type 'text' in the column type dropdown to filter the available data types and quickly locate the text option. Supabase will narrow the list as you type."},{"step_number":8,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"text Variable-length character string","role":"option","selector":"","xpath":"//*[@id=\"radix-:rco:\"]","attributes":{"id":"radix-:rco:","data-value":"text","data-disabled":"false","data-selected":"true"}},"value":"","keys":[],"file_paths":[],"description":"Click on the 'text Variable-length character string' option from the dropdown to select the text data type for your column. This data type is suitable for storing strings of any length, such as names, emails, or descriptions."},{"step_number":9,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Column default value","role":"textbox","selector":"","xpath":"//html/body/div[3]/div[1]/div[5]/div/div[2]/div[5]/div[2]/div[4]/div/div/div/div/div/div/input","attributes":{"type":"text","data-size":"small","aria-label":"Column default value","data-testid":"test_col-default-value","placeholder":"NULL"}},"value":"","keys":[],"file_paths":[],"description":"Click on the 'Column default value' input field to activate it. This field allows you to specify a value that will automatically be assigned to this column if no value is provided when a new row is inserted."},{"step_number":10,"action_type":"type","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Column default value","role":"textbox","selector":"","xpath":"//html/body/div[3]/div[1]/div[5]/div/div[2]/div[5]/div[2]/div[4]/div/div/div/div/div/div/input","attributes":{"type":"text","data-size":"small","aria-label":"Column default value","data-testid":"test_col-default-value","placeholder":"NULL"}},"value":"","keys":[],"file_paths":[],"description":"Type the desired default value for your column in the 'Column default value' field. For text columns, enter a string value (such as 'Pending' or 'Unknown') that makes sense as a fallback when no value is explicitly provided during data insertion."},{"step_number":11,"action_type":"click","url":"https://supabase.com/dashboard/project/bezuunvuecuzqgutpggb/editor","element":{"name":"Save ⌘ ↵","role":"button","selector":"","xpath":"//html/body/div[3]/div[2]/div/button[2]","attributes":{"type":"button","data-size":"tiny"}},"value":"","keys":[],"file_paths":[],"description":"Click the 'Save ⌘ ↵' button to create the table with the specified name, column, data type, and default value. This action commits the table schema to your Supabase database."}]}