Connect MySQL to Beehiiv

Execute a custom MySQL query. See our docs to learn more about working with SQL in Mazaal AI.

Adds a new row. See the docs here

Delete an existing row. See the docs here

Find row(s) via a custom query. See the docs here

Execute Stored Procedure. See the docs here

Finds a row in a table via a lookup column. See the docs here

Retrieves available options for the Stored Procedure field.

Retrieves available options for the Table field.

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Updates an existing row. See the docs here

Create a new subscriber for a publication. Use **List Custom Fields** to discover available custom field names before passing customFields. Use **Get Publication Info** to get the publication ID. Set reactivateExisting: true to re-subscribe someone who previously unsubscribed. See the documentation

Create a new post (newsletter draft). Pass HTML content in the content parameter. The post is created as a draft by default — set status: "confirmed" to publish immediately. Use content tags to categorize the post. Use **Get Publication Info** to get the publication ID. See the documentation

Create a new subscriber. See docs

Get aggregated analytics across all posts — open rates, click rates, unsubscribes, etc. Filter by audience (free/premium), platform (web/email), or content tags. Returns metrics: recipients, delivered, opens, unique_opens, open_rate, clicks, unique_clicks, click_rate, unsubscribes, spam_reports. Use **List Posts** to see individual post details. Use **Get Publication Info** to get the publication ID. See the documentation

Get details about the current beehiiv publication, including name, URL, and subscriber stats. **Call this first** to get the publicationId needed by all other tools. If you have multiple publications, pass the publicationId — otherwise the first publication is returned. Returns the publication name, description, URL, creation date, and subscriber count. See the documentation

Get full details for a single subscriber by ID or email. Use expand to include stats (open/click rates), custom field values, or referral data. Either subscriptionId or email must be provided. Use **Search Subscribers** to find subscriber IDs. Use **Get Publication Info** to get the publication ID. See the documentation

Get a list of all your publications. See docs

Schema discovery — list all custom fields defined for subscribers in a publication. Use this before **Create Subscriber** or **Update Subscriber** to know what custom fields are available and their expected types. Use **Get Publication Info** to get the publication ID. See the documentation

List posts (newsletter issues) for a publication. Filter by status, audience, platform, or content tags. Returns post titles, dates, status, and URLs. Use **Get Publication Info** to get the publication ID. Use **Get Post Analytics** for aggregate performance metrics across posts. See the documentation

List subscriber segments for a publication. Segments are pre-defined subscriber groups (dynamic rules, static lists, or manual selections). Use this for discovery — to understand how subscribers are organized. Use **Get Publication Info** to get the publication ID. See the documentation

Search and filter subscribers for a publication. Use email for exact email lookup, or combine status and tier filters to narrow results. Use **Get Publication Info** to get the publication ID. For full details on a single subscriber (with stats, custom fields, referrals), use **Get Subscriber** instead. Use **List Custom Fields** to discover available custom field names. See the documentation

Update an existing subscriber's fields or unsubscribe them. Use **Search Subscribers** or **Get Subscriber** to find the subscription ID first. Use **List Custom Fields** to discover available custom field names. Set unsubscribe: true to unsubscribe the subscriber. Use **Get Publication Info** to get the publication ID. See the documentation