Generate a CSV full of random data

Learn how to generate a CSV file full of random data using Anyquery.

Convert a CSV file to JSON

Learn how to convert a CSV file to a JSON file using Anyquery.

Export a SQLite database to HTML

Learn how to export a SQLite database to an HTML file using Anyquery.

How to bulk delete data in a Notion database?

Learn how to bulk delete data in a Notion database using Anyquery. Follow steps to install, set up, and execute efficient SQL queries for data management.

How to bulk edit data in a Notion database?

Learn how to bulk edit data in a Notion database using Anyquery. Follow these steps to configure the Notion plugin, query data, back up, and perform various bulk edits.

How to bulk insert data into a Notion database?

Learn to bulk insert data into a Notion database using Anyquery. This step-by-step guide covers data preparation, reading from CSV, SQL queries, and verification.

How to close my brave tabs matching a specific URL?

Learn how to close Brave Browser tabs matching a specific URL using Anyquery's SQL query engine. Follow simple steps to install the plugin and execute queries.

How to convert a CSV file to a JSON file?

Learn to convert CSV to JSON using Anyquery. Follow steps to query CSV files, export results to JSON, modify columns, and handle errors effectively.

How to convert a CSV file to a SQLite database?

Learn to convert CSV files to a SQLite database using Anyquery. Follow steps to query CSV data, create SQLite tables, verify data, and handle large or remote files efficiently.

How to create brave tabs using a JSON file?

Learn how to automate creating new tabs in Brave using Anyquery by reading a JSON file. Follow the steps to install the plugin, create a JSON file, and execute SQL queries.

How to export a Notion database to a CSV file?

Learn how to export your Notion database to a CSV file using Anyquery. Follow step-by-step instructions from setting up Notion integration to running SQL queries.

How to export a Notion database to a JSON file?

Learn how to export a Notion database to a JSON file using Anyquery. This step-by-step guide covers installation, querying, and exporting data efficiently.

How to export a SQLite database to a CSV file?

Learn to export data from a SQLite database to a CSV file using Anyquery. This guide covers installation, connecting to the database, running export queries, and verifying output.

How to export emails from a Gmail account to a CSV file?

Learn to export Gmail emails to a CSV file using Anyquery with an IMAP plugin. Follow step-by-step instructions to configure, query, and export your data effortlessly.

How to export emails from a Gmail account to a JSON file?

Learn how to export emails from your Gmail account to a JSON file using Anyquery. Follow steps to install the IMAP plugin, create application passwords, and run SQL queries.

How to export emails from a Gmail account to a SQLite database?

Learn how to export Gmail emails to a SQLite database using Anyquery. This guide covers prerequisites, setting up an IMAP profile, querying emails, and exporting data.

How to export emails from an Outlook account to a CSV file?

Learn how to seamlessly export emails from your Outlook account to a CSV file using Anyquery, covering installation, setting up profiles, and executing SQL queries.

How to export emails from an Outlook account to a JSON file?

Learn to export emails from an Outlook account to a JSON file using Anyquery. Follow steps to create an app password, install the IMAP plugin, query, and export emails.

How to export emails from an Outlook account to a SQLite database?

Learn how to export emails from Outlook to a SQLite database using Anyquery. Follow steps to set up IMAP, create a profile, and verify the export effortlessly.

How to export my Apple Notes to a CSV file?

Export your Apple Notes to a CSV file using Anyquery's SQL query engine. Install the Apple Notes plugin, run SQL queries, and export your notes effortlessly.

How to export my GitHub stars to JSON?

Export your GitHub stars to JSON using Anyquery. Install the GitHub plugin, run the provided SQL query, and verify the export in the `github_stars.json` file.

How to export my Google Sheets to a JSON file?

Learn to export Google Sheets data to a JSON file using Anyquery. Follow steps to install the plugin, find your Spreadsheet ID, query data, and export it to JSON.

How to filter a CSV file by a column value?

Learn how to filter a CSV file by a specific column value using Anyquery. Follow step-by-step instructions to query, filter, and optionally export your data.

How to filter an HTML table using SQL?

Learn to filter HTML tables using Anyquery's SQL query engine. This tutorial covers prerequisites, querying steps, and exporting results to JSON for easy data handling.

