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
Brave 
Google Chrome 
ClickUp 
Discord 
Docker 
Microsoft Edge 
File 
git 
GitHub 
Imap 
Apple Notes 
Apple Reminders 
System Infos Chrome Close tabs of a domain different than the specified one
Close all tabs from a domain that is different from the specified one
Google Chrome Chrome Close tabs of a specific domain
Close all tabs that belong to a specific domain
Google Chrome Close tabs of a domain different than the specified one
Close all tabs that do not belong to the specified domain
Brave Close tabs of a domain different than the specified one
Close all tabs that do not belong to the specified domain
Microsoft Edge Close tabs of a specific domain
Close all tabs that belong to a specific domain
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
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
Google Chrome Close tabs with a specific keyword in the title
Close all tabs that contain a given keyword in their title
Microsoft Edge Create a reminder for tomorrow at 9am
Add a new reminder scheduled for tomorrow at 9am in Apple's Reminders app
Apple Reminders Does this user follow this other user on GitHub?
Check if one user follows another on GitHub
GitHub Does this user star this repository on GitHub?
Check if a specific user has starred a particular repository on GitHub.
GitHub Edge Close tabs of a specific domain
Close all tabs from a specific domain in a Chromium-based browser.
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.
ClickUp Find files matching a specific pattern
Retrieve a list of files that match a specific pattern in their names
File Find the n biggest files in a directory
Get the n largest files by size in a specified directory
File GitHub Stars per day
Discover the number of stars per day for a given repository ordered by date (recent first)
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.
git How many containers are running?
Retrieve the count of currently running containers.
Docker How many cores does the system have?
Get the number of CPU cores in the system
System Infos How many downloads got each release of a GitHub repository?
Get the number of downloads for each release of a GitHub repository
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
System Infos How many messages contain a particular word?
Count the number of messages in a Discord channel that contain a specific word.
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.
Discord How many messages were sent in a channel?
Get the total number of messages sent in a specific Discord channel.
Discord How many notes are contained in a folder?
Get the count of notes in a specific folder
Apple Notes How many people were banned in a server?
Count the number of users who have been banned from a specific Discord server.
Discord How many processes are running on the system?
Get the total number of processes currently running on the system.
System Infos How many tabs are open in the browser?
Count the total number of open tabs in the browser
Brave How many tabs are open in the browser?
Get the total number of open tabs in the Chromium-based browser
Google Chrome How many tabs are open in the browser?
Get the total number of open tabs in the Chromium-based browser
Microsoft Edge How many tasks exist per status in a specific list?
Count the number of tasks per status in a given list
ClickUp How much memory is used by the system?
Get the amount of memory currently used by the system
System Infos How much swap is used by the system?
Retrieve the total amount of swap space used by the system.
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
File List all containers running a specific image
Get a list of all Docker containers that are currently running a specified image.
Docker List all documents in a specific folder
Get all documents within a specific folder by providing the folder ID
ClickUp List all images that don't have a container
Get all Docker images that are not used by any containers
Docker List all invites in a server
Retrieve all invite links of a server
Discord List all lists in a specific space
Retrieve all the lists within a given space in ClickUp.
ClickUp List all subtasks of a specific task
Retrieve all subtasks of a given task ID.
ClickUp List all tasks assigned to a specific user
Retrieve all tasks that are assigned to a specific user using their user ID.
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
ClickUp List all tasks in a specific list
Retrieve all tasks from a specified ClickUp list
ClickUp List all tasks that are due today
Retrieve all tasks from a specific list that have a due date set to today.
ClickUp List all tasks that are overdue
Retrieve all tasks that are overdue in a given list
ClickUp List all the branches of a GitHub repository
Get a list of all branches for a specific GitHub repository
GitHub List all the channels in a server
Get all channels of a specific Discord server, ordered by their positions.
Discord List all the contributors of a GitHub repository.
Retrieve a list of all the contributors for a specified GitHub repository.
GitHub List all the roles in a server.
Retrieve all roles from a specific Discord server.
Discord List all the users in a server
Get all members of a Discord server
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.
GitHub List notes that contain a particular word
Retrieve all notes that contain a specific word in their content
Apple Notes List the child processes of a process
Get a list of all child processes of a given process ID
System Infos List the mounted filesystems of the system
Retrieve all the mounted filesystems along with their details
System Infos List the open files of a process
Retrieve the list of files opened by a specific process.
System Infos List the repositories of a GitHub user
Get a list of repositories from a specific GitHub user
GitHub List the top n biggest images
Get the top n biggest Docker images sorted by their size
Docker Most starred gist of a GitHub user
Find the gist with the most stars for a given GitHub user.
GitHub My most starred GitHub repository
Find the repository with the highest number of stars for the authenticated user.
GitHub Set all reminders in a list to complete
Mark all reminders in a specified list as completed
Apple Reminders Set reminders containing a word as complete
Mark as complete all reminders that contain a specific word in their name or body
Apple Reminders What are my unread emails?
List all the emails that are unread
Imap What are the 10 biggest commit authors on GitHub?
Get the 10 users with the most commits on GitHub for a given repository
GitHub What are the 10 most-starred repositories of a user?
Get the 10 repositories with the most stars of a user
GitHub What are the most CPU demanding processes on the system?
Get the processes that are using the most CPU on the system
System Infos What are the most memory demanding processes on the system?
List the processes that consume the most memory on the system
System Infos What is the newest container?
Find the most recently created container.
Docker What is the oldest container?
Find the oldest Docker container based on the created date.
Docker What is the remaining disk space per filesystem?
Get the remaining disk space for each filesystem on the system
System Infos What is the title of the active tab?
Retrieve the title of the currently active tab in the Brave browser
Brave What is the title of the active tab?
Get the title of the currently active tab in a Chromium-based browser
Google Chrome What is the title of the active tab?
Retrieve the title of the currently active tab in a Chromium-based browser
Microsoft Edge What is the URL of the active tab?
Get the URL of the currently active tab in the Brave browser
Brave What is the URL of the active tab?
Get the URL of the currently active tab in the Chromium based browser
Google Chrome What is the URL of the active tab?
Get the URL of the currently active tab
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.
System Infos What's the first message sent in a channel?
Retrieve the first message that was sent in a specified Discord channel.
Discord What's the last message sent in a channel?
Retrieve the most recent message sent in a specific Discord channel.
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
GitHub What's the PID of a process?
Find the Process ID (PID) of a running process by its name
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
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
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
git Which invite has been used the most in a server?
Find the most used invite code in a Discord server.
Discord Which note was created first?
Get the note that was created first.
Apple Notes Which note was created last?
Find the most recently created note
Apple Notes Which open issues are assigned to me?
Discover the issues assigned to you
GitHub Which open pull requests are assigned to me?
Discover the pull requests assigned to you
GitHub Which process binds to a particular port?
Find the process that is binding to a specific network port
System Infos Which process has opened a particular file?
Find the process that has opened a specific file
System Infos Which tasks have a specific tag?
Retrieve tasks that have a specific tag in a given list
ClickUp Who are the stargazers of a GitHub repository?
List the users who starred a GitHub repository
GitHub Who follows me on GitHub?
Get the list of users who follow you on GitHub
GitHub Who has invited the most people to a server?
Find out which user has invited the most people to a specific Discord server.
Discord Who is the biggest committer on a GitHub repository?
Get the user with the most commits on a GitHub repository
GitHub Who is the first user to join a server?
Find the first user to join a specified Discord server.
Discord Who is the last user to join a server?
Get the most recent user to join a Discord server
Discord Who sent the most messages in a channel?
Find the user who sent the most messages in a specific Discord channel.
Discord 