
usql
A universal command-line SQL client that brings a psql-like interface to almost every database.
- Verified facts
- 3 of 3
- Alternatives ranked
- 3
- Approved reviews
- 0
- Visits sent from here
- 0
About usql
usql is an open-source command-line client written in Go that works with PostgreSQL, MySQL, Oracle, SQLite, SQL Server and dozens of other SQL and NoSQL databases through one consistent interface. It is modelled on psql, so backslash commands for listing tables, describing objects, switching connections and running files behave the same way regardless of the database underneath, and connections are expressed as URLs. It supports syntax highlighting, completion, variables and conditional logic in scripts, copying data between databases, and several output formats. Because it is a single static binary with drivers built in, it is easy to install through Homebrew, Scoop, package managers or a direct download on Windows, macOS and Linux. It is free under the MIT licence. usql trades depth for breadth: database-specific features are thinner than in native tools like psql or pgcli, but for people who hop between many databases from the terminal it saves learning several clients.
Best for: Terminal users who move between many different databases.
Pros and cons
What works
- One consistent CLI for dozens of databases
- psql-style commands and URL connections
- Single binary, free and MIT-licensed
Why people leave
- Thinner database-specific features
- Terminal only
- Smart completion is less advanced than pgcli
Top usql alternatives
See all 3Why people left usql
In reviewers' own words, from reviews of the apps they moved to. These are their opinions, not ours.
No switching stories yet. If you moved away from usql, review the app you switched to and tell us why.
Reviews
No approved reviews yet. How we verify reviewers
Write a review of usql
usql: common questions
Is usql free?
Yes. usql is free, open-source software.
Is usql open source?
Yes. The source code is on GitHub at xo/usql.
What platforms does usql run on?
usql is available for Windows, macOS and Linux.
What are the best alternatives to usql?
The highest-ranked usql alternatives right now are pgcli, Harlequin and DBeaver. See the full ranked list for pricing, platforms and verified facts.