# Workspace

Workspace enhances MariaDB Enterprise Manager by adding query editing, visual schema management, and ERD design. It provides a collaborative environment for DBAs, developers, and analysts.

## Query Editor

| Feature                      | Description                                                                                  |
| ---------------------------- | -------------------------------------------------------------------------------------------- |
| SQL Editor                   | Write, run, and debug SQL with parallel query execution in multi-tab sessions.               |
| SQL Code Completion          | Context-sensitive suggestions for keywords and objects to speed authoring and reduce errors. |
| SQL Code Formatter           | Automatically formats SQL for readability and consistent style.                              |
| SQL Syntax Highlighting      | Color syntax highlighting for quicker scanning and fewer mistakes.                           |
| SQL Snippets                 | Save and reuse your favorite SQL blocks across sessions and teams.                           |
| SQL History                  | Running history of executed SQL with quick replay into the editor.                           |
| Multiple Connections         | Open simultaneous connections (dev/test/prod) and work in parallel, tab-isolated.            |
| Open/Edit/Save SQL Files     | Load scripts, edit, and save changes without leaving the workspace.                          |
| Export Result Sets           | Export results as CSV, JSON, or SQL for hand-offs and audits.                                |
| Display multiple Result Sets | View multiple result sets in the same window.                                                |
| Vertical Results Mode        | Columnar display for wide rows to improve readability of tall/wide data.                     |
| Result Set Limits            | Cap returned rows to keep queries responsive and safe in production.                         |
| Result Visualizations        | Visualize results as line, bar, or scatter charts for quick trend checks.                    |
| Grid Operations              | Search, filter, group, and control column visibility directly in the result sets.            |

## ERD Designer

| Feature                    | Description                                                                |
| -------------------------- | -------------------------------------------------------------------------- |
| ER Diagramming             | Build complete entity-relationship diagrams from your database structures. |
| Auto Layout                | Automatically arrange large models for clear, navigable diagrams.          |
| Model Tables, Indexes      | Manage MariaDB data-related objects.                                       |
| Create from Live Databases | Generate ERD models directly from live schemas.                            |

## Database Administration

| Feature             | Description                                                                                                            |
| ------------------- | ---------------------------------------------------------------------------------------------------------------------- |
| Schema Inspector    | Detailed metadata views for all schema objects to understand structure and dependencies.                               |
| Object Browser      | Navigate and explore databases, tables, views, routines, and triggers.                                                 |
| Object Editor       | Create, modify, and delete schema objects together with managing constraints, renaming, copying objects relationships. |
| User Management     | View, edit, create, delete database users and privileges.                                                              |
| Process List Viewer | View and manage live sessions/commands.                                                                                |

<sub>*This page is: Copyright © 2025 MariaDB. All rights reserved.*</sub>

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/tools/mariadb-enterprise-manager/usage/workspace.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.