AppleScript

tell application "TablePro"
  set result to run query "SELECT id, email FROM users LIMIT 5" in connection "Production"
  columns of result --> {"id", "email"}
  row count of result --> 5
  values of item 1 of rows of result --> {"1", "[email protected]"}
end tell

application
└── connection
    └── tab

tell application "TablePro"
  name of every connection
  connection id "9f1f0c3e-2e3d-4b14-9c3a-1d2f4ad1f6f1"
  every connection whose connected is true
end tell

run query "SELECT 1" in connection "Production" ¬
  database "analytics" schema "public" row limit 1000 timeout 60

tell application "TablePro"
  set t to open table "orders" in connection "Production" schema "public"
  row count of current result of t
end tell

tell application "TablePro"
  connect connection "Production"
  show connection "Production"
  disconnect connection "Production"
end tell

tell application "TablePro"
  focus tab 1 of connection "Production"
end tell

tell application "TablePro"
  set picked to selection of current tab
  repeat with r in rows of picked
    log item 1 of values of r
  end repeat
end tell

try
  tell application "TablePro"
    run query "DELETE FROM users" in connection "Production"
  end tell
on error message number code
  message --> "This connection is read only for external clients."
end try