SQL Manager for MySQL 6.0 is here — a major release featuring our new AI Assistant! We’re continuing to roll out AI capabilities across our database tools, and now SQL Manager for MySQL gets them too.
What’s new in Version 6.0?
AI Assistant
Added an AI Assistant that handles:
- writing queries from plain-language descriptions, explaining code, fixing errors, optimizing queries, and analyzing EXPLAIN plans;
- generating schema change scripts to meet new business requirements;
- breaking down someone else’s SQL attached to your question as a file and making changes to it.
Schema scope can be set down to an individual object — you can attach as little as a single table to your request. You stay in full control of what context goes to the model and how much of it.
Connect as many providers as you like — all it takes is an API key (stored encrypted), and you can switch models right in the chat. Need to stay completely self-contained? It works with Ollama, so your data never leaves your machine.
Broader MySQL feature support
- Added support for CHECK constraints — define data validation rules at the table level and keep invalid values out of your database.
- The procedure and function debugger now supports WITH clauses (CTEs) — routines built on common table expressions can be debugged just like any other code.
Easier backups
- The Dump Database wizard can now include the current date and time in the backup file name — files won’t overwrite each other, and the right backup is easy to find by date.
Quality and stability
- BIGINT values are now displayed correctly — numbers show up exactly as they’re stored in the database.
- Resolved a data encoding issue in the Copy Database wizard — text no longer gets garbled during copying.
- Fixed an error when using the IS operator in Design Query — queries with such conditions are now built correctly.
- Fixed an error when revoking privileges in Grant Manager — permission management now works without a hitch.
- Many other fixes and enhancements improving the overall stability of the application.
Update SQL Manager for MySQL right now and put the AI Assistant to work!