Squix Skill for AI Coding Agents

What problem does it solve?

This Skill helps AI coding agents execute SQL safely and predictably with Squix, avoiding common interactive/TUI pitfalls and ensuring correct output formatting for automation.

Core Features & Use Cases

• Non-interactive execution: Enforces the use of -f for SELECT queries so results stream to stdout in machine-friendly formats (json/csv/tsv/html/markdown/sql).
• Connection safety workflow: Requires checking connectivity (squix status) and switching to the correct connection before running queries.
• Query library support: Covers running named/ID queries, listing queries/connections, and using parameterized queries with :name and optional defaults (:name|default) for repeatable runs.
• Operational guardrails: Explicitly lists commands to avoid when you need non-interactive behavior (e.g., squix shell, squix run without -f for SELECT).

Quick Start

Run a previously saved query named orders and stream results as JSON to stdout by giving the command: squix switch <connection-name>, then squix run orders -f json.