Skip to content


Subversion checkout URL

You can clone with
Download ZIP
Shell for issuing SQL to relational databases via JDBC
Java Other
Latest commit 6049893 @parthchandra parthchandra committed with Add WrappedSqlException to allow IncrementalRows to throw a SQLExcept…
…ion (Parth Chandra)

Add JMockit dependency; force JMockit to be loaded before JUnit (needed for Java 6 build)

Minor fix-ups by Julian Hyde
Failed to load latest commit information.
bin Add sqlline and sqlline.bat scripts, and jar-with-dependencies (Jongy…
doc A lot of changes made by the Eigenbase/LucidDB project.
src Add WrappedSqlException to allow IncrementalRows to throw a SQLExcept…
.travis.yml Enable oraclejdk8 in Travis CI. Change distribution to Maven Central
LICENSE Shorten file headers, moving copyright notices, license text and (lac…
NOTICE Add release notes and history. Switch to "scott-data-hsqldb" as test data set; it is smaller than "f…
pom.xml Add WrappedSqlException to allow IncrementalRows to throw a SQLExcept…

Build Status

Command-line shell for issuing SQL to relational databases via JDBC.


A fork of the Marc Prud'hommeaux's sqlline project, also incorporating changes made by the LucidDB project, now modernized, mavenized and forkable in github.

License and distribution

sqlline is distributed under the 3-clause BSD License, meaning that you are free to redistribute, modify, or sell it with almost no restrictions.

It is distributed via the Maven Central Repository.

Getting started

Copy the sqlline script (or sqlline.bat for Windows), sqlline-VERSION-jar-with-dependencies.jar and a JDBC driver jar into the same directory. (Or just put sqlline on your PATH.)

$ sqlline -d com.mysql.jdbc.Driver
sqlline> !connect jdbc:mysql://localhost:3306/scott user password
sqlline> !tables
| null       | SCOTT        | BONUS       | TABLE         | null     |
| null       | SCOTT        | DEPT        | TABLE         | null     |
| null       | SCOTT        | EMP         | TABLE         | null     |
| null       | SCOTT        | SALGRADE    | TABLE         | null     |
| null       | metadata     | COLUMNS     | SYSTEM_TABLE  | null     |
| null       | metadata     | TABLES      | SYSTEM_TABLE  | null     |
sqlline> SELECT 1 + 2 AS c;
| C |
| 3 |
sqlline> !quit

To get help:

sqlline --help

If you prefer, you can invoke Java directly, without using the sqlline script:

$ java -jar sqlline-VERSION-jar-with-dependencies.jar --help

Read the manual.

Maven Usage

Use the following definition to use sqlline in your maven project:




  • Maven 3.2.1 or higher
  • Java 1.5 or higher (1.8 preferred)

Check out and build:

git clone git://
cd sqlline
mvn package


More information

Something went wrong with that request. Please try again.