isql

TLDR

Connect to data source

$ isql [dsn_name]

Connect with credentials

$ isql [dsn_name] [username] [password]

Execute query from file

$ isql [dsn] -i [query.sql]

Output to file

$ isql [dsn] < [query.sql] > [output.txt]

Verbose mode

$ isql -v [dsn]

No header output

$ isql -b [dsn]

SYNOPSIS

isql [options] dsn [user] [password]

isql is an ODBC command-line SQL client. It connects to any database with an ODBC driver.
The tool executes SQL queries interactively or from files. It provides database-agnostic access through ODBC.
isql is an ODBC SQL client.

PARAMETERS

DSN

Data source name from odbc.ini.

USER

Database username.

PASSWORD

Database password.

-v

Verbose mode.

-b

Batch mode (no headers).

-d DELIM

Column delimiter.

-i FILE

Input file.

--help

Display help information.

CAVEATS

Requires ODBC drivers. DSN must be configured. Part of unixODBC.

HISTORY

isql is part of unixODBC, providing command-line database access through the Open Database Connectivity standard.