dumMySQL
MySQL without the panic attack.
Ask normal questions. Get human answers. Learn real SQL while you’re at it.
Most people don’t hate databases.
They hate feeling stupid in front of one.
phpMyAdmin is powerful — and terrifying if you only needed one number.
dumMySQL sits quietly under Tools in WordPress: ask in plain language,
peek at your data, export IDs, and never write a DELETE by accident.
Ask like a human.
No “rows.” No “execute.” Just what you actually wanted to know.
- Show me some dataPeek at what’s inside
- How much is in here?Count everything
- How many match…?Filter by a field & value
- Find matching data…List what matched
- What’s unique here?Distinct values
- Explain this tableFields & types
Here’s your answer
0
records where post_author is “Patrick (#26)” in posts
Learn SQL from your own questions.
We don’t hide the SQL. We annotate it — every piece, top to bottom —
so COUNT(*) never gets confused with SELECT * again.
Learn SQL
This is what your question asks
SELECT COUNT(*) AS matching_rows FROM `wp_posts` WHERE `post_author` = '26'
SELECTPlease give me back… what comes next decides what you get.COUNT(*)A number — how many? Not the records themselves.(*)Inside COUNT: count matching records. Not “all columns.”FROMLook inside this table.WHEREOnly keep records that pass the test.LIMIT 50Start small. Validate. Then dig deeper.
Test → peek → dig deeper.
Pros don’t ask for a million records on the first try. Start with ~50. Check the answer. Then widen. Your browser, memory, and patience will thank you.
Built for the people who Slack “can you check the DB?”
- Site owners who panic at the word query
- Marketers who need one number without a developer
- Agency PMs who only need to look — and swear it
- Devs who want a calmer read console next to phpMyAdmin
Get dumMySQL
WordPress plugin — lives under Tools → dumMySQL. Read-only. Ask mode for everyone, SQL for pros.
By Content Factory OÜ. There’s a MySQL hiding inside dumMySQL.