require 'net/ssh/gateway'
require 'mysql2'

gateway = Net::SSH::Gateway.new(
  'your-mysql-box-ip-address',
  'your-ssh-username-here',
  :password => 'your-ssh-password-here'
)
port = gateway.open('127.0.0.1', 3306, 3307)

client = Mysql2::Client.new(
  host: "127.0.0.1",
  username: 'your-username-here',
  password: 'your-password-here',
  database: 'your-database-name',
  port: port
)

results = client.query("SELECT * FROM neto_orders WHERE Order_ID=\'#{prefix}#{order_number}\' and Order_Line_SKU=\'#{line['SKU']}\'")