Getting Started

What is anyquery about ?

Anyquery allows you to write SQL queries on pretty much any data source. It is a query engine that can be used to query data from different sources like databases, APIs, and even files. For example, you can use a Notion database or a Google Sheet as a database to store your data.

Example

-- List all the repositories from Cloudflare ordered by stars
SELECT * FROM github_repositories_from_user('cloudflare') ORDER BY stargazers_count DESC;

-- List all your saved tracks from Spotify
SELECT * FROM spotify_saved_tracks;

-- Insert data from a git repository into a Google Sheet
INSERT INTO google_sheets_table (name, line_added) SELECT author_name, addition FROM git_commits_diff('https://github.com/vercel/next.js.git');

Installation

Thank you for trying out Anyquery! You can install it by following the instructions below:

Ubuntu, Debian, and derivatives (apt package manager)

# Add the repository
echo "deb [trusted=yes] https://apt.julienc.me/ /" | sudo tee /etc/apt/sources.list.d/anyquery.list
# Update the package list
sudo apt update
# Install the package
sudo apt install anyquery

Fedora, CentOS, and derivatives (dnf/yum package manager)

# Add the repository
echo "[anyquery]
name=Anyquery
baseurl=https://yum.julienc.me/
enabled=1
gpgcheck=0" | sudo tee /etc/yum.repos.d/anyquery.repo
# Install the package
sudo dnf install anyquery

Ubuntu, Debian, and derivatives (Snapcraft)

sudo snap install anyquery

MacOS (Homebrew)

brew install julien040/anyquery/anyquery

Windows (Scoop)

scoop bucket add anyquery https://github.com/julien040/anyquery-scoop
scoop install anyquery

Windows (Chocolatey)

choco install anyquery

Windows (Winget)

winget install JulienCagniart.anyquery