/ / LOCAL

Vanas Data Studio

Import an XLSX workbook, inspect origin tables, transform data with SQL, and prepare governed output tables for dashboards.

Page of 1 0 records

Confirm action

This action needs confirmation.

Enter value

This action needs a value.

Add new row

Writes are disabled by default.

Raw JSON

Add new column

Writes are disabled by default.

Recommended to use lowercase and underscores, e.g. column_name

Can either be a literal or an expression. Wrap expressions in brackets, e.g. (gen_random_uuid()).

SQL preview 

        

        
      

    

    
      

        

          

            
Create enum type

            
Writes are disabled by default.

          

          
        

        
        
        
        
        
Recommended to use lowercase and underscores, e.g. status_type.

        
        
        
One value per line. Comma-separated values are also accepted.

        
      

    

    
      

        

          

            
Add enum value

            
Append a value to a local Postgres enum type.

          

          
        

        
        
        
        
        
      

    

    
      

        

          

            
Import data from CSV

            
Writes are disabled by default.

          

          
        

        
        
        
        
        
        
        
      

    

    
      

        

          

            
Create storage bucket

            
Writes are disabled by default.

          

          
        

        
        
        
        
        
        
        
        
Creates a local top-level folder with Supabase-style bucket metadata.

        
      

    

    
      

        

          

            
Create auth user

            
Creates a local Supabase-style user and identity.

          

          
        

        
        
        
        
        
        
        
        
        
        
        
        
        
        
      

    

    
      

        

          

            
Edit auth user

            
Updates local auth.users fields and linked identity metadata.

          

          
        

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
      

    

    
      

        

          

            
Create MFA factor

            
Adds a local Supabase-style MFA factor for the selected user.

          

          
        

        
        
        
        
        
        
        
        
        
        
      

    

    
      

        

          

            
Create SSO provider

            
Creates a local Supabase-style SAML SSO provider and domain.

          

          
        

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
      

    

    
      

        

          

            
Generate Auth link

            
Generates a local one-time Auth link. The token is shown once and stored only as a hash.

          

          
        

        
        
        
        
        
        
        
        
        
        
      

    

    
      

        

          

            
Auth configuration

            
Manage local Supabase-style Auth settings.

          

          
        

        
        
        
        
        
        
        
        
        

          
          
          
        

        
        

          
          
        

        
        
        
        
        

          
          
        

        

        

          
Security controls

          
          

            
            
          

          
          
          

            
            
            
            
            
            
          

          

            
            
            
            
          

        

        

          
Email templates

          
          
          
          
          
          
          
        

        

          
Auth hooks

          
          
          
          
          
          

            
            
          

          

            
            
          

        

        
      

    

    
      

        

          

            
Edge Function secret

            
Store a local runtime secret. Values are never shown after saving.

          

          
        

        
        
        
Use uppercase environment variable names, e.g. OPENAI_API_KEY.

        
        
        
      

    

    
      

        

          

            
Edge Function

            
Create a local executable function in a configured writable root.

          

          
        

        
        
        
        
        
        
        
Leave source empty to generate a safe Node.js JSON response template.

        
      

    

    
      

        

          

            
Vault secret

            
Store an encrypted project secret. Values are never shown after saving.

          

          
        

        
        
        
        
        
        
        
      

    

    
      

        

          

            
Create database webhook

            
Store a local Supabase-style webhook definition. Headers are encrypted at rest.

          

          
        

        
        
        

          
          
        

        

          
          
          
        

        
        
        
        
        

          
          
        

        
        
        
        
      

    

    
      

        

          

            
Create cron job

            
Store a local Supabase-style scheduled job definition.

          

          
        

        
        
        

          
          
        

        
        
        
        
        
        
        
        
      

    

    
      

        

          

            
Bucket settings

            
Update local bucket metadata.

          

          
        

        
        
        
        
        
        
      

    

    
      

        

          

            
Create storage policy

            
Create a local bucket policy for object actions.

          

          
        

        
        
        
        
        

          
          
        

        
        
        
        
        
        
        
      

    

    
      

        

          

            
Upload storage file

            
Writes are disabled by default.

          

          
        

        
        
        
        
        
        
