Table of Contents

About

How to list connection with the tabul connection list command

Steps

Listing all connections

tabul connection list
# or
# tabul connection list '*'
# The quotes are mandatory because a star in a bash shell will expand to files

name            uri
-------------   ------------------------------------------------------------------------
cd              file:///home/tabulify/
data-home       file:///home/admin/.local/share/tabul/
desktop         file:///home/tabulify/Desktop
entity          file:///opt/tabulify/resources/entity/
home            file:///home/tabulify/
howto           file:///opt/tabulify/resources/howto/
log             file:///home/tabulify/.tabul/logs/
memory          mem:/
mysql           jdbc:mysql://localhost:3306/howto
noop            noop
oracle          jdbc:oracle:thin:@localhost:1521/freepdb1
postgres        jdbc:postgresql://localhost:5432/postgres
smtp            smtp://localhost:1025
sqlite          jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3
sqlite_target   jdbc:sqlite:////home/tabulify/.tabul/sqlite_target.sqlite3
sqlserver       jdbc:sqlserver://localhost:1433;encrypt=true;trustServerCertificate=true
tmp             file:///mnt/wslg/runtime-dir/tabul/
tpcds           tpcds
tpcds_query     file:///opt/tabulify/resources/tpcds_query/

Listing a subset with globbing

  • List only the connections with sql in their name by using a glob pattern
tabul connection list *sql*

name            uri
-------------   ------------------------------------------------------------------------
mysql           jdbc:mysql://localhost:3306/howto
sqlite          jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3
sqlite_target   jdbc:sqlite:////home/tabulify/.tabul/sqlite_target.sqlite3
sqlserver       jdbc:sqlserver://localhost:1433;encrypt=true;trustServerCertificate=true

Listing only a set of connections

tabul connection list oracle sqlite

name     uri
------   ---------------------------------------------------
oracle   jdbc:oracle:thin:@localhost:1521/freepdb1
sqlite   jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3

Choosing the attributes to return

List the connections with the name, user and url connection attribute 

tabul connection list -a name -a user -a uri
# or
# tabul connection list -a name -a user -a uri '*'
# The quotes are mandatory because a star in a bash shell will expand to files

name            user       uri
-------------   --------   ------------------------------------------------------------------------
cd                         file:///home/tabulify/
data-home                  file:///home/admin/.local/share/tabul/
desktop                    file:///home/tabulify/Desktop
entity                     file:///opt/tabulify/resources/entity/
home                       file:///home/tabulify/
howto                      file:///opt/tabulify/resources/howto/
log                        file:///home/tabulify/.tabul/logs/
memory                     mem:/
mysql           root       jdbc:mysql://localhost:3306/howto
noop                       noop
oracle          system     jdbc:oracle:thin:@localhost:1521/freepdb1
postgres        postgres   jdbc:postgresql://localhost:5432/postgres
smtp                       smtp://localhost:1025
sqlite                     jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3
sqlite_target              jdbc:sqlite:////home/tabulify/.tabul/sqlite_target.sqlite3
sqlserver       sa         jdbc:sqlserver://localhost:1433;encrypt=true;trustServerCertificate=true
tmp                        file:///mnt/wslg/runtime-dir/tabul/
tpcds                      tpcds
tpcds_query                file:///opt/tabulify/resources/tpcds_query/