SQL queries on local files via a compact command-line utility
Run SQL queries directly against CSV, JSON, and Parquet files from the command line, returning structured query output for scripts and agents. sqrail, created by yhay81, is a Windows command-line utility that targets developers and AI coding agents. It uses DuckDB for analytical processing, accepts queries as input and prints results as output, and suits automated workflows where non-interactive, file-based querying is required.
What does sqrail let you do with local data files?
sqrail executes standard SQL against local structured files without a separate server, so you can filter, join, aggregate, and transform CSV, JSON, and Parquet directly from a terminal. The tool accepts a single query as input and produces query results as output, which fits scripted pipelines and LLM-driven agents that need predictable, text-based responses.
Does it affect system performance while running queries?
Queries run on the embedded DuckDB engine, which handles analytical workloads on local machines; DuckDB is specified as the execution engine bundled with the binary. The program is a standalone executable that includes the MSVC runtime, so it avoids spawning external database servers and keeps resource use contained to the query process rather than persistent background services.
Is it safe for automated or production-like workflows?
sqrail is non-interactive by design, intended for automation and agent use, which reduces accidental interactive changes. The CLI model enforces a clear SQL-in, files-out pattern; permissions still depend on the operating system and file access rights. The developer packages the tool as a portable binary for Windows with UTF-8 terminal requirements, so safety in deployment follows standard file permission practices on the host system.
A focused utility for developers and agent-based workflows, with a platform limit
sqrail is a compact, technically precise option for developers and AI agents that need ad hoc SQL access to local files on desktop systems. Its single-binary distribution and DuckDB execution make it practical for scripted environments. The main trade-off is platform scope: it is released for Windows terminals with UTF-8 support, so teams working across different desktop platforms may need alternative tools.
