xo/usqlDocumentation

# install usql
$ brew install xo/xo/usql

# add xo tap
$ brew tap xo/xo

# install usql with odbc support
$ brew install --with-odbc usql

# install usql
$ yay -S usql-bin

# build usql from source
$ yay -S usql

$ git clone https://aur.archlinux.org/usql.git && cd usql
$ makepkg -si

# install the latest usql version, with every driver
$ go install github.com/xo/usql@latest

# run interactive shell and mount the $PWD/data directory as a volume for use
# within the container
$ docker run --rm -it --volume $(pwd)/data:/data docker.io/usql/usql:latest sqlite3://data/test.db
Trying to pull docker.io/usql/usql:latest...
Getting image source signatures
Copying blob af48168d69d8 done   |
Copying blob efc2b5ad9eec skipped: already exists
Copying config 917ceb411d done   |
Writing manifest to image destination
Connected with driver sqlite3 (SQLite3 3.45.1)
Type "help" for help.

sq:data/test.db=> \q

# run postgres locally
$ docker run --detach --rm --name=postgres --publish=5432:5432 --env=POSTGRES_PASSWORD=P4ssw0rd docker.io/usql/postgres

# connect to local postgres instance
$ docker run --rm --network host -it docker.io/usql/usql:latest postgres://postgres:P4ssw0rd@localhost
Connected with driver postgres (PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1))
Type "help" for help.

pg:postgres@localhost=> \q

# run specific usql version
$ docker run --rm -it docker.io/usql/usql:0.21.5

# build/install with every driver
$ go install github.com/xo/usql@main

# build/install every driver except Avatica, Couchbase and PostgreSQL
$ go install -tags 'no_avatica no_couchbase no_postgres' github.com/xo/usql@main

# build/install with only the SQLite3 driver
$ go install -tags 'no_drivers sqlite3' github.com/xo/usql@main

# build/install with only the PostgreSQL and MySQL drivers
$ go install -tags 'no_drivers pgx mysql' github.com/xo/usql@main

$ cd $GOPATH/src/github.com/xo/usql

# build with only the cassandra, moderncsqlite and mysql drivers
$ go build -tags 'no_drivers cassandra moderncsqlite mysql'

# show built driver support
$ ./usql -c '\drivers'
Available Drivers:
  cassandra [ca, cql, scy, cass, scylla, datastax]
  moderncsqlite [sq, mq, sqlite, sqlite3, modernsqlite]
  mysql [my, maria, aurora, mariadb, percona]

# connect to a vitess database:
$ usql vt://user:pass@host:3306/mydatabase

$ usql
(not connected)=> \c vitess://user:pass@host:3306/mydatabase

$ usql
(not connected)=> \copy csvq://. pg://localhost/ 'select * ....' 'myTable'

# connect to a postgres database
$ usql postgres://booktest@localhost/booktest

# connect to an oracle database
$ usql oracle://user:pass@host/oracle.sid

# connect to a postgres database and run the commands contained in script.sql
$ usql pg://localhost/ -f script.sql

$ usql --help
usql, the universal command-line interface for SQL databases

Usage:
  usql [flags]... [DSN]

Arguments:
  DSN   database url or connection name

