utils logo UTILS
Free online tools to generate, calculate,
convert, format, encode, and play.
 

SQL Query Builder

Build SQL queries visually. Select your query type, define tables, columns, and conditions — the SQL is generated instantly.

Query Type

FROM — Table
SELECT — Columns
JOIN (optional)
WHERE (optional)
GROUP BY (optional)
HAVING (optional)
ORDER BY (optional)
LIMIT
OFFSET
INTO — Table
Columns & Values
Table
SET — Assignments
WHERE (optional)
FROM — Table
WHERE (optional)
The SQL updates as you type.

Generated SQL

Your SQL query will appear here...

How It Works

Features
  • Visual Interface: Build queries by filling in fields rather than writing raw SQL syntax
  • Four Query Types: Supports SELECT, INSERT, UPDATE, and DELETE statements
  • JOIN Support: Add INNER, LEFT, RIGHT, FULL OUTER, and CROSS joins with conditions
  • WHERE Clauses: Chain multiple conditions with AND/OR operators and common comparison operators
  • Aggregation: GROUP BY and HAVING support for aggregate queries
  • Sorting & Pagination: ORDER BY with ASC/DESC, LIMIT and OFFSET
  • Syntax Highlighting: Color-coded output for better readability
  • Instant Generation: SQL updates in real time as you modify fields
Supported Query Types
SELECT
  • Choose columns (or * for all)
  • Specify table with optional alias
  • Add JOINs to related tables
  • Filter with WHERE conditions
  • GROUP BY / HAVING for aggregation
  • ORDER BY for sorting
  • LIMIT / OFFSET for pagination
INSERT / UPDATE / DELETE
  • INSERT: Specify columns and values to insert into a table
  • UPDATE: Set column values with optional WHERE filter
  • DELETE: Remove rows from a table with optional WHERE filter
  • Values are auto-quoted for strings, left unquoted for numbers and expressions
Tips
  • Use the Load Example button to see a pre-filled query
  • All processing is client-side — no data is sent to any server
  • Numeric values and SQL expressions (e.g. NOW(), NULL) are not quoted
  • String values are automatically wrapped in single quotes

Embed This Util

You can embed this util on your own site as a widget. Adding ?embed=1 to the URL loads a compact version with just the tool itself; no header, menu, or documentation. Paste this snippet into your HTML: 


    

       Copy snippet
      Adjust the height to taste.
    

  




  


  

    
 Related Utils

    

      

        
           SQL Beautifier
        
        
           JSON to CSV
        
        
           CSV to JSON
        
        
           JSON Formatter
        
      

    

  


          

          

          

              Feedback
          

          

            

              Help us improve this page by providing feedback,
              and include your name/email if you want us to reach back. Thank you in advance.
            

            

              
              

              
            

          

          
          
          
          

          

            Share with