Agent skill

Squix

by eduardofuncao in eduardofuncao/squix

Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI.

MITAuto-check passedDatabases

Install Squix

skills CLI
$ npx skills add eduardofuncao/squix --skill squix -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install eduardofuncao/squix squix --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
squix
GitHub stars
273
Token cost
~784 tokens
SKILL.md length
182 words
Files
138
Skills in repo
1
Repo updated
First seen
Licence
MIT

At a glance

Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI.

  • Works in 3 steps: Always use -f with squix run for SELECT… → No inline connection flag — must squix… → Check connection first — run squix…
  • Running named queries
  • SKILL.md covers What is Squix, Critical Rules, Non-Interactive Output and Setup Workflow, plus 5 more sections
  • Runs Go and Shell scripts from its folder

What it does

Squix is an agent skill from eduardofuncao/squix. Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI. Use for running named queries, exploring schema, or parameterized queries. Always use -f for non-interactive output.

Its SKILL.md is about 780 tokens, which your agent loads only when the skill is triggered. The skill folder holds 141 other files (for example `.github/FUNDING.yml`, `.github/workflows/ci.yml` and `.github/workflows/release.yml`).

It sits in Databases, covering SQL. It works with SQL, MySQL, PostgreSQL and SQLite. The repository describes itself as: A CLI tool for managing and executing SQL queries across multiple databases. Written in Go, made beautiful with BubbleTea. The licence is MIT.

When your agent uses it

  • Running named queries
  • Exploring schema
  • Parameterized queries

Example prompts

  • “/squix”

Requirements

  • A Bash shell

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

  1. Always use -f with squix run for SELECT queries — without it, SELECT results open an interactive TUI; non-SELECT queries print a status…
  2. No inline connection flag — must squix switch before queries
  3. Check connection first — run squix status to verify reachability

What it can do on your machine

Read from SKILL.md and the folder at commit 61cbabc. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships script files (Go and Shell, from the files we listed), which the agent can run.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Squix loads about 784 tokens when it runs. Until then it costs about 52 tokens; SKILL.md has 182 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~52
When it runs · the whole SKILL.md, loaded when a task matches
~784

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from eduardofuncao/squix at commit 61cbabc, republished under its MIT licence (© eduardofuncao). 182 words, ~784 tokens.