Flags:
  -c, --command COMMAND                     run only single command (SQL or internal) and exit
  -f, --file FILE                           execute commands from file and exit
  -w, --no-password[=true|false]            never prompt for password
  -X, --no-init[=true|false]                do not execute initialization scripts (aliases: --no-rc --no-psqlrc --no-usqlrc)
  -o, --out FILE                            output file
  -W, --password[=true|false]               force password prompt (should happen automatically)
  -1, --single-transaction[=true|false]     execute as a single transaction (if non-interactive)
  -v, --set NAME=VALUE                      set script variable NAME to VALUE (see \set command, aliases: --var --variable)
  -U, --uset NAME=VALUE                     set setting NAME of usql to VALUE (see \uset command)
  -N, --cset NAME=DSN                       set named connection NAME to DSN (see \cset command)
  -P, --pset VAR=ARG                        set printing option VAR to ARG (see \pset command)
  -F, --field-separator FIELD-SEPARATOR     field separator for unaligned and CSV output (default "|" and ",")
  -R, --record-separator RECORD-SEPARATOR   record separator for unaligned and CSV output (default \n)
  -T, --table-attr TABLE-ATTR               set HTML table tag attributes (e.g., width, border)
  -A, --no-align                            unaligned table output mode
  -H, --html                                HTML table output mode
  -t, --tuples-only                         print rows only
  -x, --expanded                            turn on expanded table output
  -z, --field-separator-zero                set field separator for unaligned and CSV output to zero byte
  -0, --record-separator-zero               set record separator for unaligned and CSV output to zero byte
  -J, --json                                JSON output mode
  -C, --csv                                 CSV output mode
  -G, --vertical                            vertical output mode
  -M, --markdown                            markdown output mode
  -q, --quiet                               run quietly (no messages, only query output)
      --config string                       config file
  -V, --version[=true|false]                output version information, then exit
  -?, --help[=true|false]                   show this help, then exit

# connect to postgres using the local $USER and the unix domain socket in /var/run/postgresql
$ usql pg://

$ USQL_DSN="pg://app:$PASSWORD@localhost:15432/app" usql

# the Service, StatefulSet or pod pg in the namespace prod
$ usql k://pg.prod/app

# the CloudNativePG cluster pg, with another context
$ usql 'k8s+cnpg://pg.prod/app?context=staging'

# connect to a postgres database
$ usql pg://user:pass@host/dbname
$ usql pgsql://user:pass@host/dbname
$ usql postgres://user:pass@host:port/dbname
$ usql pg://
$ usql /var/run/postgresql
$ usql pg://user:pass@host/dbname?sslmode=disable # Connect without SSL

# connect to a mysql database
$ usql my://user:pass@host/dbname
$ usql mysql://user:pass@host:port/dbname
$ usql my://
$ usql /var/run/mysqld/mysqld.sock

# connect to a sqlserver database
$ usql sqlserver://user:pass@host/instancename/dbname
$ usql ms://user:pass@host/dbname
$ usql ms://user:pass@host/instancename/dbname
$ usql mssql://user:pass@host:port/dbname
$ usql ms://

# connect to a sqlserver database using Windows domain authentication
$ runas /user:ACME\wiley /netonly "usql mssql://host/dbname/"

# connect to a oracle database
$ usql or://user:pass@host/sid
$ usql oracle://user:pass@host:port/sid
$ usql or://

# connect to a cassandra database
$ usql ca://user:pass@host/keyspace
$ usql cassandra://host/keyspace
$ usql cassandra://host/
$ usql ca://

# connect to an alibaba maxcompute project over https, or over http with tls=false:
$ usql "mc://accessid:accesskey@service.cn-hangzhou.maxcompute.aliyun.com/myproject"
$ usql "mc://accessid:accesskey@host/myproject?region=cn-hangzhou&tls=false"

# connect to an alibaba tablestore instance, where the host
# myinstance.cn-hangzhou becomes myinstance.cn-hangzhou.ots.aliyuncs.com:
$ usql "tablestore://accessid:accesssecret@myinstance.cn-hangzhou/myinstance"

# connect to a sqlite database that exists on disk
$ usql dbname.sqlite3

# Note: when connecting to a SQLite database, if the "driver://" or
# "driver:" scheme/alias is omitted, the file must already exist on disk.
#
# if the file does not yet exist, the URL must incorporate file:, sq:, sqlite3:,
# or any other recognized sqlite3 driver alias to force usql to create a new,
# empty database at the specified path:
$ usql sq://path/to/dbname.sqlite3
$ usql sqlite3://path/to/dbname.sqlite3
$ usql file:/path/to/dbname.sqlite3

