MySQL

MySQL + Konnectify

MySQL Integration with Konnectify

Connect to your MySQL database in Konnectify to run custom SELECT queries and automate workflows when new rows match your query results.

Queries 1 Trigger 1 Action

ON THIS PAGE

→ What is MySQL? → API & Authentication → How to connect → Triggers (1) → Actions (1) → Popular automations → FAQ

What is MySQL?

MySQL is a popular open-source relational database used to store and query application data with SQL. When you connect MySQL to Konnectify, you can safely run parameterized, read-only queries and use the results to power automated workflows and integrations across your stack.

This is especially useful for syncing data out of operational databases, triggering automations from new records, and generating reports without manual exports.

New to MySQL?

Set up a MySQL server or use a managed MySQL provider before connecting it to Konnectify.

Visit mysql.com

New to Konnectify?

Create a free Konnectify account to build workflows with triggers, actions, and data mapping.

What you can automate

• Trigger workflows from rows returned by a custom SELECT query

• Pull datasets for syncing into CRMs, spreadsheets, or data warehouses

• Generate operational reports on a schedule without manual exports

• Filter events using SQL conditions (status, timestamps, IDs, etc.)

• Enrich records in other apps with fields fetched from MySQL

• Monitor table changes by polling an incrementing cursor column

API & Authentication

Authentication method: Database credentials

This connector uses MySQL database credentials (host, port, username, password, database). Konnectify stores your connection details securely and uses them only to run the configured queries for your workflows.

Supported capabilities

Run custom SELECT queries to fetch data
Use dynamic inputs via {{placeholder}}
Poll for new rows using a cursor-friendly query pattern

Notes & best practices

Prefer indexed cursor columns (e.g., updated_at or auto-increment IDs)
Limit result sets to keep polling fast
Use read-only DB users where possible

Rate limits & access restrictions

MySQL itself does not impose API-style rate limits, but your database server and network may enforce connection limits, timeouts, or resource quotas. For production workloads, use a dedicated read replica or a least-privilege user and coordinate with your DBA/hosting provider.

Reference: MySQL documentation — https://dev.mysql.com/doc/

How to connect MySQL to Konnectify

Prerequisites

MySQL host and port (e.g., 3306) reachable from Konnectify
A MySQL username and password (recommended: read-only user for SELECT queries)
The target database name
Firewall/VPC rules allowing connections (if your DB is private)

Add MySQL to a Workflow

Open your Konnectify Workflow.
Click Add step and choose MySQL.
Select a Trigger or Action depending on your use case.

Authorize via database credentials

Enter your Host, Port, User, Password, and Database.
Save the connection.
If you see connectivity errors, confirm firewall rules and network access.

Configure the Trigger or Action

Write a SELECT statement that returns the fields you need.
Use {{placeholder}} tokens where you want dynamic values from earlier steps.
For triggers, ensure your query supports incremental polling (see the Triggers section below).

Important

Only use read-only SELECT queries. Avoid long-running queries and ensure the queried columns are indexed to prevent workflow delays.

Test the Workflow

Run a test to verify the connection and query output.
Confirm the returned fields match what you plan to map downstream.
If needed, add a LIMIT clause while iterating to speed up tests.

Activate the Workflow

Turn on the workflow.
Monitor the first few runs for query performance and expected results.
Adjust polling/cursor logic if you see duplicates or missed rows.

Triggers 1

MySQL triggers in Konnectify are polling-based. Konnectify periodically runs your query and emits new events based on a cursor so you can process new rows reliably.

Queries 1 triggers

New Row (Custom Query)

Polls your MySQL database with a custom SELECT query.

Cursor tip

Include a monotonically increasing field (e.g., id or updated_at) and filter with > the last seen value to avoid duplicates.

Actions 1

Use MySQL actions to fetch data on-demand during a workflow run. This is ideal for enrichment, validations, and pulling related records by ID.

Queries 1 actions

Get Data (Custom Query)

Executes a custom SELECT query. Use {{placeholder}} for dynamic inputs.

Parameterization tip

Example: SELECT * FROM users WHERE email = '{{email}}' and map {{email}} from a previous step.

Popular automations

Examples of how teams commonly use MySQL with Konnectify. You can add additional steps to send notifications, write to CRMs, or update internal tools.

Sync new signups to downstream systems

Poll your users table for newly created rows and then fetch the full record details for mapping into other apps.

New Row (Custom Query) → Get Data (Custom Query)

Operational reporting on a schedule

Detect new rows that match business rules (e.g., failed payments, pending shipments), then pull related data to include in a report payload.

New Row (Custom Query) → Get Data (Custom Query)

Enrich events with database lookups

When a new row is detected, query additional tables (e.g., accounts, plans, entitlements) using placeholders to enrich the dataset.

New Row (Custom Query) → Get Data (Custom Query)

Data quality monitoring

Poll for rows that violate validation rules (e.g., missing emails, invalid statuses) and then fetch full details for remediation steps.

New Row (Custom Query) → Get Data (Custom Query)

FAQ

How does authentication work for the MySQL connector?

The MySQL integration uses database credentials: Host, Port, User, Password, and Database. For best security, use a dedicated least-privilege user (ideally read-only) and allow network access only from trusted sources.

Which MySQL plans or deployments are supported?

Any MySQL-compatible deployment is supported (self-hosted, cloud VM, or managed services) as long as it is reachable over the network and the provided user can authenticate. Plan limitations typically come from your hosting provider (connection limits, read replicas, VPC access), not from MySQL itself.

How does the “New Row (Custom Query)” trigger work?

It is a polling trigger. On each poll interval, Konnectify runs your SELECT query and uses a cursor (for example, the largest seen id or latest updated_at) to determine what’s new since the previous run. To improve reliability, ensure your query includes an ordered, incrementing field and a filter condition based on the last cursor value.

How do I prevent duplicate rows from being processed?

Use a stable cursor strategy: filter rows strictly greater than the last seen cursor value and order by that cursor field. For example, if you use an auto-increment ID: WHERE id > {{last_id}} ORDER BY id ASC. Also avoid queries that can return the same row with different joins unless your cursor accounts for it.

How does Konnectify handle rate limits or database overload?

If your DB returns transient errors (timeouts, too many connections), reduce query cost (add indexes, LIMIT, narrower WHERE clauses), increase server capacity, or use a read replica. Konnectify workflow runs may retry depending on your workflow settings and error type; ensure your trigger cursor is idempotent so retries don’t cause duplicates.

Can I connect multiple MySQL databases or environments?

Yes. Create separate connections for each host/database (for example, production vs staging, or multiple tenants). Then select the correct connection in each workflow step.

What network settings are required to connect to a private MySQL instance?

Your database must be reachable from Konnectify. For private networks, this usually means configuring firewall/VPC rules, allowing inbound traffic on port 3306, and ensuring DNS resolves correctly. Work with your network/DBA team to establish secure connectivity (for example, IP allowlisting or a private networking setup if available).

Ready to automate your MySQL workflows?

Connect MySQL to Konnectify and turn query results into reliable, repeatable automations.

Get started free →