VOOZH about

URL: https://apify.com/petr_cermak/mysql-insert

⇱ MySQL Insert · Apify

Pricing

Pay per usage

Go to Apify Store

MySQL Insert

This act takes a crawler execution and inserts it's results into a remote MySQL database.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

👁 Petr Cermak

Petr Cermak

Maintained by Community

Actor stats

1

Bookmarked

44

Total users

1

Monthly active users

3 years ago

Last modified

Share

mysql-insert

Apify actor for inserting crawler results into a remote MySQL table.

This actor fetches all results from a specified dataset (or as raw data) and inserts them into a table in a remote MySQL database.

Input

Input is a JSON object with the following properties:

{
 "datasetId": "your_dataset_id",
 "connection": {
 "host" : "host_name",
 "user" : "user_name",
 "password" : "user_password",
 "database" : "database_name", // optional
 "port" : 3306 // optional
 },
 "table": "table_name",
 // Optionally, you can add raw data instead of datasetId
 "rows": [
 {"column_1": "value_1", "column_2": "value_2"},
 {"column_1": "value_3", "column_2": "value_4"}
 ]
}

Webhooks

Very often you want to run an image mysql-insert update after every run of your scraping/automation actor. Webhooks are solution for this. The default datasetId will be passed automatically to the this actor's run so you don't need to set it up in the payload template (internally the actor transforms the resource.defaultDatasetId from the webhook into just datasetId for its own input).

I strongly recommend to create a task from this actor with predefined input that will not change in every run - the only changing part is usually datasetId. You will not need to fill up the payload template and your webhook URL will then look like: https://api.apify.com/v2/actor-tasks/<YOUR-TASK-ID>/runs?token=<YOUR_API_TOKEN>

You might also like

MySQL Database Extractor

parseforge/mysql-database-extractor

Extract a full MySQL database into Apify storage using either a connection string or individual parameters. Supports table filtering and flexible output formats, enabling automated export of all rows and metadata for smooth integration with other Actors, pipelines, or workflows.

2

5.0

AI Data Bridge: Multi-Database Connector

the.beast/ai-data-bridge

Stop juggling 7 different database tools. AI DataBridge connects PostgreSQL, MySQL, MongoDB, Airtable, Notion, and Google Sheets through a single MCP interface. Ask questions in plain English—get answers from any database instantly. AI database connector, multi-database integration

1

5.0

Database MCP Server

constant_quadruped/database-mcp-server

MCP Server for AI database access. Connect to PostgreSQL, MySQL, or SQLite. Query data, inspect schemas, list tables, describe columns, view indexes and foreign keys. 11 tools for complete database intelligence. Works with Claude Desktop and any MCP client.

Datasets Compare

petr_cermak/datasets-compare

Act for comparing crawler execution results. By default the final result set will contain only new and updated records.

👁 User avatar

Petr Cermak

23

Database Schema Explorer

balathon/database-schema-explorer

This Apify Actor connects to various types of databases (SQLite, PostgreSQL, MySQL, Oracle, Microsoft SQL Server), explores their schemas, provides detailed information about tables and columns, shows row counts, and optionally reads sample data.

👁 User avatar

Balasai Sigireddy

2

Ofsted Providers Companies House Enrichment

alkausari_mujahid/ofsted-providers-companies-house-enrichment

Syncs UK Ofsted provider names from a configurable source table, matches each one against Companies House using fuzzy search, and stores verified company profiles, registered addresses, and active directors back into your MySQL or Supabase database — automatically skipping duplicates and aliases.

👁 User avatar

Alkausari M

3

Related articles

Python asyncio tutorial with 3 examples
Read more
AI data collection (how to feed your LLM)
Read more