polaris2018 / datastation

The Data IDE for Developers; Jupyter Notebook meets SQL GUI

DataStation Community Edition

DataStation allows you to seamlessly connect SQL queries, HTTP requests, scripting, and visualization in a single platform.

Features

• Cross-platform: Windows, macOS, and Linux
• Query SQLite, SQL Server, Oracle, Snowflake, ClickHouse, PostgreSQL- and MySQL-compatible databases
  • With builtin support for proxying over SSH
• Query HTTP servers
  • With builtin support for proxying over SSH
• Read files from disk
  • Builtin support for parquet, CSV, JSON, and Excel (.xlsx, .xls)
  • Builtin support for parsing Apache2 access and error logs, Nginx access logs, syslogs, and newline-delimited JSON
  • With builtin support for reading over SSH (i.e. SFTP)
• Script against data in Python, JavaScript, Ruby, Julia, and R
• Produce bar graphs and pie charts from data

Install

Install instructions are available on the website here.

Documentation

See here for details.

Community

Join us on Discord.

How can I help?

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

If you want to make a fix, see HACKING.md.

Before starting on any new feature though, check in on Discord!

Subscribe

If you want to hear about new features and how DataStation works under the hood, sign up here.

License

This software is licensed under an Apache 2.0 license.