0sql CLI

Builds of zsql, the command line tool for 0sql: author a semantic model, deploy it, and get SQL back.

This repository holds releases and nothing else. The source lives elsewhere.

Install

curl -fsSL https://0sql.io/install.sh | sh

That picks the build for your machine, checks it against SHA256SUMS, and puts it on your PATH. One static binary, nothing else to install.

To pin a version, or to install somewhere particular:

ZSQL_VERSION=0.1.1 ZSQL_INSTALL_DIR=~/bin curl -fsSL https://0sql.io/install.sh | sh

By hand

Take the build for your platform from the latest release, check it against SHA256SUMS, make it executable, and put it on your PATH.

platform	file
Linux, Intel or AMD	zsql-x86_64-linux
Linux, ARM	zsql-aarch64-linux
macOS, Apple silicon	zsql-aarch64-macos
macOS, Intel	zsql-x86_64-macos

The Linux builds are statically linked and run on any distribution with a kernel of 4.4 or newer.

Getting started

zsql init my-project     # a project to describe your warehouse in
zsql auth --api-key KEY  # the key from app.0sql.io
zsql deploy              # send the model to the server
zsql                     # the repl

zsql --help lists the rest.