Easily use custom SQL queries in your segments and campaigns.

​
What does this plugin do?

The Unlimited SQL plugin lets you:
  • Add custom SQL filters to segments (Segment Filter)
  • Run SQL queries as campaign actions (Campaign Action)
  • Use SQL queries as campaign conditions (Campaign Condition)
  • Test your SQL queries directly in the Mautic UI before using them
You can use placeholders like :contactId, :campaignId, and :eventId in your queries. The plugin will safely replace them with the right values for each contact or campaign step.

​
Features

  • Segment Filter: Add contacts to segments based on your own SQL logic.
    Example: Only include contacts with more than 5 page hits.
  • Campaign Action: Run a SQL query for every contact that reaches a campaign step.
    Example: Update an external CRM table when a contact hits a step.
  • Campaign Condition: Branch your campaign based on the result of a SQL query for a contact.
    Example: Check if a contact is in a VIP table and send them down a special path.
  • Testing Area: Select a contact and test your SQL query before saving.
See also: SQL Query Examples

​
How it works

  1. Create an SQL Entry
    Go to Unlimited SQL in the Mautic menu and create a new entry. Choose the type (Segment Filter, Campaign Action, or Campaign Condition), write your SQL, and save.
  2. Test your query
    Use the built-in testing area to select a contact and see if your query works as expected.
  3. Use in Segments or Campaigns
    • For segments: Add a filter of type “Unlimited SQL Filters” and select your SQL entry.
    • For campaigns: Add an action or condition and select your SQL entry.
Tip: Always use placeholders (:contactId, etc.) for security. The plugin will handle safe parameter binding.