Show HN: Work with CSV files using SQL. For data scientists and engineers

• q

  46 10,109 3.6 Python

  q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)

- OctoSQL[3] - Also supports querying non-file databases, endless streams and joining everything together.

Disclaimer: I'm the author of OctoSQL. Still actively developing a rewrite on the redesign branch.

[0]: https://github.com/harelba/q

• textql

  15 9,031 3.7 Go

  Execute SQL against structured text like CSV or TSV

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• octosql

  34 4,689 4.3 Go

  OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

• datasette

  187 8,881 9.2 Python

  An open source multi-tool for exploring and publishing data

• sqlitebrowser

  279 19,913 9.0 C++

  Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

  

This open source tool on Github allows you to quickly import a CSV and write SQL queries against it. The CSV is imported into a SQLite database. It also does a lot more, highly recommended.

https://github.com/sqlitebrowser/sqlitebrowser

• sqlite-utils

  35 1,498 8.4 Python

  Python CLI utility and library for manipulating SQLite databases

• csvs-to-sqlite

  4 858 0.0 Python

  Convert CSV files into a SQLite database

The datasette author offers this tool for conversion: https://github.com/simonw/csvs-to-sqlite

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• cq

  2 167 0.0 Shell

  Query CSVs using SQL

• superintendent

  2 7 0.0

  Write SQL on CSV files

Maybe one day it'll be: https://github.com/tanin47/superintendent

Suggest a related project