From sq
Guides sq CLI for querying SQL databases and tabular files (CSV,TSV,JSON,Excel) using SLQ or native SQL, managing sources/handles, inspecting schemas, diffing data, output formatting, and table operations.
npx claudepluginhub neilotoole/sq --plugin sqThis skill uses the workspace's default tool permissions.
`sq` is a command-line tool for structured data: SQL databases and formats like CSV, TSV, JSON, and Excel. It combines SQL- and `jq`-style querying. Official documentation lives at [sq.io](https://sq.io/).
Conducts multi-round deep research on GitHub repos via API and web searches, generating markdown reports with executive summaries, timelines, metrics, and Mermaid diagrams.
Dynamically discovers and combines enabled skills into cohesive, unexpected delightful experiences like interactive HTML or themed artifacts. Activates on 'surprise me', inspiration, or boredom cues.
Generates images from structured JSON prompts via Python script execution. Supports reference images and aspect ratios for characters, scenes, products, visuals.
sq is a command-line tool for structured data: SQL databases and formats like CSV, TSV, JSON, and Excel. It combines SQL- and jq-style querying. Official documentation lives at sq.io.
This skill targets use of an already-installed sq binary rather than guidance on building from source. Prefer sq help, sq <command> --help, and sq.io over guessing flags.
sq --version
sq help
sq driver ls
sq driver ls lists drivers available in this build (e.g. postgres, sqlite3, csv).
sq add. You get a handle (e.g. @my_pg).sq ls.sq src shows or sets which source SLQ queries use when you omit an explicit handle.Use @handle to target a source in queries (e.g. @my_pg.actor). Concepts: handle, sources.
| Mode | When to use |
|---|---|
| SLQ (default) | sq’s jq-like query language on sources and tables. See Query language. |
| Native SQL | Database-specific SQL via sq sql. |
Cross-source joins (e.g. CSV to Postgres): Cross-source joins.
Results can be printed as text, JSON, CSV, HTML, Markdown, XML, XLSX, etc. See Output formats and insert for writing query results into a database.
Common flags: -j/--json, -t/--text, -o FILE; details in sq --help and the docs above.
sq diff — compare metadata or row data between sources or tables (diff).sq tbl — copy, truncate, drop tables (tbl copy, truncate, drop).When the task involves a specific driver (connection strings, options, caveats), open the matching file under references/:
Driver (as in sq driver ls) | Reference |
|---|---|
sqlite3 | references/sqlite3.md |
postgres | references/postgres.md |
sqlserver | references/sqlserver.md |
mysql | references/mysql.md |
clickhouse | references/clickhouse.md |
csv | references/csv.md |
tsv | references/tsv.md |
json | references/json.md |
jsona | references/jsona.md |
jsonl | references/jsonl.md |
xlsx | references/xlsx.md |
Overview of all drivers: Drivers.