How to filter my docker containers list?

Learn how to filter your Docker containers list using Anyquery SQL engine. This tutorial covers filtering by status, name, image, size, and more advanced scenarios.

How to get the count of containers per image?

Learn how to use Anyquery to get the count of Docker containers per image with a simple SQL query. Follow step-by-step instructions to set up and run your query.

How to get the files matching a specific pattern in a directory?

Learn how to use Anyquery to find files matching specific patterns in a directory. Install the `file` plugin, run `file_search` queries, and export results to CSV or JSON.

How to get the files modified in the last 24 hours in a directory and subdirectories matching a specific pattern?

Learn to find files modified in the last 24 hours using Anyquery. This guide covers installation, setup, and querying techniques to filter files based on patterns and modification time.

How to get the files modified in the last 24 hours in a directory?

Learn to identify files modified in the last 24 hours in a directory using Anyquery. Follow step-by-step instructions to filter, run queries, and export results to JSON or CSV.

How to get the newest docker container?

Learn how to use Anyquery to retrieve, filter, and export the newest Docker container by querying the `docker_containers` table. Step-by-step guide included.

How to get the number of tabs open in brave matching a specific URL?

Learn how to use Anyquery to find the number of open Brave browser tabs matching a specific URL with a simple SQL query. Perfect for effective tab management.

How to get the number of tabs open in brave?

Learn how to use Anyquery to get the number of tabs open in Brave with simple SQL commands. Follow steps to install the Brave plugin, connect, and run queries easily.

How to get the oldest docker container?

Learn how to use Anyquery's SQL engine to find the oldest Docker container by listing and sorting containers based on their creation time. Follow the step-by-step guide.

How to import a CSV file into a Notion database?

Learn to import CSV files into Notion databases using Anyquery. Get prerequisites, install plugins, set up schemas, and execute SQL commands for seamless data transfer.

How to import a JSON file into a Notion database?

Learn to import JSON into a Notion database using Anyquery. Set up the connection, read JSON, create a virtual table, and insert data into Notion seamlessly.

How to import a Parquet file into a Notion database?

Learn to import a Parquet file into a Notion database using Anyquery. Follow a step-by-step guide to create a Notion table and execute SQL queries for seamless data integration.

How to import a SQLite database into a Notion database?

Learn how to import a SQLite database into Notion using Anyquery. This guide covers setting up Notion plugin, exporting data from SQLite, and importing it into Notion.

How to join two CSV files?

Learn how to join two CSV files using Anyquery's SQL capabilities, including reading files, creating virtual tables, filtering data, and exporting results.

How to list my completed reminders on macOS?

Learn how to list completed reminders on macOS using Anyquery. Install the Reminders plugin, run an SQL query, and export results in CSV or JSON formats.

How to list the biggest docker images?

Learn to list the biggest Docker images using Anyquery. Follow a step-by-step guide to run SQL queries, sort images by size, and filter based on repository tags.

How to list the newest branches in a git repository?

Learn to list the newest branches in a git repository using Anyquery. Follow steps to install the git plugin, run SQL queries, and export results to CSV.

How to list the oldest branches in a git repository?

Learn how to list the oldest branches in a Git repository using Anyquery. This tutorial covers prerequisites, installation, and SQL queries for both local and remote repos.

How to list the stargazers of a GitHub repository?

Learn how to list GitHub repository stargazers using Anyquery's GitHub plugin. Follow steps to install, configure, and run SQL queries for detailed insights.

How to query a Google Sheet using SQL?

Learn to set up Anyquery, connect it to Google Sheets, and execute SQL queries on your data. Follow detailed steps for installation, authentication, and querying.

How to query Apache logs using SQL?

Learn to query Apache logs with SQL using Anyquery. This guide covers identifying log formats, using Grok patterns, filtering data, and exporting results.

How to query Kubernetes logs using SQL?

Learn to query Kubernetes logs using SQL with Anyquery, utilizing Grok patterns and the `read_log` function for structured data extraction and effective log analysis.

How to query Nginx logs using SQL?

Learn to query Nginx logs using SQL with Anyquery. Understand `grok` patterns, filter and analyze data, and export results to formats like CSV. Full guide included.

How to run SQL queries on a Notion database?

