usql

Project Overview

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases. It is inspired by PostgreSQL's psql.

Key Features

• Supports many SQL and NoSQL databases
• Core psql features (variables, backticks, backslash commands)
• Copy between databases
• Syntax highlighting
• Context-based completion

Target Audience

• Database administrators (DBAs)
• Developers managing multiple databases
• Users who like the psql-style tool

Quick Start

1. Download from Releases
2. Move the executable to $PATH
3. Homebrew (macOS/Linux): brew install xo/xo/usql
4. Run usql <database connection string> to connect

Core Advantages

• Unified command-line interface for multiple databases
• psql-style, familiar and easy to use
• Syntax highlighting and context completion
• Open-source and free

System Requirements

• OS: Linux, macOS, Windows
• Architectures: x86_64, arm64
• Additional Dependencies: None

Notes

• ODBC database support requires the --with-odbc install flag