usql

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite, SQL Server, and many other databases. Written in Go by Kenneth Shaw, usql provides a single, consistent interface for interacting with over 50 database systems, eliminating the need to learn and switch between different database-specific CLI tools. With over 9,500 stars as of 2026, usql is designed as a database management swiss-army knife for developers and database administrators. Key features include: support for 50+ database drivers including PostgreSQL, MySQL/MariaDB, SQLite3, Oracle, Microsoft SQL Server, ClickHouse, CockroachDB, CrateDB, DuckDB, Firebird, MaxCompute, ModernC, My MySQL, ODBC, Pandas (CSV/Parquet), PostgreSQL, Presto, SAP HANA, Snowflake, Trino, Vertica, and many others, SQL execution with multi-line input support, command history with reverse search (via readline library), meta-commands prefixed with backslash (similar to psql commands like \d for describe, \dt for tables, \l for databases, \i for executing files, \c for connecting, \q for quitting), connection string support for easy database switching, output formatting options (table format with borders, aligned columns, CSV, TSV, JSON, and HTML), variable interpolation and substitution, prepared statements, transaction management (BEGIN, COMMIT, ROLLBACK), COPY command for bulk data import/export, password prompt and .pgpass file support, SSL/TLS connection options, and configurable via a .usqlrc initialization file.