Ez Sql Plus 1.1.0 is here. It adds four new modules to the editor, a way to report problems if you choose to, and a list of fixes. If you own a license, this update is included.
What's new
Table Designer (all six engines)
- Design a table visually on SQL Server, SQLite, PostgreSQL, MySQL, MariaDB and Oracle: columns, types, keys, identity, defaults, foreign keys, indexes, unique and check constraints, and descriptions.
- A list of the database's tables on the left and one tab per table you are editing. A tab with unsaved changes is marked, and "New table..." starts a blank one.
- You see the exact script that will run before anything is changed. Apply tells you why it cannot run when something is wrong, and warns you when a change could lose data.
Database Navigator
- A tree of everything in the selected connection: tables, views, procedures, functions, triggers, sequences, synonyms and types, with columns, keys, indexes and constraints inside the tables.
- Click an object for its details and its script, with the row count (approximate, exact on request, or exact when cheap).
- Right-click any object to open its script, select the top rows, edit it in the Table Designer, script it as CREATE, SELECT, INSERT, UPDATE or DELETE, delete it (a review dialog shows the DROP and asks for the connection name on PROD) or copy its name. A filter box finds objects as you type.
- Drag an object's name into the editor, and use "Show in Navigator" from other tabs to select the object in the tree.
Query Historic
- Every script you run is recorded, encrypted, and opens only on this PC and Windows account. Browse it by project and connection with filters for date, status, machine, user, who ran it (you or the AI Assistant), environment, saved results, starred and tags, plus a search in the SQL.
- See the full details of a run, its script and its errors, and open it again in the Query Executor or re-run it on its connection.
- Results saved with a run open in a viewer and export to Excel, CSV or text.
- Notes, tags and stars. A Summary view shows runs per day, failures, runs per connection and environment, and the slowest and most repeated queries.
- In Settings, Manage history... deletes everything or only what is older than a date, for one project or all of them, with a live count and a confirmation, and compacts the history to give the disk space back.
Database Search
- Find objects by name, by the name of one of their columns or parameters, or by text inside their code (procedures, functions, views and triggers). Whole word, match case, wildcards and regular expressions are supported, and results appear as you type.
- The Script tab shows the whole definition with every match highlighted. F3 and Shift+F3 step through them.
- Format Script lays out a view, procedure, function or trigger so it is readable. It changes only what you see.
Everywhere
- Problem reports. Help > Report a problem..., and after a crash, a window that shows exactly what would be sent before you decide. Nothing is sent without your choice.
- Show DEFINER in scripts (off by default): MySQL and MariaDB scripts no longer show
DEFINER=user@hostunless you ask. - On start, the selected connection is: start with the last connection or with none.
- The installer now checks that .NET Framework 4.8.1 is present and says so before installing anything.
Fixes
- Shortcuts between modules. F5, Ctrl+F, Enter and others did nothing in Query Historic and Database Search because another module used the same key. The tab you are in now gets its keys first.
- MySQL and MariaDB procedures, functions and triggers showed only their body. The CREATE line is back in the Navigator, in Database Search and in the Query Executor.
- Autocomplete help. The "Open in Table Designer" link in the help card now opens the table.
- Dragging text in the editor now moves it, and with Ctrl it copies it.
- No connection. Choosing "no connection" in the Speed Dial or at start is respected.
- Snippets that use a column name no longer break on PostgreSQL, Oracle and MySQL cursors and inserts.
- Navigator and Query Executor. "Select top rows" shows the rows without an extra click, INSERT ... SELECT scripts keep their lines, and filters wait for you to stop typing.
- Table Designer. Apply shows the reason when it is disabled, and the validity line lists every local problem.
About problem reports and your data
Reporting is optional. When you choose it, you see exactly what would be sent first, and nothing is sent unless you say so. Ez Sql Plus still never sends the contents of your databases, scripts or results to us. See the Privacy Policy for the details.
Get it
Download the installer from the Ez Sql Plus page. Your 30-day trial or license works as before. If something is missing or unclear, write to us through the contact form.

