Here are a couple of quotes from the Psalms about what The LORD is and does. Note the format of the word LORD, all caps with L larger than the other three letters. (I don’t see how to do that in Word Press so I have used screen shots below to illustrate the point.)
Psalm 1:6 The LORD watches over the way of the just, but the way of the wicked leads to ruin.
Psalm 9:10 The LORD is a stronghold for the oppressed, stronghold in times of trouble.
Psalm 10:16 The LORD is king forever; the nations have vanished from God’s land.
Psalm 11:5 The LORD tests the good and the bad, hates those who love violence,
Psalm 11:7 The LORD is just and loves just deeds;
Psalm 14:2 The LORD looks down from heaven upon the human race, To see if even one is wise, if even one seeks God.
Psalm 29:10 The LORD sits enthroned above the flood! The LORD reigns as king forever!
Psalm 31:24 The LORD protects the loyal, but repays the arrogant in full.
Psalm 33:10 The LORD foils the plan of nations, frustrates the designs of peoples.
Psalm 33:5 The LORD loves justice and right and fills the earth with goodness.
Psalm 34:16 The LORD has eyes for the just and ears for their cry.
Psalm 34:19 The LORD is close to the brokenhearted, saves those whose spirit is crushed.
Psalm 34:23 The LORD redeems loyal servants;
Psalm 37:18 The LORD watches over the days of the blameless;
Psalm 92:16 The LORD is just; our rock, in whom there is no wrong.
Psalm 93:1 The LORD is king, robed with majesty; the LORD is robed, girded with might.
Psalm 97:1 The LORD is king; let the earth rejoice;
Psalm 97:10 The LORD loves those who hate evil, protects the lives of the faithful, rescues them from the hand of the wicked.
Psalm 99:1 The LORD is king, the peoples tremble;
Psalm 103:6 The LORD does righteous deeds, brings justice to all the oppressed.
Psalm 105:7 The LORD is our God who rules the whole earth.
Psalm 113:7 The LORD raises the needy from the dust, lifts the poor from the ash heap,
Psalm 118:27 The LORD is God and has given us light.
Psalm 138:6 The LORD is on high, but cares for the lowly and knows the proud from afar.
Psalm 145:13 The LORD is trustworthy in every word, and faithful in every work.
Psalm 145:14 The LORD supports all who are falling and raises up all who are bowed down.
Psalm 145:8 The LORD is gracious and merciful, slow to anger and abounding in love.
Psalm 145:9 The LORD is good to all, compassionate to every creature.
Psalm 146:7 The LORD sets prisoners free;
Psalm 146:8 the LORD gives sight to the blind. The LORD raises up those who are bowed down; the LORD loves the righteous.
Psalm 146:9 The LORD protects the stranger, sustains the orphan and the widow, but thwarts the way of the wicked.
Psalm 147:6 The LORD sustains the poor, but casts the wicked to the ground.
And that is a sampling of what the ancient Jews, without benefit of the Incarnation, believed about God. Mostly good news, I would say, except for the wicked, the arrogant, and those who love violence.
More About Names of God
If you want to know more about the tetragrammaton, and names of God, keep reading.
YAHWEH is a guess on the pronunciation of YHWH, the four Hebrew consonants given to Moses as the name of God in Exodus, Chapter 3:13-14.
But,” said Moses to God, “if I go to the Israelites and say to them, ‘The God of your ancestors has sent me to you,’ and they ask me, ‘What is his name?’ what do I tell them?” 14 God replied to Moses: I am who I am.[h] Then he added: This is what you will tell the Israelites: I AM has sent me to you.
Below is a screen shot of the rather complicated explanation in the NABRE of the verses above (footnote h) and an explanation of the names Elohim, Adonai, and LORD. In particular note this: The word Lord (in small capital letters) indicates that the Hebrew text has the sacred name (Yhwh), the tetragrammaton. Also note the reference to the Church Fathers in the last sentence.
And, if you are extremely curious, Wikipedia has a very detailed tetragrammaton article which includes this chart of the frequency of its occurrence in the OT books. Note that Psalms comes in second only to Jeremiah and just ahead of Deuteronomy.