Toad - Mac Edition

Toad for Apple Mac Users

Toad is a powerful productivity solution that simplifies database management for OS X users. It enables you to build high-quality database applications in record time through a streamlined development process.
Supported platforms: Oracle Database, PostgreSQL, MySQL and MongoDB!

Data Browser and Editor

  • Browse data stored in your tables and views.
  • Edit data via datatype-specific forms.
  • Comfortably select values from lookup tables.
  • Set number of records that should be displayed in grid and explore larger set of rows.

Toad Mac Edition

Blobs Supported

  • Open data stored in blobs in associated applications.
  • Export blobs to files.
  • Set blob to null easily.

Blobs

Export and Import

  • Export data to SQL or CSV via wizards.
  • Limit exported data to meaningful formats (skip blobs etc.)
  • Select columns that should be exported.
  • Set advanced options, e.g. disable triggers.

Export and Import

Wizards for New Objects

  • Create new objects using wizards.
  • Define tables, columns, constraints...
  • Either create the object in database or generate code for detailed specification and manual execution.

New Objects Wizards

Advanced Content Assist

  • Take advantage of advanced Content Assist (Intellisense).
  • Proposals are sorted by references and relevance.
  • See referenced tables, get proposals for joins.
  • Generate aliases automatically
  • See this feature in Toad Extension for Eclipse VIDEO

Advanced Content Assist

Code Validation

  • Validate code on-the-fly.
  • See a list of suggestions, expected statements.
  • Visually navigate to error positions in large files.
  • SQL Problems View shows errors thrown by database platform.

Code Validation

Statements Execution

  • Execute all statements at once or choose position from where the code should be executed.
  • Run commands with Explain Plan.
  • Switch to another database connection to execute the same statement on different database.

Statements Execution

Open Quickly

  • Quickly find objects using smart search.
  • Specify first letters of your object names to get results.
  • Use camel case search and more.

Quick Search

Run Stored Procedures and Functions

  • Run Stored procedures and functions.
  • Specify input values visually.
  • Execute the same object on different database connection.

Run Stored Procedures and Functions

Dependencies

View dependencies and see references found in:

  • Database
  • Open SQL worksheets

Dependencies

SQL Recall and SQL Monitor

  • SQL Recall shows a list of executed statements.
  • SQL Monitor shows all executed statements.

SQL Recall

Supported Databases

  • Oracle Database
  • MySQL
  • PostgreSQL
  • MongoDB

Note: Some advanced features are available for Oracle database only.

Supported Databases