---
name: "sqlline"
section: "1"
platform: "linux"
package: "sqlline"
version: "1.0.2-9"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/sqlline"
---

# sqlline(1)

JDBC command-line utility for issuing SQL

## NAME

sqlline - JDBC command-line utility for issuing SQL

## SYNOPSIS

**sqlline** \[ *option...* \]

## DESCRIPTION

- **-u** \<database url\>

  the JDBC URL to connect to

- **-n** \<username\>

  the username to connect as

- **-p** \<password\>

  the password to connect as

- **-d** \<driver class\>

  the driver class to use

- **--color**=*\[true*/false\]

  control whether color is used for display

- **--showHeader**=*\[true*/false\]

  show column names in query results

- **--headerInterval**=*ROWS*;

  the interval between which heades are displayed

- **--fastConnect**=*\[true*/false\]

  skip building table/column list for tab-completion

- **--autoCommit**=*\[true*/false\]

  enable/disable automatic transaction commit

- **--verbose**=*\[true*/false\]

  show verbose error messages and debug info

- **--showWarnings**=*\[true*/false\]

  display connection warnings

- **--force**=*\[true*/false\]

  continue running script even after errors

- **--maxWidth**=*MAXWIDTH*

  the maximum width of the terminal

- **--maxColumnWidth**=*MAXCOLWIDTH*

  the maximum width to use when displaying columns

- **--silent**=*\[true*/false\]

  be more silent

- **--autosave**=*\[true*/false\]

  automatically save preferences

- **--outputformat**=*\[table*/vertical/csv/tsv\]

  format mode for result display

- **--isolation**=*LEVEL*

  set the transaction isolation level

- **--help**

  display this message

Usage: java sqlline.SqlLine

- **-u** \<database url\>

  the JDBC URL to connect to

- **-n** \<username\>

  the username to connect as

- **-p** \<password\>

  the password to connect as

- **-d** \<driver class\>

  the driver class to use

- **--color**=*\[true*/false\]

  control whether color is used for display

- **--showHeader**=*\[true*/false\]

  show column names in query results

- **--headerInterval**=*ROWS*;

  the interval between which heades are displayed

- **--fastConnect**=*\[true*/false\]

  skip building table/column list for tab-completion

- **--autoCommit**=*\[true*/false\]

  enable/disable automatic transaction commit

- **--verbose**=*\[true*/false\]

  show verbose error messages and debug info

- **--showWarnings**=*\[true*/false\]

  display connection warnings

- **--force**=*\[true*/false\]

  continue running script even after errors

- **--maxWidth**=*MAXWIDTH*

  the maximum width of the terminal

- **--maxColumnWidth**=*MAXCOLWIDTH*

  the maximum width to use when displaying columns

- **--silent**=*\[true*/false\]

  be more silent

- **--autosave**=*\[true*/false\]

  automatically save preferences

- **--outputformat**=*\[table*/vertical/csv/tsv\]

  format mode for result display

- **--isolation**=*LEVEL*

  set the transaction isolation level

- **--help**

  display this message

- **-u** \<database url\>

  the JDBC URL to connect to

- **-n** \<username\>

  the username to connect as

- **-p** \<password\>

  the password to connect as

- **-d** \<driver class\>

  the driver class to use

- **--color**=*\[true*/false\]

  control whether color is used for display

- **--showHeader**=*\[true*/false\]

  show column names in query results

- **--headerInterval**=*ROWS*;

  the interval between which heades are displayed

- **--fastConnect**=*\[true*/false\]

  skip building table/column list for tab-completion

- **--autoCommit**=*\[true*/false\]

  enable/disable automatic transaction commit

- **--verbose**=*\[true*/false\]

  show verbose error messages and debug info

- **--showWarnings**=*\[true*/false\]

  display connection warnings

- **--force**=*\[true*/false\]

  continue running script even after errors

- **--maxWidth**=*MAXWIDTH*

  the maximum width of the terminal

- **--maxColumnWidth**=*MAXCOLWIDTH*

  the maximum width to use when displaying columns

- **--silent**=*\[true*/false\]

  be more silent

- **--autosave**=*\[true*/false\]

  automatically save preferences

- **--outputformat**=*\[table*/vertical/csv/tsv\]

  format mode for result display

- **--isolation**=*LEVEL*

  set the transaction isolation level

- **--help**

  display this message