Query View
Write and execute your own SQL statements.
The Query view has a lot of capability packed into it, so there are many subviews to look at in more detail to improve your workflow.
Query View subviews #
| # | View | Use |
|---|---|---|
| 1 | Favorites Bar | The saved queries you access most. |
| 2 | Run Button | Multiple options for which queries to run. |
| 3 | Selected Database | Target the correct MySQL database/schema, or Postgres search path. |
| 4 | Query Editor | Type your SQL statements in all their colorful glory. |
| 5 | Results List | See each result of multiple executed queries. |
| 6 | Result Rows List | The result rows of a single executed query. |
| 7 | Table Reference | Visual list of all tables and columns to refresh your memory. |
| 8 | Query Assistant | Super smart SQL statement generation. |
| 9 | Query Editors list | Manage multiple query editors and open SQL files. |
| 10 | Saved Queries | Save queries for just this connection/server, or shared across all. |