# connect to a named connection in config.yaml (see Configuration below for
# where it is on each system)
$ cat $HOME/.config/usql/config.yaml
connections:
  my_named_connection: sqlserver://user:pass@localhost/
$ usql my_named_connection

# connect with ODBC driver (needs the ODBC driver manager of the system)
$ cat /etc/odbcinst.ini
[PostgreSQL ANSI]
Description=PostgreSQL ODBC driver (ANSI version)
Driver=psqlodbca.so
Setup=libodbcpsqlS.so
Debug=0
CommLog=1
UsageCount=1

# connect to a postgres database using the odbc config above
$ usql odbc+PostgreSQL+ANSI://user:pass@localhost/dbname?TraceFile=/path/to/trace.log

$ usql sqlserver://sa:pass@localhost
Connected with driver sqlserver (Microsoft SQL Server 2025 17.0.5005.3, RTM-CU9, Enterprise Developer Edition (64-bit))
Type "help" for help.

ms:sa@localhost/master=> select * from authors;
 author_id |     name
-----------+--------------
         1 | Isaac Asimov
         2 | Stephen King
(2 rows)

ms:sa@localhost/master=> select title from books
ms:sa@localhost/master-> where author_id = 2
ms:sa@localhost/master-> \p
select title from books
where author_id = 2
ms:sa@localhost/master-> \g
 title
--------
 Carrie
 Cujo
(2 rows)

ms:sa@localhost/master=>

(not connected)=> \c postgres://user:pass@localhost
pg:user@localhost=> select * from my_table \G

$ usql
Type "help" for help.

(not connected)=> \?
General
  \q                                quit usql
  \copyright                        show usage and distribution terms for usql
  \drivers                          show database drivers available to usql

Help
  \? [commands]                     show help on usql's meta (backslash) commands
  \? options                        show help on usql command-line options
  \? variables                      show help on special usql variables

Connection
  \c DSN or \c NAME                 connect to dsn or named database connection
  \c DRIVER PARAMS...               connect to database with driver and parameters
  \Z                                close (disconnect) database connection
  \password [USER]                  change password for user
  \conninfo [-password]             display information about the current database connection,
                                    with the password when -password is given
  \k[+] [OPTIONS] [SCOPE]           list databases in Kubernetes, with the URL for \c (OPTIONS:
                                    -A, -n NAMESPACE, --context NAME)

Query Execute
  \g [(OPTIONS)] [FILE] or ;        execute query (and send results to file or |pipe)
  \G [(OPTIONS)] [FILE]             as \g, but forces vertical output mode
  \gx [(OPTIONS)] [FILE]            as \g, but forces expanded output mode
  \gexec                            execute query and execute each value of the result
  \gset [PREFIX]                    execute query and store results in usql variables
  \bind [PARAM]...                  set query parameters
  \timing [on|off]                  toggle timing of commands

Query View
  \crosstab [(OPTIONS)] [COLUMNS]   execute query and display results in crosstab
  \chart CHART [(OPTIONS)]          execute query and display results as a chart
  \watch [(OPTIONS)] [INTERVAL]     execute query every specified interval

Query Buffer
  \e [-raw|-exec] [FILE] [LINE]     edit the query buffer, raw (non-interpolated) buffer, the
                                    exec buffer, or a file with external editor
  \p [-raw|-exec]                   show the contents of the query buffer, the raw
                                    (non-interpolated) buffer or the exec buffer
  \w [-raw|-exec] FILE              write the contents of the query buffer, raw
                                    (non-interpolated) buffer, or exec buffer to file
  \r                                reset (clear) the query buffer
  \ef [FUNCNAME [LINE]]             edit function definition with external editor
  \ev [VIEWNAME [LINE]]             edit view definition with external editor

