Favicon of usql

usql

Universal SQL client supporting PostgreSQL, MySQL, Oracle, SQLite, SQL Server and 20+ other databases with autocompletion, syntax highlighting, and advanced features.

usql is a powerful command-line interface that works with PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational systems. It provides a familiar experience inspired by PostgreSQL's psql, making it easy for database administrators and developers to work across different database platforms.

Key capabilities include multiple database support allowing you to connect to different databases in a single session, context-based autocompletion that suggests relevant commands and table names, syntax highlighting for better readability, and copying data between databases without manual export/import steps. The tool supports core psql features like variables, backticks, and backslash commands, while adding capabilities that psql lacks.

Whether you're managing PostgreSQL, working with Oracle, querying SQLite files, or connecting to cloud databases, usql provides a consistent interface. It includes terminal graphics support for visualizing data and offers flexible installation options via Homebrew, Docker, package managers, or direct download. The tool is particularly valuable for teams that use multiple database systems and want to reduce the learning curve by using a single, familiar command-line interface across all platforms.

Install

Brew
$ brew install xo/xo/usql
Brew
$ brew install --with-odbc
Brew
$ brew install icu4c

Features

JSON outputScriptable

Shell features

Syntax highlighting

Media

Pros

4
  • Supports over 20 databases including SQL and NoSQL.
  • Provides autocompletion and syntax highlighting.
  • Offers advanced features like copying between databases.
  • Inspired by PostgreSQL's psql with added capabilities.

Related tools

Categories:

Share:

Auto-fetched .

Recent releases

Similar to usql

Favicon

 

  
 
Favicon

 

  
 
Favicon