Pricing

Pay per usage

Go to Store

SQL Query

Try for free

Developed by

Useful tools

Run SQL queries over Apify Platform (currently supports only Datasets).

0.0 (0)

Pricing

Pay per usage

Monthly users

Runs succeeded

>99%

Last modified

a year ago

Developer tools

SQL Query Actor (PoC)

Actor for performing SQL queries over Apify platform.

Example for selecting aggregated information from dataset:

1SELECT
2   country, city, COUNT(*) as amount
3FROM
4   `jepxmCkXTBG5buxxx` -- id of Dataset
5GROUP BY
6   country, city
7SORT BY
8   country ASC, city ASC

Results are stored in to default Dataset of the run.

TODO:

load table optimizations - only used fields + parallel the loading.
Better Data-type determination (date, numbers, integers, etc...).
implement system tables - to be able to select Runs based on actors etc.
migrate to PostgreSQL - to be able to run PL/pgSQL scripts.

Pricing

Pricing model

Pay per usage

This Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.

Dataset Query Engine

jiri.spilka/dataset-query-engine

Use natural language queries to retrieve results from an Apify dataset. This Actor provides a query engine that loads a dataset, executes SQL queries, and synthesizes results.

Jiří Spilka

PGVector Integration

apify/pgvector-integration

This integration transfers data from Apify Actors to a Postgres SQL database (with PGVector extension).

Apify

Microsoft SQL Server Insert

petr_cermak/MSSQL-insert

This actor takes a crawler execution and inserts its results into a remote MSSQL database.

Petr Cermak

Backup MySQL Database - Google drive Integration

worldunboxer/backup-mysql-database

Effortlessly back up your MySQL database with our Apify actor. It securely connects to your database, generates full SQL backups, and stores them on Google Drive, FTP servers, or Apify Key-Value Store. Ensure data safety with seamless storage and sharing options tailored to your needs.

Umesh Patidar

Diff Datasets

pocesar/diff-datasets

Take one dataset on Apify platform, compare it to another, and output the missing ones. This can also be used to output only changed items, using a compound key

Paulo Cesar

Scrape Emails And Social Media Links With Just a Query

lead.gen.labs/scrape-emails-and-social-media-links-with-just-a-query

Get Emails And Social Media Links With Just a Query !!!!! The actor will take a query and some parameter as input and scrape contact details with just a query. ACTOR IS FREE FOR LIMITED TIME.

LeadGen Labs

140

Apify TV (BETA)

jupri/apify-tv

Scrape and download video from all over internet

cat

Query RSS Feeds

xiaopanai/Apify-RSS-Search

Run keyword queries on custom list of RSS feeds to find the contents that you want. Uses fuzzy logic to match the query to the contents and also applies a recency adjustment (higher penalty for older entries).

Xiaopan AI

106

Tracking Events

shareze001/tracking-events

Retrieve tracking information (including date, address, description, etc.), ETA date, and delivery status. Currently supports tracking for UPS, Passport, DHL.