Informational
  \d[S+] [NAME]                     list tables, views, and sequences or describe table, view,
                                    sequence, or index
  \da[S+] [PATTERN]                 list aggregates
  \dA[+] [PATTERN]                  list access methods
  \dAc[+] [AMPTRN [PATTERN]]        list operator classes
  \dAf[+] [AMPTRN [PATTERN]]        list operator families
  \dAo[+] [AMPTRN [PATTERN]]        list operators of operator families
  \dAp[+] [AMPTRN [PATTERN]]        list support functions of operator families
  \db[+] [PATTERN]                  list tablespaces
  \dc[S+] [PATTERN]                 list conversions
  \dconfig[+] [PATTERN]             list configuration parameters
  \dC[+] [PATTERN]                  list casts
  \dd[S] [PATTERN]                  show object descriptions not displayed elsewhere
  \dD[S+] [PATTERN]                 list domains
  \ddp [PATTERN]                    list default privileges
  \dE[S+] [PATTERN]                 list foreign tables
  \des[+] [PATTERN]                 list foreign servers
  \det[+] [PATTERN]                 list foreign tables and their servers
  \deu[+] [PATTERN]                 list user mappings
  \dew[+] [PATTERN]                 list foreign-data wrappers
  \df[anptw][S+] [PATTERN]          list [only agg/normal/procedure/trigger/window] functions
  \dF[+] [PATTERN]                  list text search configurations
  \dFd[+] [PATTERN]                 list text search dictionaries
  \dFp[+] [PATTERN]                 list text search parsers
  \dFt[+] [PATTERN]                 list text search templates
  \dg[S+] [PATTERN]                 list roles
  \di[S+] [PATTERN]                 list indexes
  \dl[+]                            list large objects, same as \lo_list
  \dL[S+] [PATTERN]                 list procedural languages
  \dm[S+] [PATTERN]                 list materialized views
  \dn[S+] [PATTERN]                 list schemas
  \do[S+] [PATTERN]                 list operators
  \dO[S+] [PATTERN]                 list collations
  \dp[S] [PATTERN]                  list table, view, and sequence access privileges
  \dP[itn+] [PATTERN]               list [only index/table] partitioned relations [n=nested]
  \drds [ROLEPTRN [DBPTRN]]         list per-database role settings
  \drg[S] [PATTERN]                 list role grants
  \dRp[+] [PATTERN]                 list replication publications
  \dRs[+] [PATTERN]                 list replication subscriptions
  \ds[S+] [PATTERN]                 list sequences
  \dt[S+] [PATTERN]                 list tables
  \dT[S+] [PATTERN]                 list data types
  \du[S+] [PATTERN]                 list roles
  \dv[S+] [PATTERN]                 list views
  \dx[+] [PATTERN]                  list extensions
  \dX [PATTERN]                     list extended statistics
  \dy[+] [PATTERN]                  list event triggers
  \l[+] [PATTERN]                   list databases
  \z[S] [PATTERN]                   same as \dp
  \sf[+] FUNCNAME                   show a function's definition
  \sv[+] VIEWNAME                   show a view's definition
  \ss[+] TABLE [k]                  show stats for the columns of a table

Variables
  \set [NAME [VALUE]]               set script variable, or show all script variables if no
                                    parameters
  \uset [NAME [VALUE]]              set a setting of usql, show it if there is no value, or
                                    show all settings if no parameters
  \unset NAME                       unset (delete) script variable
  \pset [NAME [VALUE]]              set table print formatting option, or show all print
                                    formatting options if no parameters
  \cset [NAME [URL]]                set named connection, or show all named connections if no
                                    parameters
  \cset NAME DRIVER PARAMS...       set named connection for driver and parameters
  \prompt [-TYPE] VAR [PROMPT]      prompt user to set application variable

Input/Output
  \echo [-n] [MESSAGE]...           write message to standard output (-n for no newline)
  \qecho [-n] [MESSAGE]...          write message to \o output stream (-n for no newline)
  \warn [-n] [MESSAGE]...           write message to standard error (-n for no newline)
  \o [FILE]                         send all query results to file or |pipe
  \copy SRC DST QUERY TABLE         copy results of query from source database into table on
                                    destination database
  \copy SRC DST QUERY TABLE(A,...)  copy results of query from source database into table's
                                    columns on destination database

