Yeah. I don’t know much about SQL that I didn’t learn (or was supposed to learn) in a database course in 1986.
The nice thing about rails is that that it knows how things are interconnected, so when you delete something, it deletes all the other stuff that depends on it, rather than leaving dangling stuff in your database. It also keeps you from setting things to values that don’t make sense.
I use those graphical tools when plunking about an unfamiliar database to do an import, but mostly never for Discourse, though I do look at ./db/schema.db (which I learned is generated magically and not available in github) to figure out where stuff is.