May 9, 2022: DataStation 0.10.0 is released! Read more

Install the App

Learn Blog Community Try the online demoarrow_forward

DataStation Desktop CE

Pre-built binaries are provided for 64-bit x86 machines running macOS, Windows, and Linux.

macOS

Download datastation-darwin-x64-0.10.2.zip and unzip. You will need to right-click the application to click Open so you can run the untrusted application.

Stay in the loop about new releases; subscribe to the mailing list!

Windows

Download datastation-win32-x64-0.10.2.zip and unzip. If you get a warning saying "Don't run", click "More info" and click "Run anyway". There may be a few second long security scan the first time you run.

Stay in the loop about new releases; subscribe to the mailing list!

Linux

Download datastation-linux-x64-0.10.2.zip and unzip.

Stay in the loop about new releases; subscribe to the mailing list!

DataStation Server CE

DataStation Server CE

Download datastation-server-x64-0.10.2.tar.gz. Follow the install or upgrade instructions.

Stay in the loop about new releases; subscribe to the mailing list!

Tutorials

Relational Databases

This tutorial shows how to run PostgreSQL in Docker, load some sample data, and run basic queries in DataStation against the sample data.

This tutorial shows how to run MySQL in Docker, load some sample data, and run basic queries in DataStation against the sample data.

This tutorial shows how to create a simple SQLite database and query it with DataStation.

This tutorial shows how to write basic queries in DataStation against an existing Oracle database.

This tutorial shows how to run SQL Server in Docker, load some sample data, and run basic queries in DataStation against the sample data.

This tutorial walks through running CockroachDB in Docker, creating a table and loading it with data, querying CockroachDB in DataStation, and exploring the data with Python and Pandas.

Data Warehouses

This tutorial shows how to query CSV files on S3 with SQL in DataStation using AWS Athena.

This tutorial shows how to write basic queries in DataStation against one of BigQuery's sample datasets.

Document Databases

This tutorial shows how to run Elasticsearch in Docker, upload some documents with cURL, and run some basic searches in DataStation against the uploaded/indexed documents.

Apps

This tutorial shows how to set up a simple table in Airtable, get an API token, fetch and filter Airtable data in DataStation, and analyze that data locally with SQL.

Time Series Databases

This tutorial shows how to run Scylla in Docker and run some basic searches in DataStation against it.

This tutorial shows how to write basic queries in DataStation against an existing ClickHouse database.

This tutorial shows how to run YugabyteDB in Docker, load some sample data, and run basic queries in DataStation against the sample data.

Metrics Databases

This tutorial shows how to run Prometheus in Docker (scraping itself), and how to run some basic queries in DataStation against the scraped data.

Influx 2.x (Flux)

This tutorial shows how to run Influx 2.x in Docker, upload some sample data provided by Influx, and run basic Flux queries in DataStation against the sample data.

Influx 1.x (InfluxQL)

This tutorial shows how to run Influx 1.x in Docker, upload some sample data provided by Influx, and run basic InfluxQL queries in DataStation against the sample data.

Reference

Panels

Database Panels

Fetch data from many SQL (e.g. like MySQL, PostgreSQL, SQLite) and no-SQL (e.g. Influx, Prometheus, Airtable) databases.

Script in JavaScript, Python, Deno, Ruby, R, Julia, PHP, Deno, and SQL.

Make GET, PUT, POST, DELETE, HEAD requests to local or remote HTTP servers.

Load files from disk or remotely; in formats such as CSV, JSON, Excel, Parquet, and many more.

Release Notes