Introducing the AIExplain feature in Toad Data Studio v2.0: Your guide to understanding complex code
If you’ve ever found yourself working with queries or scripts you didn’t write—whether they’re complex, unclear, or even ones you’ve forgotten the purpose of—it can become a real challenge. On top of that, if you’re working in a multi-platform environment, tasked with modifying code, improving logic, or refining outcomes, the task can feel even more daunting. But don’t worry! With Toad’s AIExplain feature, you can easily analyze your queries and scripts. It provides clear, plain-language explanations that walk you through the details, helping you understand the logic behind your code.
Watch a 2-minute video:
Supported Data Sources and Object Types
| Data Source | Object Type |
| DB2/LUW | Procedures, Functions, Views, Triggers, Tables, MQ Tables, Schemas |
| DB2/ZOS | Procedures, Functions, Views, Triggers, Tables, Packages, Aliases, MQ Tables, Synonyms, |
| MySQL | Procedures, Functions, Views, Triggers, Tables |
| Oracle | Procedures, Functions, Views, Triggers, Packages, Tables, Database Links, Materialized Views |
| PostgreSQL | Procedures, Functions, Views, Tables |
| SAP ASE | Procedures, Views, Triggers, Tables, Users, Databases |
| SAP HANA | Procedures, Functions, Views, Triggers, Tables, Server Security |
| SNOWFLAKE | Procedures, Functions, Views, Databases, Tables |
| TERADATA | Procedures, Functions, Views, Tables, Macros |
| SQL Server | Procedures, Functions, Views, Tables, Indexes, Databases, Sequences, Synonyms |
| SAP IQ | Procedures, Functions, Views, Tables, Users, Groups |
