pickfit

BrowseData & database tools

usql

A psql-style command-line client that connects to PostgreSQL, MySQL, Oracle, SQLite3, SQL Server and many other SQL and NoSQL databases.

Tested on LinuxKnown vulnerabilities

Use it

Before you install: known vulnerabilities

pickfit found 1 known high or critical vulnerability in the packages a fresh install brings (OSV.dev, 16 Nov 2026). Weigh this before you install it.

  • go:github.com/andybalholm/brotli v1.2.4 Excessive memory allocation when decompressing crafted streams in github.com/andybalholm/brotli (GO-2026-6888, critical, fixed in 1.2.7)

Linux x86_64

  1. Download the v0.21.6 linux-amd64 release tarball, extract usql, and install it into ~/.local/bin

    cd /tmp && curl -fsSLO https://github.com/xo/usql/releases/download/v0.21.6/usql-0.21.6-linux-amd64.tar.bz2 && mkdir -p /tmp/usqlx ~/.local/bin && python3 -c "import tarfile;t=tarfile.open('/tmp/usql-0.21.6-linux-amd64.tar.bz2');print(t.getnames());t.extractall('/tmp/usqlx')" && install -m755 /tmp/usqlx/usql ~/.local/bin/usql

Check that it works

usql --version

The output should contain “usql 0.21.6”.

First thing to try

usql -c '\drivers'

Run usql -c '\drivers' to list the database drivers your build supports.

What it does

  • Query many SQL and NoSQL databases
    How to use it
    1. List the available drivers with usql -c '\drivers'.
    2. Run a SQL script against a database with usql sq:<database file> -f <script.sql>.
    3. Run a single query with usql sq:<database file> -c '<your query>'.
    Tested
  • Copy data between databases
    How to use it
    1. Copy query results from one database into a table in another with usql -c "\copy csvq:<folder> sq:<database file> '<select query>' '<table>(<columns>)'".
    2. Check the copied rows with usql sq:<database file> -c '<your query>'.
    Tested
  • Use psql-style variables and backslash commands
    How to use it
    1. Write a script using commands such as \set <name> <value>, \echo :<name> and \dt, and use :<name> inside queries.
    2. Run it with usql sq:<database file> -f <script.sql>.
    Tested
  • Complete commands based on context
    Not tested

How far pickfit got

Linux x86_64

  1. Installs
  2. Starts
  3. 3 of 4 features work
  4. Works offline

macOS and Windows: the project says it runs there; pickfit hasn’t tried it.

Good for

  • connect to a PostgreSQL database from the terminal
  • run a SQL script file against a database
  • copy query results between different databases

An alternative to psql.

How pickfit tested it

Each run starts from a clean machine and follows the steps above. How pickfit verifies

Linux x86_64

Its main function works

  • Replayed from scratch
  • Works offline
  • Checked on 15 Nov 2026
  • Version usql 0.21.6

Differences the test machine hit

  • README: Download a release for your platform and extract the usql file from the .tar.bz2
    In the test: The Linux asset is usql-0.21.6-linux-amd64.tar.bz2 (there is also a usql_static build). I extracted it with Python's tarfile module, so I never checked whether this box has bzip2 for tar xjf.

How to read a tool card

Stitching
pickfit installed this tool itself. Everything under the stitches comes from that run. A tool pickfit has not run never gets stitches.
Verified on your OS
The install steps ran on the system you chose. “Ran on Linux only” means it has not been run on yours yet.
macOS, Linux and WindowsWhere it ran
Green OS marks: pickfit ran the install steps there. Grey ones: the README says it runs there, and pickfit has not tried.
How far the run got
Installs and starts, its main function works, its service answers, it produces model output. A window means a desktop app opened; a plug, an MCP client used it. The mark sits beside the run’s result, under “Why it fits and how we know” and in “How pickfit tested it”.
Visual check
pickfit looked at screenshots of the app. Green: it looks right. Amber with a number: things that look wrong; open it to see them. Grey and dashed: not checked yet.
Known vulnerabilities
Known high or critical vulnerabilities (OSV.dev) in what it installs. Green: none known. Red with a number: how many; open it for the list, and read it before you install. Grey and dashed: not checked, which does not mean safe.
About the run
The day it ran, and the version that ran.
Source of a reason
Every reason a pick fits rests on one profile field. Open the reason to see the field and the value it relies on.
Hidden gem
High quality, little known.
Quality and popularity
Two scores out of 100. Quality: how well it installed and worked when pickfit tried it, and how good its install docs and upkeep are. Popularity: from stars, downloads and Hacker News.
Features checked
Of the main features the README advertises, how many the run actually exercised (green), and how many failed (red). Grey ones were not checked, and the card says why.
Not verified
A well-known tool Fitz mentions from general knowledge. No run record, no steps, no score.