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

Total users

Monthly users

Runs succeeded

>99%

Last modified

2 years ago

Developer tools

SQL Query Actor (PoC)

Actor for performing SQL queries over Apify platform.

Example for selecting aggregated information from dataset:

SELECT
   country, city, COUNT(*) as amount
FROM
   `jepxmCkXTBG5buxxx` -- id of Dataset
GROUP BY
   country, city
SORT BY
   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.

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

4.6

PGVector Integration

apify/pgvector-integration

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

Apify

4.6

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

5.0

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

144

Apify TV (BETA)

jupri/apify-tv

Scrape and download video from all over internet

cat

Apify Scraper

dz_omar/apify-scraper

Extract actor data from the Apify Store, including pricing, stats, and user info. Supports multiple queries, filters, and crash-safe state persistence. 🧑‍💻 Open-source and ideal for research, analysis, and discovering tools.

Abdlhakim hefaia

5.0

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

114

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.