Learn to run SQL queries on Notion databases using Anyquery. This tutorial covers plugin installation, API key setup, database ID retrieval, and executing CRUD operations.

How to run SQL queries on Airtable?

Learn to run SQL queries on Airtable using Anyquery. This guide covers installation, API key retrieval, configuration, and executing basic SQL commands on Airtable data.

How to see the GitHub stars obtained per day for a repository?

Learn to use Anyquery to track GitHub stars per day for a repository with simple SQL queries. This guide covers installation, setup, and example queries.

How to see who the biggest committers are of a Git repository?

Analyze Git commit data with Anyquery. Learn to set up connections, run SQL queries to identify top committers, and visualize data using tools like Metabase.

How to transfer my GitHub stars to an Airtable table?

Learn to transfer starred GitHub repositories to an Airtable table using Anyquery. This tutorial covers prerequisites, plugin configuration, and the SQL query needed for data transfer.

How to update my brave tabs matching a specific URL?

Learn to update Brave browser tabs matching a specific URL using Anyquery. Follow steps to install the Brave plugin, query tabs, and update URLs with SQL commands.

How to use PQL to query a SQLite database?

Learn to use PQL with Anyquery to query a SQLite database. Set up Anyquery, enable PQL, and run various queries like filtering, sorting, and aggregating data efficiently.

How to use PRQL to query a SQLite database?

Learn how to use PRQL with Anyquery for querying SQLite databases, offering readable syntax and intuitive data manipulation. Includes setup, examples, and exporting results.

How to visualize a Google Sheets spreadsheet in Looker Studio(formerly Google Data Studio)?

Learn to visualize Google Sheets data in Looker Studio using Anyquery. Follow steps to install plugins, set up servers, connect, and create interactive visualizations.

How to visualize a Google Sheets spreadsheet in Metabase?

Learn to connect Anyquery to Google Sheets and visualize data in Metabase. Follow steps to install plugins, configure connections, and create visualizations using SQL.

How to visualize a Google Sheets spreadsheet in Tableau?

Learn how to visualize Google Sheets data in Tableau using Anyquery. This guide covers setting up plugins, launching the server, and creating visualizations in Tableau.

How to visualize a Notion database in Looker Studio(formerly Google Data Studio)?

Learn to visualize your Notion database in Looker Studio with Anyquery. Install plugins, query data, set up secure connections, and create custom visualizations seamlessly.

How to visualize a Notion database in Metabase?

Learn to visualize Notion databases in Metabase using Anyquery. Follow steps to install, configure, connect, and create visualizations for insightful data analysis.

How to visualize a Notion database in Tableau?

Learn to connect Anyquery to Notion and visualize your data in Tableau, enabling creation of detailed reports and dashboards. Follow this step-by-step guide to get started.

How to visualize an Airtable database in Looker Studio(formerly Google Data Studio)?

Learn to visualize an Airtable database in Looker Studio using Anyquery. Follow steps to install plugins, set up connections, run SQL queries, and create visualizations.

How to visualize an Airtable database in Metabase?

Learn to connect Anyquery to an Airtable database and visualize it in Metabase. Follow steps to install plugins, configure connections, and create visualizations.

How to visualize an Airtable database in Tableau?

Learn to visualize Airtable data in Tableau via Anyquery. Install necessary plugins, configure connections, and create insightful visualizations with ease.

Import a Parquet file into SQLite

Learn how to import a Parquet file into SQLite using Anyquery.

Recipes

Learn how to use Anyquery with these recipes

Convert a JSON file to CSV

Learn how to convert a JSON file to a CSV file using Anyquery.

Query an HTML table

Learn how to run a SQL query on an HTML table from a website

Transfer your Pocket articles to Raindrop.io

Learn how to transfer your Pocket articles to Raindrop.io using Anyquery.

Transfer a Spotify playlist to Airtable

Learn how to transfer a Spotify playlist to Airtable using Anyquery.

Using a Google Sheets as a SQL database

Learn to use Google Sheets as a SQL database with Anyquery. Install plugins, authenticate with Google, configure settings, and perform SQL operations seamlessly.

Visualize the GitHub repositories of Vercel using Metabase

Learn how to connect Anyquery to the GitHub API and visualize the repositories of Vercel using Metabase