DataStation is an open-source data IDE for developers. It allows you to easily build graphs and tables with data pulled from SQL databases, logging databases, metrics databases, HTTP servers, and all kinds of text and binary files. Need to join or munge data? Write embedded scripts as needed in Python, JavaScript, Ruby, R, or Julia. All in one application.
DataStation is built by Multiprocess Labs, run by myself, Phil Eaton. As a developer and engineering manager at Oracle and elsewhere, I found myself repeatedly creating custom scripts to pull data from multiple sources to produce useful reports for product and business teams. It always took me a long time to remember how to connect to all the different databases, how to graph results, how to host a new site for the report, how to send recurring exports of the report.
One way to solve this is to make sure all your data goes into a data warehouse. Then you can just use the data warehouse's dashboarding system to do all your work. But this requires entire organization buy-in both up front and for every new data source you want to add. And the warehouse software and ETL maintenance can be cost prohibitive for small organizations.
In contrast, DataStation gives you a smart, open-source data IDE where you can easily combine data using your existing credentials or API keys with no new ETL process. For truly massive reports, this may fall over. But the majority of business reports can be run without pulling terabytes (let alone gigabytes) of data onto a single machine. DataStation helps you out with those.
DataStation can be run as an easy-to-install desktop application on a single laptop. Or it can be run as a server instance where all data and scripts can be shared across teams. Either way, your credentials are always encrypted.
Installation
DataStation can run as either a desktop application or as a server application. You will need to have an OIDC provider if you want to run the server application. The server application comes with the ability to run and email reports daily, weekly, or monthly. It also comes with support for read-only dashboards.
Desktop
Pre-built binaries are provided for 64-bit x86 machines running macOS, Windows, and Linux.
MacOS
Download datastation-darwin-x64-0.5.0.zip and unzip. You will need to right-click the application to click Open so you can run the untrusted application.
Windows
Download datastation-win32-x64-0.5.0.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.
Linux
Download datastation-linux-x64-0.5.0.zip and unzip.
Other
Other systems and architectures may be supported but you will need to build them yourself. Follow instructions in the repo.
For more information visit https://datastation.multiprocess.io/
The Tech Platform