MySQL IP Intelligence Report with Abstract API

Fetch recently active users and their recorded IP addresses from MySQL, inspect public IPs through Abstract API, and download a CSV risk report.

Use this template Browse all templates

Workflow preview

Drag to pan, click a step to center it, or use the controls to fit and zoom.

Loading workflow preview…
  1. Manual run
  2. Fetch recent user IP rows from MySQL
  3. Inspect unique public IPs through Abstract API
  4. Create an Excel-compatible CSV report
  5. Download report from the completed run
Read-only preview Loading preview…

What this workflow does

Fetch recently active users and their recorded IP addresses from MySQL, inspect public IPs through Abstract API, and download a CSV risk report. Produce an Excel-compatible IP intelligence report that preserves every selected row and clearly separates safe, review, risky, and skipped addresses.

Trigger
IP intelligence report started Run manually with a deliberately small batch first. The workflow reads user rows and sends only each unique public IP address to Abstract API.
Primary output
Inspect user IP list 3 configured workflow actions

Template details

Category

Data Automation

Workflow includes
Best for

Operators, security teams, and product owners reviewing recent user access patterns without modifying the source database

Before you use it

The template will guide you through these setup items in the workflow builder.

  1. 1 Connect MySQL with a read-only database user
  2. 2 Connect the Abstract API IP Intelligence service
  3. 3 Review the starter query and map your user, activity, and IP columns
  4. 4 Run the included scenario with 25 addresses
  5. 5 Open the completed run or builder test result and download the CSV report

Related templates

Browse templates

MySQL Newsletter Subscribers to Brevo List Sync

Fetch verified newsletter opt-ins from MySQL, pause for human review, and queue a bulk Brevo import into a required contact list.

MySQL Email Deliverability Report with Abstract API

Fetch user email addresses from MySQL, validate deliverability through Abstract API, and download a CSV report separating valid, review, and invalid results.

MySQL Phone Intelligence Report with Abstract API

Fetch contact phone numbers from MySQL, inspect validity, carrier, location, and risk signals through Abstract API, and download a CSV report.