GlareDB is a database system built for querying and analyzing distributed data using SQL. Query data directly from Snowflake, Postgres, object storage, and more without moving data around.

curl https://glaredb.com/install.sh | sh

Or check out console.glaredb.com for fully managed deployments of GlareDB. If you prefer manual installation, download, extract and run the GlareDB binary from a release in our releases page.

Start GlareDB with the local subcommand to start a local SQL session:

./glaredb local

Alternatively, the server subcommand can be used to launch a server process for GlareDB:

./glaredb server

When launched as a server process, GlareDB can be reached on port 6543 using a Postgres client. For example, connected to a local instance of GlareDB using psql:

psql "host=localhost user=glaredb dbname=glaredb port=6543"

A demo Postgres instance is deployed at pg.demo.glaredb.com. Adding this Postgres instance as data source is as easy as running the following command:

CREATE EXTERNAL DATABASE my_pg
    FROM postgres
    OPTIONS (
        host = 'pg.demo.glaredb.com',
        port = '5432',
        user = 'demo',
        password = 'demo',
        database = 'postgres',
    );

Once the data source has been added, it can be queried using fully qualified table names:

SELECT *
FROM my_pg.public.lineitem
WHERE l_shipdate <= date '1998-12-01' - INTERVAL '90'
LIMIT 5;

Check out the docs to learn about all supported data sources. Many data sources can be connected to the same GlareDB instance.

Done with this data source? Remove it with the following command:

DROP DATABASE my_pg;

Building GlareDB requires Rust/Cargo to be installed. Check out rustup for an easy way to install Rust on your system.

Running the following command will build a release binary:

just build --release

The compiled release binary can be found in target/release/glaredb.

Browse GlareDB documentation on our docs.glaredb.com.

Contributions welcome! Check out CONTRIBUTING.md for how to get started.

See LICENSE. Unless otherwise noted, this license applies to all files in this repository.