SQL Query Builder Pro Lite

Build

SQL

Checks

    Text only here: the builder writes SQL; it never connects to a database server, and nothing you type leaves your browser. To try SQL on your own data, use SQL Lab, which runs it in a database kept on this device. Review generated SQL before running it on a real database.

    Project Main

      SQL Lab

      SQL Lab runs SQL in SQLite, a database engine embedded in this app. Your databases are kept on this device and nothing is sent anywhere. SQLite's SQL is close to standard SQL but not identical to SQL Server, PostgreSQL or MySQL, so SQL written for those may need changes here.

      View SQL

      Settings

      Theme
      Output
      SQL format

      Keyword case applies to both formatted and one-line SQL; the layout options apply to formatted SQL. Text you type into a field is never changed.

      
            
      

            
      
                Privacy (stored only in this browser)
                
                
                
            
      

            
      
                
            
      
        
      
          

    
        
      
            
      Name
      
            
      
                
                
                
            
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Save as template
      
            
      
                
                
            
      
            
      
                
                
            
      
            
      
                
                
                
            
      
            
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Add table
      
            
      
                
                
                
      A CREATE TABLE statement. Types are optional. Mark keys with PRIMARY KEY, and links to other tables with REFERENCES other_table (column).
      
                
            
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Import schema
      
            
      
                
                
                
      
            
      
            
      
            
      
                Your current schema
                
                
            
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Import SQL
      
            
      
                
                
                
      
            
      
            
      
                
                
                
      
            
      
            
      
            
      Import replaces the builder's query of the same type (SELECT, INSERT, UPDATE or DELETE). Undo brings your current query back.
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Compare dialects
      
            
      
            
      
                
                
            
      
            
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Projects
      
            
      Each project keeps its own templates, history, schema, current query and dialect, so work on different databases stays apart. Settings are shared, and everything stays in this browser.
      
            
            
      
                
                
      
                    
                    
                
      
                
            
      
            
      
                
            
      
        
      
          

    
        
      
            
      Move template
      
            
      
            
      
                
                
            
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Versions
      
            
      Each Save keeps the query it replaces, up to 10 per template. Restoring a version keeps the current query as a version too.
      
            
            
      
            
      
                
            
      
        
      
          

    
        
      
            
      Restore from backup
      
            
      
            
      
                How to restore
                
                
            
      
            
      
                
                
            
      
        
      
          

    
        
      
            
      Create tables in SQL Lab
      
            
      Creates empty tables from your schema in a SQL Lab database (SQLite). Nothing runs until you select Create tables, and it all runs as one step: if any table fails, none are created.
      
            
      
                
      
                    
                    
                
      
                
      
                    
                    
                
      
            
      
            
      
                Tables
                
      
                    
                    
                
      
                
        
            
        
            
            
        
                SQL that will run
                
        
            
        
            
            
        
                
                
            
        
        
        
            

    
        
        
            
        Import into SQL Lab
        
            
        Import a SQL script, CSV, JSON or an HTML table into a database, or add a SQLite database file. You see what will happen first. Nothing changes until you select Import, and it all runs as one step: if anything fails, nothing is kept.
        
            
        
                File
                
        
                    
                    No file chosen (.sql, .csv, .json, .html, .sqlite, .bak; up to 1 GB)
                    
                    
                
        
            
        
            
        
                
                
            
        
            
        
                
        
                    
                    
                    
        
                
        
                
        
                    
                    
                
        
                
        
                    
                    
                
        
            
        
            
            
        
                CSV
                
        
                    
        
                        
                        
                    
        
                    
                
        
            
        
            
            
        
                Table
                
        
                    
        
                        
                        
                        
                    
        
                    
        
                        
                        
                        
                    
        
                
        
            
        
            
        
            
            
            
        
                
                
            
        
        
        
            

    
        
        
            
        Are you sure?
        
            
        
            
        
                
                
            
        
        
        
            

    
        
        
            
        Keyboard shortcuts
        
            
        
                
        KeysAction
        
                
            
        
            
        Everything in the builder is reachable with Tab / Shift+Tab; buttons respond to Enter and Space.
        
            
        
                
            
        
        
        
            

    
        
        
            
            
            
            
            
        ↑ ↓ to move, Enter to run, Esc to close