# multiprocessio/datastation

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

Repository: https://github.com/multiprocessio/datastation
Canonical: https://ross.abutalabs.com/products/datastation
Homepage: https://datastation.multiprocess.io
Language: TypeScript
License: NOASSERTION
License Family: other
Topics: sql, mysql, postgresql, sqlite3, cockroachdb, mariadb, sql-server, data-visualization, data-analysis, nginx, apache2, syslog, log-analysis, sql-editor, julia, rstats, python, nodejs, ruby, database
Last push: 2023-11-10T18:44:29+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 1909, "days_push": 1027, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2955, forks 112 (observed 2026-08-28T04:07:32.141908+00:00)

## What it is
DataStation is an open-source cross-platform data IDE for developers that lets you query databases, files, and HTTP APIs, script against the results in languages like Python, JavaScript, R, and Julia, and build graphs, charts, and tables. It supports 20+ databases (PostgreSQL, MySQL, SQLite, SQL Server, ClickHouse, BigQuery, etc.) and many file formats, with all data staying on your machine.

## Use cases
- query postgres mysql and sqlite databases from a gui
- visualize sql query results as charts and graphs
- join data from a database and a csv file
- run python or javascript scripts against query results
- explore log files like nginx and apache access logs
- fetch data from rest apis and analyze it locally
- build ad-hoc reports combining multiple data sources

## When to choose
- you want a local-first data IDE that never sends data to the cloud
- you need to combine queries across many databases, files, and APIs in one tool
- you want to mix SQL with embedded Python, R, Julia, or JavaScript for data munging
- you need quick charts and tables without writing a full BI setup

## When to avoid
- you need a production-grade, scheduled BI/dashboard platform for teams
- you require a fully open-source license (the license is custom, not OSI-approved)
- you need active development and support - the project's last release was late 2023
- you want a web-based collaborative analytics tool

## Facets
- artifact type: application
- maturity: maintenance
- function: data-visualization, database, http-client, developer-tools, analytics
- domain: data-science, data-visualization, databases, developer-tools, analytics
- platform: windows, cross-platform
- tags: data-ide, sql-editor, embedded-scripting, log-analysis, local-first, dashboards, macos, linux, desktop

## Member repositories
- multiprocessio/datastation (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:32.141908+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T07:32:35.981576+00:00, confidence not recorded.
  - readme: https://github.com/multiprocessio/datastation (fetched 2026-08-28T04:07:32.141908+00:00, sha ac68c7563a4c)
  - homepage: https://datastation.multiprocess.io (fetched 2026-08-29T09:48:07.439036+00:00, sha 8a8279b35ef3)
  - site_page: https://datastation.multiprocess.io/docs (fetched 2026-08-29T09:48:07.441679+00:00, sha f5ad1b0515ab)
  - site_page: https://datastation.multiprocess.io/docs/latest/Panels/Database_Panels.html (fetched 2026-08-29T09:48:07.443541+00:00, sha 8358445884b3)
  - site_page: https://datastation.multiprocess.io/docs/latest/Panels/Code_Panels.html (fetched 2026-08-29T09:48:07.445136+00:00, sha 9b9ab3a47a4e)
  - site_page: https://datastation.multiprocess.io/docs/latest/Panels/HTTP_Panels.html (fetched 2026-08-29T09:48:07.446688+00:00, sha f2829bc88b56)
  - site_page: https://datastation.multiprocess.io/docs/latest/Panels/Macros.html (fetched 2026-08-29T09:48:07.448321+00:00, sha 3e4ec72018d8)
  - site_page: https://datastation.multiprocess.io/docs/tutorials/Query_PostgreSQL_with_DataStation.html (fetched 2026-08-29T09:48:07.449903+00:00, sha 190af38796c2)
  - site_page: https://datastation.multiprocess.io/docs/tutorials/Query_MySQL_with_DataStation.html (fetched 2026-08-29T09:48:07.451539+00:00, sha 4d1c6f85d624)
  - site_page: https://datastation.multiprocess.io/docs/tutorials/Query_SQLite_with_DataStation.html (fetched 2026-08-29T09:48:07.453272+00:00, sha 5eee4c7943f4)
- Data as of 2026-08-30T08:39:29.467469+00:00.