Awesome GitHub RepositoriesCSV Query Engines

AlaSQL is a JavaScript SQL database engine that allows for the filtering, grouping, and joining of in-memory object arrays and JSON data. It functions as an in-memory SQL database and client-side data processor, enabling the execution of SQL statements against JavaScript arrays and external data sources in both browser and server environments. The project serves as a universal data query tool capable of performing relational joins across diverse sources, such as merging Google Spreadsheets, SQLite files, and remote APIs into a single result set. It also acts as an IndexedDB SQL wrapper, allow

csvkit is a composable Unix-style command-line toolkit for converting, filtering, and analyzing CSV files directly from the terminal. It provides a suite of focused single-purpose commands that can be combined via pipes to build complex data processing workflows, with a modular architecture that includes a column-type inference engine for automatically detecting data types and a streaming-pipeline design for efficient handling of tabular data. The toolkit distinguishes itself through its SQL-engine abstraction layer, which allows users to run SQL queries directly against CSV files without req

sqlean ist eine Sammlung von SQLite-Erweiterungsbibliotheken, die als C-basierte Shared Libraries implementiert sind. Sie bietet eine Suite zusätzlicher skalarer und tabellenwertiger Funktionen, die die nativen Fähigkeiten der SQLite-Datenbank-Engine erweitern. Das Projekt bietet spezialisierte Toolsets für Kryptografie, fortgeschrittene Mathematik, Netzwerke und Dateisystemzugriff. Dazu gehören binäres Hashing und Encoding, statistische Analysen, IP-Adressvalidierung sowie die Möglichkeit, CSV-Dateien oder Dateisystempfade als virtuelle Tabellen abzubilden. Die Bibliothek enthält zudem umfassende Textverarbeitungstools wie reguläre Ausdrücke, Fuzzy-Matching und Unicode-bewusste String-Manipulation. Zusätzliche Funktionen decken hochpräzises Datums- und Zeitmanagement sowie die Generierung eindeutiger Identifikatoren ab.

Franchise is a database query tool and notebook SQL client that allows users to run queries and analyze datasets. It functions as a local data processor with a browser-based engine for executing SQL commands against CSV, JSON, and XLSX files without uploading data to a remote server. The project uses a cell-based interface to organize queries and results in an interactive, document-like layout. It supports a workflow where users can fork queries into side-by-side layouts to compare different SQL variations and their results without overwriting existing code. The system provides a unified int