See llms.txt for all machine-readable content.

MySQL and OpenCTI integration

Save yourself the work of writing custom integrations for MySQL and OpenCTI and use n8n instead. Build adaptable and scalable Development, Data & Storage, workflows that work with your technology stack. All within a building experience you will love.

Get Started See n8n in action

How to connect MySQL and OpenCTI

Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

MySQL and OpenCTI integration: Create a new workflow and add the first step

Parse DMARC reports, save them in database and notify on DKIM or SPF error

Who is it for If you are a postmaster or you manage email server, you can set up DKIM and SPF records to ensure that spoofing your email address is hard. On your domain you can also set up DMARC record to receive XML reports from email providers (rua tag). Those reports contain data if email they received passed DKIM and SPF verifications. Since DMARC email is public, you will receive a lot of emails from email providers, not only if DKIM/SPF fail. There is no need for it - you probably only need to know if SPF/DKIM failed. So this script is intended to automatically parse all DMARC reports that come from email providers, but ONLY send you notification if SPF or DKIM failed - meaning that either someone tries to spoof your email or your DKIM/SPF is improperly set up. How it works script monitors postmaster email for DMARC reprots (rua) unpacks report and parses XML into JSON maps JSON and formats fields for MySQL/MariaDB input inputs into database sends notification on DKIM or SPF failure Remember to set up email input mailbox notification channels for slack for email

Get started with this workflow

Popular ways to use the MySQL and OpenCTI integration

Parse DMARC reports, save them in database and notify on DKIM or SPF error

Score DNS threats with VirusTotal, Abuse.ch, HashiCorp Vault and Gemini

Build your own MySQL and OpenCTI integration

Create custom MySQL and OpenCTI workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

MySQL supported actions

Supported methods for OpenCTI

Delete
Get
Head
Options
Patch
Post
Put

To set up OpenCTI integration, add the HTTP Request node to your workflow canvas and authenticate it using a predefined credential type. This allows you to perform custom operations, without additional authentication setup. The HTTP Request node makes custom API calls to OpenCTI to query the data you need using the URLs you provide.

Requires additional credentials set up

Use n8n's HTTP Request node with a predefined or generic credential type to make custom API calls.

MySQL and OpenCTI integration details

MySQL

MySQL

The relational database management system MySQL is free and open-source. Although MySQL includes standalone clients that let users communicate with a MySQL database directly using SQL, it is more frequently used in conjunction with other applications to develop applications that require relational database functionality.

Related categories

OpenCTI

OpenCTI

OpenCTI is an open-source platform designed for cyber threat intelligence management. It facilitates the collection, analysis, and sharing of threat intelligence data, helping organizations proactively defend against cyber threats by providing insights into vulnerabilities, indicators of compromise, and attacker tactics.

Related categories

Other integrations with MySQL and OpenCTI

With MySQL

The SOAR platform you want

Mountains of monotonous tasks make building and monitoring your workflows a chore. Not anymore.

Learn more

Save engineering resources

Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.

Learn more

MySQL and OpenCTI integration tutorials

FAQ about MySQL integrations

Need help setting up your MySQL and OpenCTI integration?

Discover our latest community's recommendations and join the discussions about MySQL and OpenCTI integration.

  • Mohammadali

    Using variables

    Mohammadali

    Hi guys. I am getting certain data from my SQL database. I want to pass that data to an API. The data I get from the database contains this variable: {{ $input.item }} the problem is that I can not send the value of…

    Open topic
  • Michael Zareno

    MySQL Select and numbers

    Michael Zareno

    I have a MySQL table. Test data consists of an "Amount’ field, and three rows with values, 1000, My JSON input is: [ { "row_number": 2, "Amount": -1000 }, { "row_number": 3, "Amount": -52.23 }, …

    Open topic
  • Shazim Ali

    Pass dynamic perameters to postgres_SQL node query

    Shazim Ali

    hi i am new to n8n basically i have build a chat bot, which is created query on the base of question, but sometime AI based queries are failed to give accurate result, so i have created sql function in vector database, t…

    Open topic
  • Neal A Richardson Sr

    Migration error on fresh deployment of 1.45.2 in kubernetes

    Neal A Richardson Sr

    Describe the problem/error/question I’m trying to spin up an n8n instance in kubernetes as a fresh install. I have a database created and the connection works (it created 22 tables) but then the docker container bombs o…

    Open topic
  • GabrielBackend

    MySql node - Inserting NULL in MariaDB

    GabrielBackend

    Greetings, I’m trying to insert null values into my MariaDB using MySQL node. I need to use Execute SQL mode so I can call functions inside my db and do verifications in case of a update, for example IFNULL. There is n…

    Open topic

Looking to integrate Slack and VirusTotal in your company?

Contact Sales

Trusted by teams building smarter workflows

Why

Why use n8n to integrate MySQL with OpenCTI

Handle branching, merging and iteration easily. Pause your workflow to wait for external events.

Re-run single steps to test changes in no time. And pin your data to avoid generating trigger events every time you execute.

Your data is displayed alongside your settings, making edge cases easy to track down.

Use 1000+ workflow templates available from our core team and our community.

Copy and paste, easily import and export workflows.

  • n8n makes complex workflows easy to build, and versatile enough for me to add my own 'secret sauce.'

    Danny Melamed

  • I have found the holy grail of automation.

    Luisa Vidal

  • n8n’s integration with third-party services is absolutely mind-blowing. It’s like a Swiss army knife for automation.

    Felix Leber

  • n8n is the tool that turns 'I have an idea' into 'it's running in production' faster than anything else.

    Ric Neves

  • Anything is possible with n8n. I think the cloud version is great, they are doing amazing stuff.

    Robyn Tindall

  • n8n’s integration with third-party services is absolutely mind-blowing. It’s like a Swiss army knife for automation.

    Nanbing

  • Thank you to the n8n community. I did the beginners course and promptly took an automation WAY beyond my skill level.

    Charley Mann

  • I love the flexibility of n8n and how it lets different applications work together in a single workflow.

    Ray Fourie

  • n8n is the glue that holds many of our systems together.

    Paul Cook

  • I can move fast, go deep when things get complex, and never feel boxed in.

    Ali Mazloum

Simple enough to 
understand + sophisticated 
enough to ship

Start building