{"repo":"kiki-ki/go-qo","free":true,"listed":false,"github":"https://github.com/kiki-ki/go-qo","clone":"git clone https://github.com/kiki-ki/go-qo.git","description":"qo is an interactive minimalist TUI to query JSON and CSV using SQL.","language":"Go","stars":398,"topics":["bubbletea","cli","csv","filter","go","golang","interactive","jq","json","query"],"license":"MIT","category":"cli-tools","readme_excerpt":"🥢 qo qo [cue-oh] noun. 1. A minimalist TUI for querying JSON, CSV using SQL. 2. \"query\" what you need, and get it \"out\" to the pipeline. Why qo? Muscle Memory : Use the SQL syntax you've known for years. Pipeline Native : Reads from stdin , writes to stdout . Interactive : Don't guess the query. See the result, then hit Enter. Install macOS and Linux (amd64/arm64) are supported. Homebrew (Package) Shell (Binary) Git (Source) Usage qo reads from both file arguments and standard input (stdin). Pipe-Friendly TUI TUI mode works seamlessly with pipes. Explore data interactively, then pass the result to other tools. Query Logs & Aggregate Use SQL to analyze structured data. Convert Formats Transform between various formats. Options Flag Short Default Description :--- :--- :--- :--- --input -i json Input format: json, csv, tsv, psv (\"json\" includes \"jsonl\") --output -o json Output format: json, jsonl, csv, tsv, psv, table --query -q Run SQL query directly (Skip TUI) --no-header Treat first row as data, not header (CSV/TSV/PSV only) UI Controls Key Mode Action :--- :--- :--- Tab ALL Switch between Query/Table mode Esc ALL Output & Quit Ctrl+C ALL Quit (Output nothing) Enter QUERY Execute query ↑ ↓ / j k TABLE Scroll rows ← → / h l TABLE Scroll columns SQL Dialect qo uses SQLite as its SQL engine. All queries follow SQLite syntax and support its built-in functions. Querying Nested JSON Use SQLite's json extract() function to access nested fields in JSON data. For more details, see SQ","default_branch":null,"files":null,"tree":[],"storefront":"/r/kiki-ki","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/kiki-ki/go-qo/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}