Control/Conditional
  \i FILE                           execute commands from file
  \ir FILE                          as \i, but relative to location of current script
  \if EXPR                          begin conditional block
  \elif EXPR                        alternative within current conditional block
  \else                             final alternative within current conditional block
  \endif                            end conditional block

Transaction
  \begin [-read-only [ISOLATION]]   begin transaction, with optional isolation level
  \commit                           commit current transaction
  \rollback                         rollback (abort) current transaction

Operating System/Environment
  \! [COMMAND]                      execute command in shell or start interactive shell
  \cd [DIR]                         change the current working directory
  \getenv VARNAME ENVVAR            fetch environment variable
  \setenv NAME [VALUE]              set or unset environment variable
(not connected)=>

$ usql my_oracle_conn
Connected with driver oracle (Oracle Database 23.0.0.0.0)
Type "help" for help.

or:system@localhost/free=>

(not connected)=> \unset FOO
(not connected)=> \set FOO bar
(not connected)=>

(not connected)=> \set
FOO = 'bar'
(not connected)=>

ms:sa@localhost/master=> \set FOO 'Stephen King'
ms:sa@localhost/master=> select * from authors where name = :'FOO';
 author_id |     name
-----------+--------------
         2 | Stephen King
(1 row)

ms:sa@localhost/master=>

ms:sa@localhost/master=> \set TBLNAME authors
ms:sa@localhost/master=> \set COLNAME name
ms:sa@localhost/master=> \set FOO 'Isaac Asimov'
ms:sa@localhost/master=> select * from :TBLNAME where :"COLNAME" = :'FOO'
ms:sa@localhost/master->

ms:sa@localhost/master=> select * from :TBLNAME where :"COLNAME" = :'FOO'
ms:sa@localhost/master-> \p
select * from authors where "name" = 'Isaac Asimov'
ms:sa@localhost/master-> \raw
select * from :TBLNAME where :"COLNAME" = :'FOO'
ms:sa@localhost/master->

ms:sa@localhost/master=> select ':FOO' as foo;
 foo
------
 :FOO
(1 row)

ms:sa@localhost/master=> \p
select ':FOO' as foo;
ms:sa@localhost/master=>

(not connected)=> \cset my_conn sqlserver://sa:pass@localhost
(not connected)=> \c my_conn
Connected with driver sqlserver (Microsoft SQL Server 2025 17.0.5005.3, RTM-CU9, Enterprise Developer Edition (64-bit))
ms:sa@localhost/master=>

(not connected)=> \cset
my_conn = 'postgres://user:pass@localhost'
(not connected)=>

(not connected)=> \pset time Kitchen
Time display is "Kitchen" ("3:04PM").
(not connected)=> \a
Output format is unaligned.
(not connected)=>

(not connected)=> \pset
border                   1
columns                  0
csv_fieldsep             ","
expanded                 off
fieldsep                 "|"
fieldsep_zero            off
footer                   on
format                   aligned
header_align             center
json_indent              0
linestyle                ascii
locale                   C
null                     ""
numericlocale            off
pager                    off
pager_min_lines          0
recordsep                "\n"
recordsep_zero           off
tableattr
time                     Kitchen
timezone
title
tuples_only              off
unicode_border_linestyle single
unicode_column_linestyle single
unicode_header_linestyle single
(not connected)=>

(not connected)=> \uset pager "less -R"
pager is "less -R"
(not connected)=> \uset on_error_stop on
on_error_stop is on
(not connected)=> \uset
echo_hidden           off
editor                ""
encoding              utf-8
fetch_count           0
on_error_stop         on
pager                 "less -R"
prompt1               "%S%N%m%/%R%# "
prompt2               "%S%N%m%/%R%# "
quiet                 off
show_host_information true
sslmode               retry
syntax_hl             true
syntax_hl_format      terminal256
syntax_hl_override_bg true
syntax_hl_style       monokai
term_graphics
(not connected)=>