Uploads to the current bucket/folder. Local uploads are capped at 750 KB.

        
      

    

    
      

        

          

            
Create storage folder

            
Writes are disabled by default.

          

          
        

        
        
        
Creates one local folder inside the current bucket/folder.

        
      

    

    
      

        

          

            
Storage preview

            
Read-only local file preview.

          

          
        

        

        
      

    

    
      

        

          

            
Storage file action

            
Move or copy a local storage object.

          

          
        

        
        
        
        
        
        
Target paths must include a bucket and file name. Existing files are never overwritten.

        
      

    

    
      

        

          

            
Create signed upload URL

            
Create a temporary upload URL for a local storage object.

          

          
        

        
        
        

          
          
        

        

          

            Signed upload result
            

              
              
              
            

          

          

        

        
      

    

    
      

        

          

            
Save SQL query

            
Name this query before adding it to the sidebar.

          

          
        

        
        
        
Closing editor tabs does not delete saved queries. Use the sidebar delete action for saved entries.

        
      

    

    
      

        

          

            
SQL query activity

            
No running queries.

          

          
        

        

        
      

    

    
      

        

          

            
Create a new table

            
Writes are disabled by default.

          

          
        

        

          
          
        

        
        
        

          
          
Restrict access to your table by enabling RLS and writing Postgres policies.

        

        

          
          
Broadcast changes on this table to authorized subscribers.

        

        

          Columns
          
        

        

        

          
        

        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Edit column

            
Writes are disabled by default.

          

          
        

        

          
          
        

        
        
        
        
        
        
      

    

    
      

        

          

            
Table action

            
Writes are disabled by default.

          

          
        

        
        
        
        
        
        
        
        
      

    

    
      

        

          

            
Editing value

          

          

            
            
            
          

        

        

          
          

            
            
            
            
          
          

          
        

        
      

    

    
      

        

          

            
Create index

            
Writes are disabled by default.

          

          
        

        
        
        
        
        
        
        
Select one or more columns. Order follows the table column order.

        
        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Create constraint

            
Writes are disabled by default.

          

          
        

        
        
        
        
        

          
          
        

        

          
          
        

        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Create RLS policy

            
Policies apply to the selected local Postgres table.

          

          
        

        

          
          

            
            
            
            
            
            
            
            
          

        

        

          
          

            
            
            
Required for SELECT, UPDATE, DELETE and ALL policies.

            
            
            
Required for INSERT. Often also useful for UPDATE and ALL.

          

        

        

          
          

            

              

                Policy SQL
                
              

              

            

          

        

        
      

    

    
      

        

          

            
Create schema

            
Create an empty local Postgres schema.

          

          
        

        
        
        
        
        
      

    

    
      

        

          

            
Create role

            
Create a local Postgres role.

          

          
        

        
        
        
        
        
        
        
        
        
        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Create sequence

            
Create a local Postgres sequence.

          

          
        

        
        
        
        
        

          
          
          
          
          
          
        

        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Create view

            
Create a local Postgres view from a SELECT statement.

          

          
        

        
        
        
        
        
        
        
        
        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Create function

            
Create a local Postgres function.

          

          
        

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Run function

            
Invoke a local Postgres function with JSON arguments.

          

          
        

        
        
        

          Result JSON
          
        

        
        
      

    

    
      

        

          

            
Table grant

            
Grant or revoke a local Postgres table privilege.

          

          
        

        
        
        
        
        
        
        
        
        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Schema grant

            
Grant or revoke a local Postgres schema privilege.

          

          
        

        
        
        
        
        
        
        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Create trigger

            
Create a local Postgres table trigger.

          

          
        

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        

          

            SQL preview
            
          

          

        

        
      

    

    
      

        

          

            
Security & API

            
Local admin mode is active for this browser.

          

          
        

        
        
        

          
          
        

        
        

          
          
          
          
          
          
          
        

        

          API key secret Shown once