SQL tooling as UI: turning queries into usable interfaces with SQLYac and SQLPage

SQL tooling is turning queries into usable interfaces, not just lines of code. SQLYac gives you executable SQL docs with variables, safety prompts, and per-query targeting, letting you run annotated queries from the terminal by piping to any SQL client. Meanwhile, SQLPage takes the same SQL brainpower and spills it into auto-generated web UIs for any DB. And for teams chasing repeatable evaluation of retrieval pipelines, the Local RAG Eval Harness keeps benchmarks local and reproducible. ^[1][2][3]

• SQLYac - You write annotated queries in a single file with variables, and set up safety prompts so destructive actions prompt for confirmation. Queries can be targeted per block; you can run a file with 'sqlyac queries.sql QueryWithVariables | mysql -u user -p database' (or psql, sqlite3). ^[1]

• SQLPage - SQLPage 0.38: transform SQL queries into web UIs for any DB. ^[2]

• Local RAG Eval Harness - A small toolkit to run reproducible, local evaluations for retrieval-augmented generation (RAG). It ships with a CLI + notebooks, fixed seeds, and a baseline config so results are easy to compare across machines; metrics include Hit@K, MRR, Exact Match, grounded accuracy, latency, and token-cost; one-command local runs (Docker optional); minimal HTML report + CSV/Parquet exports. ^[3]

Roadmap items tease dataset adapter registry, built-in failure-mode explorer, and a tiny web UI. These tools together move SQL from code to interactive interfaces, backed by measurable benchmarks you can actually trust.

References