$ usql --uset encoding=windows-1252 -f legacy.sql pg://

(not connected)=> \? variables

(not connected)=> \echo Welcome `echo $USER` -- 'running on:' "(" `uname -s` ")"
Welcome user -- running on: ( Linux )
(not connected)=>

(not connected)=> \set MYVAR `uname -s`
(not connected)=> \set
MYVAR = 'Linux'
(not connected)=> \echo :MYVAR
Linux
(not connected)=>

(not connected)=> \cset PGDSN postgres://user:pass@localhost
(not connected)=> \cset MYDSN mysql://user:pass@localhost
(not connected)=> \copy PGDSN MYDSN 'select book_id, author_id from books' 'books(id, author_id)'

(not connected)=> \cset MYDSN mysql://user:pass@localhost
(not connected)=> \copy postgres://user:pass@localhost MYDSN 'select book_id, author_id from books' 'books(id, author_id)'

$ usql
(not connected)=> echo :SOURCE_DSN :DESTINATION_DSN
pg://postgres:P4ssw0rd@localhost/ mysql://localhost
(not connected)=> \copy :SOURCE_DSN :DESTINATION_DSN 'select * from mySourceTable' 'myDestination(colA, colB)'
COPY 2

$ usql
(not connected)=> \copy csvq:. sq:test.db 'select * from authors' authors
error: failed to prepare insert query: 2 values for 1 columns
(not connected)=> \copy csvq:. sq:test.db 'select name from authors' authors(name)
COPY 2

$ usql
(not connected)=> \copy postgres://user:pass@localhost mysql://user:pass@localhost 'SELECT uuid_column::TEXT FROM myPgTable' myMyTable
COPY 1

$ cat authors.csv
author_id,name
1,Isaac Asimov
2,Stephen King
$ cat books.csv
book_id,author_id,title
1,1,I Robot
2,2,Carrie
3,2,Cujo
$ usql
Type "help" for help.

(not connected)=> -- setting variables to make connections easier
(not connected)=> \set SOURCE_DSN csvq://.
(not connected)=> \set DESTINATION_DSN sqlite3:booktest.db
(not connected)=> -- connecting to the destination and creating the schema
(not connected)=> \c :DESTINATION_DSN
Connected with driver sqlite3 (SQLite 3.54.1)
sq:booktest.db=> create table authors (author_id integer, name text);
CREATE TABLE
sq:booktest.db=> create table books (book_id integer not null primary key autoincrement, author_id integer, title text);
CREATE TABLE
sq:booktest.db=> -- adding an extra row to books prior to copying
sq:booktest.db=> insert into books (author_id, title) values (1, 'Foundation');
INSERT 1
sq:booktest.db=> -- disconnecting to demonstrate that \copy opens new database connections
sq:booktest.db=> \disconnect
(not connected)=> -- copying data from SOURCE -> DESTINATION
(not connected)=> \copy :SOURCE_DSN :DESTINATION_DSN 'select * from authors' authors
COPY 2
(not connected)=> \copy :SOURCE_DSN :DESTINATION_DSN 'select author_id, title from books' 'books(author_id, title)'
COPY 3
(not connected)=> \c :DESTINATION_DSN
Connected with driver sqlite3 (SQLite 3.54.1)
sq:booktest.db=> select * from authors;
 author_id |     name
-----------+--------------
         1 | Isaac Asimov
         2 | Stephen King
(2 rows)

sq:booktest.db=> select * from books;
 book_id | author_id |   title
---------+-----------+------------
       1 |         1 | Foundation
       2 |         1 | I Robot
       3 |         2 | Carrie
       4 |         2 | Cujo
(4 rows)

sq:booktest.db=>

$ cat $HOME/.config/usql/config.yaml
connections:
  pglocal: postgres://postgres:P4ssw0rd@localhost:49153?sslmode=disable
  orlocal: oracle://system:P4ssw0rd@localhost:1521/orasid
