mysql

# mysql::client would provide access to a database for mysql::record
mysql::client { 'my_database':
  host     => 'example.com',
  database => 'database_name',
  username => 'user',
  password => 'password'
}

# this would ensure that the query
# SELECT field_1, field2 FROM my_database.my_table WHERE table_id = 'my key'
# returns a single row with "field 1 value" and "field 2 value"
mysql::record {
  database    => 'my_database',
  table       => 'my_table',
  primary_key => 'table_id',
  fields      => {
    'table_id' => 'my key',
    'field_1'  => 'field 1 value',
    'field_2'  => 'field 2 value',
    '
  }
}