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.

GitHub Stars per day by julien040

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

anyquery run github_stars_per_day

Plugins: github

Requires 1 argument

Tags: github, stars, statistics

Hello World by julien040

Always return hello world for testing purposes

anyquery run hello_world

Requires 0 argument

How many downloads got each release of a GitHub repository? by julien040

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

anyquery run downloads_per_release_github

Plugins: github

Requires 1 argument

Tags: github, downloads, releases

What are my unread emails? by julien040

List all the emails that are unread

anyquery run unread_emails

Plugins: imap

Requires 0 argument

Tags: imap, emails, unread

What are the 10 biggest commit authors on GitHub? by julien040

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

anyquery run biggest_commit_author_github

Plugins: github

Requires 1 argument

Tags: github, commits, statistics

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

Get the 10 repositories with the most stars of a user

anyquery run biggest_starred_repo_per_user_github

Plugins: github

Requires 1 argument

Tags: github, stars, repositories

Which open issues are assigned to me? by julien040

Discover the issues assigned to you

anyquery run issues_assigned

Plugins: github

Requires 0 argument

Tags: github, issues, assigned

Which open pull requests are assigned to me? by julien040

Discover the pull requests assigned to you

anyquery run pull_request_assigned

Plugins: github

Requires 0 argument

Tags: github, pull requests, assigned

Who are the stargazers of a GitHub repository? by julien040

List the users who starred a GitHub repository

anyquery run stargazers_github_repo

Plugins: github

Requires 1 argument

Tags: github, stars

Who follows me on GitHub? by julien040

Get the list of users who follow you on GitHub

anyquery run my_followers_github

Plugins: github

Requires 0 argument

Tags: github, followers