r/SQL • u/SandwichRare2747 • 2d ago

MySQL Do database management tools still hold value in 2026? What’s missing from existing tools?

/r/indie_startups/comments/1w2bi9o/do_database_management_tools_still_hold_value_in/
1 Upvotes

67% Upvoted

3 comments sorted by

1

u/refaelos 22h ago

On the agent-safety and AI-generated-SQL points specifically, the pattern that's actually held up for me: never let an agent execute against a role that can write.

Give it a read-only user by default. When it needs to mutate data, it proposes a migration/diff for a human to apply, it doesn't run raw DML itself.

For ad-hoc UPDATE/DELETE from a human: wrap it in an explicit transaction it has to COMMIT. Run it, eyeball the row count against what you expected, ROLLBACK if it's off. Most "oops I deleted prod" stories are just someone running DML with autocommit on, outside a transaction.

Recovery-after-the-fact (parsing WAL/audit logs to reconstruct what changed) is the harder, more valuable problem in your list. Nobody I know has a tool for it they actually trust; they restore from backup and eat the downtime. That's the real gap if you're picking one of the four to build.