Alternatives

There are alternative and similar tools:

  • Steampipe. The powerful tool that can query data using SQL from cloud providers (AWS, Azure). There are a lot of plugguble data providers. Internally, it uses Postgres FDW to query various data sources.

  • CloudQuery. The open-source cloud asset inventory powered by SQL.

  • osquery. Uses SQL to provide various device info: disks, processes, apps, users and lot more. Written in C++.

  • LNAV. The Logfile Navigator. It is a terminal application that can understand your log files and make it easy for you to find problems with little to no setup.

  • csvq. Can query CSV files. It can run SELECT, INSERT, UPDATE, DELETE queries. Written in Go.

  • csvkit. This is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats. Written in Python.

  • Musoq. Very similar tool written in C#. The tool allows to use SQL on different data source (CSV, JSON, XML, Git, Websites and a lot more!).

  • RBQL. RBQL is a technology that provides SQL-like language for data-transformation and data-analysis queries for structured data (e.g. CSV files, log files, Python lists, JS arrays). RBQL evaluates input query using one of the available general-purpose "backend" languages (currently Python or JavaScript).

  • NCalc. NCalc is a mathematical expression evaluator in .NET. NCalc can parse any expression and evaluate the result, including static or dynamic parameters and custom functions.

  • NFun. This is an expression evaluator or a mini-script language for .NET . It supports working with mathematical expressions as well as with collections, strings, hi-order functions and structures. NFun is quite similar to NCalc but with a rich type system and linq support.

  • MathEvaluator. MathEvaluator is a .NET library that allows you to evaluate any mathematical expressions from a string dynamically.

  • DuckDB. The DuckDB has extensible engine and can select structured data from CSV or log files. The Data Engineer's Guide to Efficient Log Parsing with DuckDB/MotherDuck. Has great performance.

  • zsv. Fast CSV parser.

  • Sep. CSV parser NuGet package. Really fast.

  • sqly. Eaisly execute SQL against CSV/TSV/LTSV and Microsoft Excel with shell. Golang. It imports files into SQLite table on run.

No active support:

  • Log Parser. The is the command line tool to query various logs files (CSV, IIS logs, event logs, XML, etc). It can run aggregate and filter queries. Only for Windows. Not supported anymore. Documentation.

  • logdissect. Logdissect is a CLI utility and Python library for analyzing log files and other data. It can parse, merge, filter, and export data (to log files, or JSON). Last commit more than 3 years ago.

  • xsv. Command line programs for indexing, slicing, analyzing, splitting and joining CSV files. Written in Rust. Seems it is not supported anymore.

  • q. Run SQL directly on CSV or TSV files. Written in Python. Seems no active support.

  • TextQL. Executes SQL against CSV or TSV. Golang.

  • dsq. Command line tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. Not under active development: "While development may continue in the future with a different architecture, for the moment you should probably instead use DuckDB, ClickHouse-local, or GlareDB (based on DataFusion)." https://github.com/cube2222/octosql

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