$ usql
Type "help" for help.

(not connected)=> \copy pglocal orlocal 'select staff_id, first_name from staff' 'staff(staff_id, first_name)'
COPY 18

$ usql
Type "help" for help.

(not connected)=> \uset syntax_hl_style dracula
syntax_hl_style is dracula
(not connected)=> \uset syntax_hl off
syntax_hl is false
(not connected)=>

$ usql sqlserver://sa:pass@localhost
Connected with driver sqlserver (Microsoft SQL Server 2025 17.0.5005.3, RTM-CU9, Enterprise Developer Edition (64-bit))
Type "help" for help.

ms:sa@localhost/master=> select * f
 1 from
 2 fetch
 3 full outer join

$ usql sqlserver://sa:pass@localhost
Connected with driver sqlserver (Microsoft SQL Server 2025 17.0.5005.3, RTM-CU9, Enterprise Developer Edition (64-bit))
Type "help" for help.

ms:sa@localhost/master=> \g
 1 \g        4 \gset
 2 \go       5 \gexec
 3 \gx       6 \getenv

$ usql sqlserver://sa:pass@localhost
Connected with driver sqlserver (Microsoft SQL Server 2025 17.0.5005.3, RTM-CU9, Enterprise Developer Edition (64-bit))
Type "help" for help.

ms:sa@localhost/master=> \pset time
Time display is "RFC3339Nano" ("2006-01-02T15:04:05.999999999Z07:00").
ms:sa@localhost/master=> select cast('2026-10-31 09:41:27.123456' as datetime2) as stamp;
            stamp
-----------------------------
 2026-10-31T09:41:27.123456Z
(1 row)

ms:sa@localhost/master=> \pset time Kitchen
Time display is "Kitchen" ("3:04PM").
ms:sa@localhost/master=> select cast('2026-10-31 09:41:27.123456' as datetime2) as stamp;
 stamp
--------
 9:41AM
(1 row)

ms:sa@localhost/master=>

$ export USQL_SHOW_HOST_INFORMATION=false
$ usql sqlserver://sa:pass@localhost
Type "help" for help.

ms:sa@localhost/master=>

$ usql --uset show_host_information=false sqlserver://sa:pass@localhost
Type "help" for help.

ms:sa@localhost/master=> \uset show_host_information true
show_host_information is true
ms:sa@localhost/master=> \connect sqlserver://sa:pass@localhost
Connected with driver sqlserver (Microsoft SQL Server 2025 17.0.5005.3, RTM-CU9, Enterprise Developer Edition (64-bit))
ms:sa@localhost/master=>

# disable
$ USQL_TERM_GRAPHICS=none usql

# force iterm graphics
$ TERM_GRAPHICS=iterm usql

$ cat $HOME/.config/usql/init.sql
\echo WELCOME TO THE JUNGLE `date`
\uset syntax_hl_style paraiso-dark

-- set color prompt (default is prompt is "%S%m%/%R%#" )
\uset prompt1 "\033[32m%S%m%/%R%#\033[0m"
$ usql
WELCOME TO THE JUNGLE Thu Jun 14 02:36:53 WIB 2018
Type "help" for help.

(not connected)=> \uset syntax_hl_style
syntax_hl_style is "paraiso-dark"
(not connected)=>

$ usql --no-init pg://

$ usql
dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicuuc.68.dylib
  Referenced from: /Users/user/.local/bin/usql
  Reason: image not found
Abort trap: 6

$ brew install icu4c
Running `brew update --auto-update`...
==> Downloading ...
...

$ usql
(not connected)=>

# every driver, with the SQLite of the system
$ go install -tags libsqlite3 github.com/xo/usql@main

# only the ODBC driver
$ go install -tags 'no_drivers odbc libsqlite3' github.com/xo/usql@main

$ usql "couchbase://user:pass@localhost/?durability_level=none"

$ usql "couchbase://user:pass@localhost/?txtimeout=2m"