squix
Save, run, and export SQL queries across databases
All Skills in This Repository (1)
Pure Emerald Level IndicatorsFrequently Asked Questions
FAQPage SchemaHow to install squix?▼
Run `npx skills add eduardofuncao/squix --all -g -y` in your terminal to install this skill globally.
Which databases does squix support?▼
Squix works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, ClickHouse, Firebird, and DuckDB. You can manage multiple connections and switch between them with one command.
How do I run SQL queries non-interactively with squix?▼
Add the `-f` flag with a format like `squix run my_query -f json` to print results to stdout instead of opening the interactive table view. Supported formats include JSON, CSV, TSV, Markdown, HTML, and SQL.
Can squix run parameterized SQL queries?▼
Yes. Save queries with named parameters like `:user_id`, then pass values at runtime, for example `squix run user_by_id --user_id 42 -f csv`. Positional arguments and default values are also supported.
Can I export query results to a file?▼
Yes. Pipe the formatted output directly to a file, such as `squix run list_users -f json > users.json`. Results go to stdout and errors to stderr, so scripting is clean.
Related Repositories in Data & Analytics
View All in Data & Analytics→PaddleOCR
Extract text, tables, and formulas from PDFs and images
Scrapling
Scrape any website and bypass anti-bot protection with AI
last30days-skill
Research any topic across Reddit, X, YouTube, and the web