Download SKILL.mdSave it as .claude/skills/squix/SKILL.md (or your agent's skills folder). This skill also uses 137 other files; get the full folder from GitHub.
name
squix
description
Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI. Use for running named queries, exploring schema, or parameterized queries. Always use -f for non-interactive output.

Squix Skill for AI Coding Agents

What is Squix

Squix is a CLI tool for managing and executing SQL queries across multiple databases (PostgreSQL, MySQL, SQLite, Oracle, SQL Server, ClickHouse, Firebird). It stores named queries in ~/.config/squix/config.yaml.

Critical Rules

  1. Always use -f with squix run for SELECT queries — without it, SELECT results open an interactive TUI; non-SELECT queries print a status message either way
  2. No inline connection flag — must squix switch <name> before queries
  3. Check connection first — run squix status to verify reachability

Non-Interactive Output

bash
squix run <query> -f json        # JSON array of objects
squix run <query> -f csv         # CSV with header row
squix run <query> -f tsv         # Tab-separated values
squix run <query> -f markdown    # Markdown table
squix run <query> -f html        # HTML table with styling
squix run <query> -f sql         # INSERT statements
squix run "SELECT 1" -f json     # Inline SQL works too
squix run --last -f csv          # Re-run last query

Output goes to stdout, errors to stderr. Exit code 1 on failure. Pipe cleanly: squix run list_users -f json > users.json

Empty results: "No results found" on stderr, nothing on stdout.

Setup Workflow

bash
squix init mydb "postgresql://user:pass@localhost:5432/mydb"  # auto-infers DB type
squix switch mydb                                              # or: squix use mydb
squix add list_users "SELECT * FROM users"                     # SQL must be inline
squix run list_users -f json                                   # always use -f

Explore Schema

bash
squix explore              # List all tables (non-interactive, prints to stdout)
squix explain orders -d 2  # Show FK relationships as ASCII tree

List Queries

bash
squix list queries            # Format: ◆ <id>/<name> (<table>)
squix list queries --oneline  # Compact: <id> <name> <table>
squix list connections        # List all configured connections

Parameterized Queries

Named params use :name syntax. Optional defaults with :name|default:

bash
squix add user_by_id "SELECT * FROM users WHERE id = :user_id"
squix run user_by_id --user_id 42 -f csv    # named
squix run user_by_id 42 -f csv              # positional

Status & Cleanup

bash
squix status                 # Shows: ● postgres/mydb (schema: public) — reachable
squix remove list_users      # Delete query (no confirmation needed)
echo y | squix remove -c mydb  # Delete connection (needs confirmation)

Commands to Avoid (Interactive)

  • squix run <query> without -f on a SELECT — opens TUI
  • squix shell — interactive REPL
  • squix edit — opens $EDITOR
  • squix explore <table> — opens TUI
  • squix info — opens TUI
  • squix add <name> without SQL — opens $EDITOR
  • squix run with no args — opens $EDITOR

© eduardofuncao, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 137 other files in the repository root of eduardofuncao/squix.

  • SKILL.md
  • .github/FUNDING.yml
  • .github/workflows/ci.yml
  • .github/workflows/release.yml
  • .gitignore
  • CONTRIBUTING.md
  • LICENSE
  • Makefile
  • README.md
  • build-local.sh
  • cmd/squix/add.go
  • cmd/squix/app.go
  • cmd/squix/completion.go
  • cmd/squix/config.go
  • cmd/squix/disconnect.go
  • cmd/squix/drivers.go
  • cmd/squix/edit.go
  • … and 121 more

Open the folder on GitHubat commit 61cbabc

Compare with similar skills

Squix next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Squix compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Squix this skilleduardofuncao/squix273—~784Automated safety check: PassMIT
Golang Databaseunxed/f42412 repos~2.9kAutomated safety check: PassMIT
SQL Database Support for pRESTprest/prest4.6k—~1.6kAutomated safety check: PassMIT
Database MarchatCod-e-Codes/marchat137—~985Automated safety check: PassMIT
Databaseiii-hq/workers113—~1.9kAutomated safety check: PassApache-2.0
Matlab Use Databasematlab/matlab-agentic-toolkit1.1k—~3.1kAutomated safety check: PassCustom licence

Similar skills

  • Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…

    241 GitHub starsUsed in 2 repos~2.9k tokens
    DatabasesAuto-check passed
  • Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.

    4.6k GitHub stars~1.6k tokensUpdated today
    DatabasesAuto-check passed
  • Database Marchat

    Cod-e-Codes/marchat

    Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers.

    137 GitHub stars~985 tokensUpdated 5 days ago
    DatabasesAuto-check passed
  • Database

    iii-hq/workers

    Run SQL against PostgreSQL, MySQL, or SQLite from the iii engine — reads, writes, transactions, and prepared statements over managed connection pools.

    113 GitHub stars~1.9k tokensUpdated today
    DatabasesAuto-check passed
  • Matlab Use Database

    matlab/matlab-agentic-toolkit

    Reads from, writes to, and manages relational databases using MATLAB Database Toolbox.

    1.1k GitHub stars~3.1k tokensUpdated yesterday
    DatabasesAuto-check passed
  • SQL Expert

    aiskillstore/marketplace

    Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server.

    430 GitHub stars~3.4k tokensUpdated yesterday
    DatabasesAuto-check passed

Categories

Questions about Squix

What does Squix do?

Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI. Squix is an agent skill from eduardofuncao/squix.) via the squix CLI.

When should I use Squix?

Squix fits situations like: running named queries; exploring schema; parameterized queries.

How do I install Squix in Claude Code?

Run `npx skills add eduardofuncao/squix --skill squix -a claude-code`. Or copy the skill folder (the eduardofuncao/squix repository) into .claude/skills/squix in your project. Claude Code loads it when a task matches its description.

How do I install Squix in Codex?

Run `npx skills add eduardofuncao/squix --skill squix -a codex`. Or copy the skill folder (the eduardofuncao/squix repository) into .agents/skills/squix in your project. Codex loads it when a task matches its description.

Can I use Squix in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add eduardofuncao/squix --skill squix -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/squix, .gemini/skills/squix, .github/skills/squix and .opencode/skills/squix in your project.

What does Squix need to run?

Going by SKILL.md and its folder, Squix needs Go and a shell for the scripts in its folder. Our summary lists: A Bash shell.

Does Squix access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Squix safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Squix use?

Squix is published under the MIT licence (from the LICENSE file in the skill folder). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Squix use?

About 784 tokens (SKILL.md is roughly 3.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Squix?

Skills that share tags, products or a category with Squix: Golang Database (unxed/f4, 241 stars), SQL Database Support for pREST (prest/prest, 4.6k stars), Database Marchat (Cod-e-Codes/marchat, 137 stars) and Database (iii-hq/workers, 113 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Squix?

eduardofuncao (a GitHub user) maintains it in eduardofuncao/squix, which has 273 GitHub stars. The repository was last updated on September 22, 2026.

Source: eduardofuncao/squix on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.