/datastation

App to easily query, script, and visualize data from every database, file, and API.

Primary LanguageTypeScriptOtherNOASSERTION

DataStation Community Edition

Help us out by taking a brief user survey!

Stay in the loop

Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list.

About

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 languages like Python, JavaScript, R or SQL. All in one application.

Remote file demo

Features

  • Build reports with graphs, charts and tables
  • Script against data
  • Cross-platform: Windows, macOS, and Linux
  • Easily fetch your data, wherever it is: 18 SQL and non-SQL databases, files, HTTP servers

Query databases and files

Query databases and files

Over 20 supported databases out of the box including: PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, ClickHouse, Influx 1 (InfluxQL), Influx 2 (Flux), Prometheus, Elasticsearch, AWS Athena, Google BigQuery, Snowflake, Cassandra, Scylla, TimescaleDB, YugabyteDB, CockroachDB, CrateDB, QuestDB, and Airtable.

Read more about database panels.

Over 13 supported file formats including: Avro, Parquet, JSON, JSON Newline, Concatenated JSON, CSV, TSV, Excel (XLSX), ODS, Apache Error Logs, Apache Access Logs, Nginx Access Logs, and Newline-delimited Custom Regexp.

Read more about file panels.

Script with code

Script with code

Script with code 2

Python, Ruby, Julia, PHP, Deno, R, JavaScript or SQL are supported scripting languages.

Read more about code panels.

Build graphs

Build graphs

And export data

Export data

Read more about HTTP panels. Or read more about macros.

Install

Install instructions are available here.

Learn

Find user guides for all different kinds of databases and scenarios here.

Community

Join us on Discord.

How can I help?

Download the app and use it! Report bugs on Discord.

If you're a developer with some Go experience looking to hack on open source, check out GOOD_FIRST_PROJECTS.md.