Query hub

The query hub is a place where you can find pre-made SQL queries for Anyquery.
Answer questions on your data easily using Anyquery and its hub of queries.

Filter by plugin

Add a query

Chrome Close tabs of a domain different than the specified one

Close all tabs from a domain that is different from the specified one

Plugin:
Google Chrome

Chrome Close tabs of a specific domain

Close all tabs that belong to a specific domain

Plugin:
Google Chrome

Close tabs of a domain different than the specified one

Close all tabs that do not belong to the specified domain

Plugin:
Brave

Close tabs of a domain different than the specified one

Close all tabs that do not belong to the specified domain

Plugin:
Microsoft Edge

Close tabs of a specific domain

Close all tabs that belong to a specific domain

Plugin:
Brave

Close tabs that contain a specific keyword in the title

Close all tabs in the Brave browser that have a specific keyword in their title

Plugin:
Brave

Close tabs that contain a specific keyword in the title

Close all tabs in a Chromium-based browser where the title contains a specified keyword

Plugin:
Google Chrome

Close tabs with a specific keyword in the title

Close all tabs that contain a given keyword in their title

Plugin:
Microsoft Edge

Create a reminder for tomorrow at 9am

Add a new reminder scheduled for tomorrow at 9am in Apple's Reminders app

Plugin:
Apple Reminders

Does this user follow this other user on GitHub?

Check if one user follows another on GitHub

Plugin:
GitHub

Does this user star this repository on GitHub?

Check if a specific user has starred a particular repository on GitHub.

Plugin:
GitHub

Edge Close tabs of a specific domain

Close all tabs from a specific domain in a Chromium-based browser.

Plugin:
Microsoft Edge

Export a ClickUp document to text

Retrieve and export the content of all pages within a specified ClickUp document as a single concatenated text.

Plugin:
ClickUp

Find files matching a specific pattern

Retrieve a list of files that match a specific pattern in their names

Plugin:
File

Find the n biggest files in a directory

Get the n largest files by size in a specified directory

Plugin:
File

GitHub Stars per day

Discover the number of stars per day for a given repository ordered by date (recent first)

Plugin:
GitHub

Hello World

Always return hello world for testing purposes

How many commits were made in the last week?

Count the number of commits made in the last week in a Git repository.

Plugin:
git

How many containers are running?

Retrieve the count of currently running containers.

Plugin:
Docker

How many cores does the system have?

Get the number of CPU cores in the system

Plugin:
System Infos

How many downloads got each release of a GitHub repository?

Get the number of downloads for each release of a GitHub repository

Plugin:
GitHub

How many instances of a process are running on the system?

Count the number of instances of a specific process running on the system

Plugin:
System Infos

How many messages contain a particular word?

Count the number of messages in a Discord channel that contain a specific word.

Plugin:
Discord

How many messages were sent by a particular user in a channel?

Count the number of messages sent by a specific user in a particular channel on Discord.

Plugin:
Discord

How many messages were sent in a channel?

Get the total number of messages sent in a specific Discord channel.

Plugin:
Discord

How many notes are contained in a folder?

Get the count of notes in a specific folder

Plugin:
Apple Notes

How many people were banned in a server?

Count the number of users who have been banned from a specific Discord server.

Plugin:
Discord

How many processes are running on the system?

Get the total number of processes currently running on the system.

Plugin:
System Infos

How many tabs are open in the browser?

Count the total number of open tabs in the browser

Plugin:
Brave

How many tabs are open in the browser?

Get the total number of open tabs in the Chromium-based browser

Plugin:
Google Chrome

How many tabs are open in the browser?

Get the total number of open tabs in the Chromium-based browser

Plugin:
Microsoft Edge

How many tasks exist per status in a specific list?

Count the number of tasks per status in a given list

Plugin:
ClickUp

How much memory is used by the system?

Get the amount of memory currently used by the system

Plugin:
System Infos

How much swap is used by the system?

Retrieve the total amount of swap space used by the system.

Plugin:
System Infos

How often are files modified in a directory? (per month in GB)

Get the total file size in GB of files modified per month in a directory

Plugin:
File

List all containers running a specific image

Get a list of all Docker containers that are currently running a specified image.

Plugin:
Docker

List all documents in a specific folder

Get all documents within a specific folder by providing the folder ID

Plugin:
ClickUp

List all images that don't have a container

Get all Docker images that are not used by any containers

Plugin:
Docker

List all invites in a server

Retrieve all invite links of a server

Plugin:
Discord

List all lists in a specific space

Retrieve all the lists within a given space in ClickUp.

Plugin:
ClickUp

List all subtasks of a specific task

Retrieve all subtasks of a given task ID.

Plugin:
ClickUp

List all tasks assigned to a specific user

Retrieve all tasks that are assigned to a specific user using their user ID.

Plugin:
ClickUp

List all tasks due in the next n days

Retrieve all tasks from a specific list that are due within the next n days

Plugin:
ClickUp

List all tasks in a specific list

Retrieve all tasks from a specified ClickUp list

Plugin:
ClickUp

List all tasks that are due today

Retrieve all tasks from a specific list that have a due date set to today.

Plugin:
ClickUp

List all tasks that are overdue

Retrieve all tasks that are overdue in a given list

Plugin:
ClickUp

List all the branches of a GitHub repository

Get a list of all branches for a specific GitHub repository

Plugin:
GitHub

List all the channels in a server

Get all channels of a specific Discord server, ordered by their positions.

