What is sheol?

In Hebrew, sheol means a pit. Sometimes it just refers to the grave, while elsewhere it alludes to death in general, or the gehenna which sinners undergo after death. See also:

The afterlife

Sheol is the Hebrew name for the afterlife or underworld, similar to the Greek concept of Hades (the place, not the deity).