> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/tools/mariadb-enterprise-manager/usage/workspace/database-administration.md).

# Database Administration

The MariaDB Enterprise Manager Workspace includes a powerful set of integrated tools that allow DBAs and developers to perform common administrative tasks graphically, without needing to write raw SQL commands. These features are primarily accessed through the **Schemas Sidebar** and dedicated tabs in the main worksheet area.

## Schema Inspector

The Schema Inspector provides detailed, read-only metadata views for any selected schema object. This allows you to quickly understand the structure, data types, constraints, and dependencies of your tables, views, and other objects without querying the `information_schema`. To use it, simply click on an object in the Object Browser.

## Object Browser

The Object Browser is the hierarchical tree view located in the **Schemas Sidebar** on the left side of the Workspace. It is your primary tool for navigating and exploring your database instances. You can expand databases to see their tables, views, stored procedures, and triggers, and use the filter box at the top to quickly locate specific objects.

## Object Editor

The Object Editor allows you to create, modify, and delete schema objects using graphical forms and dialogs. You can access these functions by right-clicking on an object (or object type) in the **Object Browser**. This will open a context menu with actions such as:

* `CREATE TABLE`, `CREATE VIEW`
* `ALTER TABLE`
* `DROP TABLE`
* Managing constraints and relationships
* Renaming or copying objects

## User Management

This dedicated tab provides a grid-based interface for managing database users and their privileges directly, without writing `GRANT` or `CREATE USER` statements.

From this interface, you can:

* **View** a list of all database users and their assigned global privileges.
* **Create** new database users using a simple form.
* **Edit** an existing user's password or modify their privileges.
* **Delete** users who no longer require access.

## Process List Viewer

The **Processlist** tab provides a real-time view of the database server's active sessions and the commands they are executing, equivalent to running `SHOW FULL PROCESSLIST`. This is an essential tool for diagnosing performance issues.

Using the Processlist Viewer, you can:

* **Monitor** all active connections, their current status (e.g., `Query`, `Sleep`), and how long they have been running.
* **Identify** long-running or problematic queries that may be impacting server performance.
* **Manage** live sessions, which may include the ability to terminate (kill) a specific process.

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

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


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.