Plugin:
Discord

List all the contributors of a GitHub repository.

Retrieve a list of all the contributors for a specified GitHub repository.

Plugin:
GitHub

List all the roles in a server.

Retrieve all roles from a specific Discord server.

Plugin:
Discord

List all the users in a server

Get all members of a Discord server

Plugin:
Discord

List my GitHub starred repositories for a particular language

Fetch the list of repositories starred by the authenticated user that are written in a specified programming language.

Plugin:
GitHub

List notes that contain a particular word

Retrieve all notes that contain a specific word in their content

Plugin:
Apple Notes

List the child processes of a process

Get a list of all child processes of a given process ID

Plugin:
System Infos

List the mounted filesystems of the system

Retrieve all the mounted filesystems along with their details

Plugin:
System Infos

List the open files of a process

Retrieve the list of files opened by a specific process.

Plugin:
System Infos

List the repositories of a GitHub user

Get a list of repositories from a specific GitHub user

Plugin:
GitHub

List the top n biggest images

Get the top n biggest Docker images sorted by their size

Plugin:
Docker

Most starred gist of a GitHub user

Find the gist with the most stars for a given GitHub user.

Plugin:
GitHub

My most starred GitHub repository

Find the repository with the highest number of stars for the authenticated user.

Plugin:
GitHub

Set all reminders in a list to complete

Mark all reminders in a specified list as completed

Plugin:
Apple Reminders

Set reminders containing a word as complete

Mark as complete all reminders that contain a specific word in their name or body

Plugin:
Apple Reminders

What are my unread emails?

List all the emails that are unread

Plugin:
Imap

What are the 10 biggest commit authors on GitHub?

Get the 10 users with the most commits on GitHub for a given repository

Plugin:
GitHub

What are the 10 most-starred repositories of a user?

Get the 10 repositories with the most stars of a user

Plugin:
GitHub

What are the most CPU demanding processes on the system?

Get the processes that are using the most CPU on the system

Plugin:
System Infos

What are the most memory demanding processes on the system?

List the processes that consume the most memory on the system

Plugin:
System Infos

What is the newest container?

Find the most recently created container.

Plugin:
Docker

What is the oldest container?

Find the oldest Docker container based on the created date.

Plugin:
Docker

What is the remaining disk space per filesystem?

Get the remaining disk space for each filesystem on the system

Plugin:
System Infos

What is the title of the active tab?

Retrieve the title of the currently active tab in the Brave browser

Plugin:
Brave

What is the title of the active tab?

Get the title of the currently active tab in a Chromium-based browser

Plugin:
Google Chrome

What is the title of the active tab?

Retrieve the title of the currently active tab in a Chromium-based browser

Plugin:
Microsoft Edge

What is the URL of the active tab?

Get the URL of the currently active tab in the Brave browser

Plugin:
Brave

What is the URL of the active tab?

Get the URL of the currently active tab in the Chromium based browser

Plugin:
Google Chrome

What is the URL of the active tab?

Get the URL of the currently active tab

Plugin:
Microsoft Edge

What's the current CPU usage of the system?

Get the current CPU usage statistics of the system, including user, system, and idle times.

Plugin:
System Infos

What's the first message sent in a channel?

Retrieve the first message that was sent in a specified Discord channel.

Plugin:
Discord

What's the last message sent in a channel?

Retrieve the most recent message sent in a specific Discord channel.

Plugin:
Discord

What's the oldest open issue in a GitHub repository?

Find the oldest open issue in a specific GitHub repository based on the creation date

Plugin:
GitHub

What's the PID of a process?

Find the Process ID (PID) of a running process by its name

Plugin:
System Infos

Which author has the most lines of code added in the repository?

Find the author who has added the most lines of code in the repository

Plugin:
git

Which file extensions are the most common in a directory?

Get the most common file extensions in a given directory to understand the types of files it contains

Plugin:
File

Which files are the most frequently modified in the repository?

Find the files that have been modified the most number of times in a given Git repository

Plugin:
git

Which invite has been used the most in a server?

Find the most used invite code in a Discord server.

Plugin:
Discord

Which note was created first?

Get the note that was created first.

Plugin:
Apple Notes

Which note was created last?

Find the most recently created note

Plugin:
Apple Notes

Which open issues are assigned to me?

Discover the issues assigned to you

Plugin:
GitHub

Which open pull requests are assigned to me?

Discover the pull requests assigned to you

Plugin:
GitHub

Which process binds to a particular port?

Find the process that is binding to a specific network port

Plugin:
System Infos

Which process has opened a particular file?

Find the process that has opened a specific file

Plugin:
System Infos

Which tasks have a specific tag?

Retrieve tasks that have a specific tag in a given list

Plugin:
ClickUp

Who are the stargazers of a GitHub repository?

List the users who starred a GitHub repository

Plugin:
GitHub

Who follows me on GitHub?

Get the list of users who follow you on GitHub

Plugin:
GitHub

Who has invited the most people to a server?

Find out which user has invited the most people to a specific Discord server.

Plugin:
Discord

Who is the biggest committer on a GitHub repository?

Get the user with the most commits on a GitHub repository

Plugin:
GitHub

Who is the first user to join a server?

Find the first user to join a specified Discord server.

Plugin:
Discord

Who is the last user to join a server?

Get the most recent user to join a Discord server

Plugin:
Discord

Who sent the most messages in a channel?

Find the user who sent the most messages in a specific Discord channel.

Plugin:
Discord