Usql

usql is a universal SQL command-line interface used to connect to and manage multiple SQL and NoSQL databases through a single unified tool. It provides a standardized interface for executing queries across various data stores and serves as a multi-database query tool and schema inspector.

The tool distinguishes itself by enabling cross-database data migration, allowing users to pipe result sets from one active database connection directly into another. It also features terminal-based data visualization, which renders query results as graphical charts, graphs, and images directly within the terminal.

Its broader capabilities include database schema exploration, automated tasking via configuration scripts, and the ability to output query results in multiple formats such as CSV, JSON, and HTML. It manages connectivity using standardized connection strings and supports secure credential loading from external local files.

Global settings and session preferences are managed through YAML-based configuration files.

Features

Command Line SQL Interfaces - Provides a unified command-line interface for executing queries and managing various SQL and NoSQL database engines.

Unified Management Interfaces - Provides a single unified interface to connect to and manage various SQL and NoSQL databases.

Connection Managers - Manages multiple data stores through a standardized connection string format.

Cross-Database Data Migrations - Facilitates moving data between different database engines without changing the current session state.

Cross-Database Data Transfers - Allows piping result sets from one active database connection directly into another for data migration.

Data Transfer Tools - Copies query results from one active database connection and writes them directly into another storage system.

Database Query Engines - Provides a unified interface to execute queries across diverse SQL and NoSQL database engines.

Database Query Interfaces - Facilitates connecting to diverse data stores and transferring data using a consistent interface.

Multi-Database Connections - Supports opening connections to multiple SQL and NoSQL databases via connection URLs.

Inter-Database Data Piping - Enables streaming data from one active database connection directly into another to facilitate seamless data migration.

Multi-Store Connectors - Enables access to both relational and document-oriented data stores using a consistent command set.

SQL Query Interfaces - Standardizes command execution and result sets across multiple SQL and NoSQL engines.

Database Connectivity Drivers - Implements a driver-based abstraction layer to provide a unified interface for connecting to diverse SQL and NoSQL databases.

Connection Profile Aliases - Provides a management system to save database connection strings as named aliases for rapid access.

Output Format Rendering - Transforms query results into multiple representations, including tables, CSV, JSON, and HTML.

Query Result Exporters - Returns query results in multiple formats including tables, CSV, JSON, and HTML.

Database Task Automation - Executes sequences of database commands from files or configuration scripts to automate repetitive operations.

Shell Command Interpolations - Allows injecting the output of system shell commands directly into SQL queries as runtime values.

Terminal Display Modes - Provides various terminal display modes, such as table and vertical views, to customize query result appearance.

Database Schema Explorers - Provides informational commands to list and describe tables, views, indexes, and functions.

Shell Command Execution - Triggers and captures output from system shell commands to use as variables within the tool.

Terminal Graphics Rendering - Displays charts, graphs, and images in the terminal using supported graphics protocols.

Externalized Credential Loaders - Loads sensitive authentication credentials from external local files to decouple passwords from connection strings.

Terminal Data Visualizations - Renders query results as visual charts and graphs directly within the terminal interface.

Database Clients - Universal SQL client with autocompletion.

Database Tools - Universal command-line interface for SQL and NoSQL.

Command Line Interfaces - Universal CLI for SQL and non-relational databases.

Command Line Tools - Listed in the “Command Line Tools” section of the The Book Of Secret Knowledge awesome list.

Terminal Productivity - Universal CLI for SQL databases.

xousql

Features

Star history