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.
$ brew install xo/xo/usql$ brew install --with-odbc$ brew install icu4c