Super Simple Free Query Builder

-- Your SQL will appear here

How to Use EasyQuery

Build powerful SQL queries visually—no live database connection required. Follow these steps to create and copy your query:

1. Add Your Tables – Click + Add Table, type the table name (e.g., suitecrm.prospects) and give it an alias such as p. Need more than one? Add as many as you like.

   
   

2. Build Your SELECT List – Under Select Fields & Conversions, add columns or expressions. You can type a field (like p.id), a function (COUNT(*)), or even an inline conversion (CAST(price AS DECIMAL(10,2))). Use the alias box to name your output column.

   
   

3. Create Joins – Use + Add Join to pull in related tables. Pick the join type (LEFT, INNER, etc.), specify the right table and alias, and fill in the ON condition (e.g., p.id = c.id_c).

   
   

4. Add WHERE Conditions – Choose the field, operator, and value. Need to filter by a long list of IDs or emails? Paste them into the IN clause box below and click Apply to Last Condition. You can also insert raw SQL using :raw(...) for full flexibility.

   
   

5. Group, Filter, and Sort – Use GROUP BY & HAVING to aggregate and filter aggregated results. Use ORDER & LIMIT to sort and control output size.

   
   

6. Generate and Copy – Hit Generate SQL to see your query instantly. When it looks right, click Copy SQL and paste it into your MySQL client, SuiteCRM console, or reporting tool.

   
   

More Free Data Management and CRM Tools Await

If you enjoyed using EasyQuery Lite, you’ll love the other free tools and in-depth guides we’ve created to help you keep your CRM clean and powerful:

• Free Deduplication Software – merge duplicate records and save hours of cleanup time.

  
  

• SuiteCRM Review – see why SuiteCRM remains a top open-source choice for growing businesses.

  
  

• CRM Data Cleansing – learn proven methods to keep your database accurate and ready for automation.

  
  

Explore these resources to supercharge your data operations and build a CRM that truly runs itself.