xql
Share on:
Enter Your Mastodon Instance
Copy the link below to share to Mastodon
https://terminaltrove.com/xql/
An SQL REPL for SharePoint Lists and CSV files.
Script Preview
Review this script before executing in your terminal.
xql is a command-line SQL REPL for Microsoft 365 SharePoint Lists and local CSV files.
It can execute SELECT, UPDATE, INSERT, WHERE, and DELETE commands against either a server-side SharePoint list backend (over Microsoft Graph) with the same grammar with OData or with a CSV file on disk.
While using the xql command prompt, you can directly query CSV files with sqlite-shaped meta-commands (mode, headers, output, once, describe, refresh) and output the result either as an ASCII table, TSV, CSV, or JSON. A one-shot --exec mode needs an explicit --commit, with a --confirm-destructive gate for a bare DELETE and 'WHERE' predicates become OData $filter and run server-side.
xql is primarily for admins, data analysts, or developers who are used to SharePoint Lists and want to use SQL in the terminal for bulk edits, quick audits, and prototyping a query against a CSV first.
