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