SQL Query

Pricing

Pay per usage

Try for free

Go to Apify Store

SQL Query

Try for free

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

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Useful tools

Maintained by Community

Actor stats

Bookmarked

Total users

Monthly active users

2 years ago

Last modified

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.7

Natural Language Dataset Query

apify/natural-language-dataset-query

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. It works as an MCP (Model Context Protocol) server or REST API in Actor standby mode.

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

PGVector Integration

apify/pgvector-integration

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

Apify

4.6

Storage Tools

marco.gullo/storage-tools

Query storages on the Apify platform.

Marco Gullo

🔥 Power Data Transformer

wiseek/power-data-transformer

🔥 Unlock your scraped data—clean, merge, split, deduplicate, filter, standardize, validate, enrich and sync—using built-in transformations and powerful SQL pipelines for ETL/ELT workflows. Seamlessly integrate processed datasets with automation platforms like n8n, Make.com, and Zapier.

wiseek

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

176

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

Actor 2 Dataset Cleaner and Formatter

motivational_nickel/dataset-cleaner-and-formatter

Automatically cleans and formats datasets by trimming whitespace, fixing capitalization, and removing duplicates. Supports both Apify datasets and uploaded JSON/CSV files.

Leoncio Jr Coronado

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).