v3.0.0

Breaking

csvql --mcp without --root now only opens files under the directory it was started in. Pass --root <dir> to choose the folders, or --root / for the old behaviour. Set --root explicitly in your MCP config, since the starting directory depends on how the client launches the server.

Claude Desktop: Desktop starts MCP servers in /, so without --root csvql can read the whole disk there. Add "--root", "/path/to/your/data" to the csvql args in claude_desktop_config.json. The next release refuses to start in / without --root (#289).

What's fixed / changed

• feat: arithmetic in WHERE and over aggregates, column names with spaces (#287)
• fix: write statements say csvql is read-only (#286)
• fix: a directory under --root is NotARegularFile on Windows too (#285)
• fix: MCP resolves IN subqueries, refuses stdin and non-regular files under --root (#284)
• fix: reject text after the table that is not an alias, accept a trailing semicolon (#283)
• feat: --deny-columns refuses queries that read private columns (#274)
• feat: csv_list searches subfolders (#273)
• feat: --mcp confined to the working directory by default (#272)
• feat: arithmetic in SELECT and inside aggregates (#271)
• fix: arithmetic exits 2; plugin icon, README and version for the directory (#269)
• feat: Claude Code skill plugin and llms.txt so agents reach for csvql (#268)