Query Builder for Listmonk

Build Listmonk subscriber SQL queries in one click — segment by email, list, status, campaign engagement, and signup date.

Stop hand-writing SQL every time you need to segment subscribers in Listmonk. Query Builder for Listmonk turns emails, list names, and common segmentation patterns into ready-to-paste Listmonk query expressions - in one click. Paste a batch of email addresses or list names and the extension instantly generates the correct subscriber query. Or use one of 14 built-in presets covering the segments marketers actually use every day. WHAT YOU CAN BUILD Email lookups - paste comma- or newline-separated emails, get a clean IN (...) query List targeting - query subscribers by list name, combined with emails when needed Status segments - enabled and blocklisted subscribers Date segments - subscribed in the last 7, 30, or 90 days, or older than 1 year Engagement segments - opened any campaign, clicked any link, never opened, opened in the last 30 days List membership - in no lists, confirmed, unconfirmed, or unsubscribed from a list WHY YOU'LL LIKE IT One-click copy - every preset and generated query copies straight to your clipboard Safe SQL - single quotes in emails and list names are escaped automatically Zero setup - no login, no API key, no permissions; works entirely offline in the popup Built for the official Listmonk query syntax (subscribers, subscriber_lists, campaign_views, link_clicks) PRIVACY This extension requests no permissions and collects no data. Everything you type stays in the popup and is never transmitted anywhere. Query Builder for Listmonk is an independent, third-party companion tool built by an individual developer. It is not affiliated with, endorsed by, or sponsored by the Listmonk project or its maintainers. "Listmonk" refers to the open-source newsletter manager; the name is used only to describe compatibility.