USQL is a universal command-line interface for working with SQL databases written in Go which support PostgreSQL, MySQL, Oracle, SQLite, and Microsoft SQL Server. The goal is to eventually have usql be a drop in replacement for PostgreSQL’s psql command, with all the bells/whistles, but with the added benefit of working with more than one database.

The screenshot below show an example of connecting to xo’s booktest example Oracle database, performing a query, and then connecting to the PostgreSQL, MySQL, Microsoft SQL Server, and SQLite3 databases and executing various queries.

Install it in the usual Go way :

# install usql
$ go get -u github.com/knq/usql

# install with oracle support
$ go get -u -tags oracle github.com/knq/usql

Notice that the tool have some issues in its todos such as fixing –command/-c execution, all the various \d* commands from psql, and supporting SQL completion. Released under an MIT license.

More information at https://github.com/knq/usql

LEAVE A REPLY

Please enter your comment!
Please enter your name here