# DBeaver (CloudBeaver) MCP for AI Agents MCP

> DBeaver (CloudBeaver) provides AI agents direct, programmatic access to your database management system. Use this MCP to manage user accounts, audit connection statuses, and handle data exports without opening a web interface. It lets you govern complex databases—checking licenses, provision users, or querying specific connection details—all through natural language commands.

## Overview
- **Category:** developer-tools
- **Price:** Free
- **Tags:** sql, database-administration, cloudbeaver, dbeaver, user-management

## Description

This MCP connects your AI agent directly to your CloudBeaver instance, letting you manage database infrastructure from wherever you are working. Instead of logging into the graphical user interface and clicking through menus for basic tasks, your agent handles it all via text prompts.

It lets you audit who has access, instantly create or delete team accounts, and get detailed status reports on specific connections across various projects. Need to know what export formats are available? Your agent checks that too. Because Vinkius hosts this MCP, you connect once through any compatible client—Claude, Cursor, Windsurf, etc.—and gain immediate control over your database administration tasks. You can even monitor the product's active licenses and configure server settings programmatically, streamlining complex backend operations into simple conversations.

## Tools

### add_connections_access
Grants specific users or teams defined access rights to particular database connections.

### auth_login
Authenticates a user session using credentials and an available authentication provider.

### configure_server
Updates the core, main configuration settings for the entire CloudBeaver instance.

### create_team
Creates a new organizational team structure used for managing access rights.

### create_user
Provisions a brand-new user account within the system (Admin permission required).

### data_transfer_available_stream_processors
Lists all export formats and data transfer types that the system supports.

### data_transfer_export_data_from_container
Initiates an asynchronous job to pull and export large amounts of data from a specific table or schema container.

### data_transfer_export_data_from_results
Exports the results set generated by a specific SQL query for later use.

### db_sm_terminate
Forces the termination of all currently active database sessions associated with one connection.

### delete_team
Permanently removes an existing team structure from the system.

### delete_user
Removes a user account, ensuring all associated permissions are revoked.

### get_active_product_license
Returns detailed information regarding the currently active product license status and expiration date.

### get_active_user
Retrieves basic details about the user who is currently authorized to make calls through this MCP.

### get_admin_user_info
Fetches comprehensive, admin-level information for a specified user account.

### get_ai_settings
Retrieves the global configuration settings that govern how AI agents interact with this MCP.

### get_all_product_licenses
Lists every product license installed on the server, useful for comprehensive inventory checks.

### get_auth_providers
Returns a list of all available authentication methods, such as local logins or SAML integrations.

### get_connection_info
Retrieves the full configuration and real-time status for one specific database connection.

### get_driver_list
Lists every single database driver supported by the CloudBeaver instance, confirming compatibility.

## Prompt Examples

**Prompt:** 
```
List out all supported drivers and tell me if I can export results to XLSX.
```

**Response:** 
```
**System Driver Report**

Your CloudBeaver instance supports 15 major database types, including:
*   PostgreSQL
*   MySQL
*   Oracle Database
*   SQLite
*   SQL Server

Regarding exports: Yes, data transfer is available in **XLSX**, JSON, and CSV formats. You can use the `data_transfer_available_stream_processors` tool to confirm this.
```

**Prompt:** 
```
I need a new user account for Bob from Operations. Make sure he only sees the HR database connections.
```

**Response:** 
```
**✅ User Account Provisioned**

User 'bob_ops' has been successfully created and assigned ID `U901`. 

*   **Access Granted:** Limited to the 'HR_Production_DB' connection.
*   **Role:** Read-Only Access.
*   **Status:** Active. (Admin action required for deletion or elevated privileges.)
```

**Prompt:** 
```
What is the current status of our primary reporting database? And who can access it?
```

**Response:** 
```
**Connection Status Report: ReportingDB_PROD**

*   **Status:** Connected (Last Check: 2 minutes ago).
*   **Driver Used:** PostgreSQL.
*   **Configured Host:** db.reporting.internal

***Current Users with Access:***

| User | Role | Last Activity |
| :--- | :--- | :--- |
| jdoe | Admin | Today, 10:30 AM |
| ops_team | Read-Only | Yesterday |

```

## Capabilities

### Manage User and Team Access
Create new user accounts or define teams to control who has access to specific database connections.

### Audit Connection Details
Retrieve the configuration, status, and security details for any specified database connection across your projects.

### Handle Data Exports
Start asynchronous tasks to export data either from an entire schema or directly from a specific SQL query result set.

### Discover System Drivers and Formats
List all database drivers the system supports and check available file formats for data transfers, such as JSON, CSV, or XLSX.

### Control Authentication and Licensing
Query authentication providers (like SAML) or retrieve details about active product licenses to verify compliance and setup.

## Use Cases

### Auditing a Production Connection
A DBA needs to know the current status of the main production PostgreSQL connection. They ask their agent, and it uses `get_connection_info` to confirm that the host is online and reports its last active time immediately.

### Onboarding a New Data Team
A DevOps engineer needs to set up a new reporting team. They prompt the agent, which uses `create_team`, then adds specific users using `add_connections_access` so that only the necessary people can see the target databases.

### Extracting Results for Quarterly Report
A data engineer runs a complex query and needs to save the output. They ask their agent, which triggers `data_transfer_export_data_from_results`, automatically generating an exportable JSON file ready for stakeholders.

### Verifying System Capacity
A manager asks what types of data files the system can handle. The agent uses `get_driver_list` and `data_transfer_available_stream_processors` to confirm support for all necessary formats, like Oracle and XLSX.

## Benefits

- Audit user access instantly. Instead of digging through multiple admin portals, use the `get_connection_info` tool to pull a real-time status report for any connection in seconds.
- Streamline provisioning. Automatically create or delete teams and users using tools like `create_user` and `delete_team`, eliminating tedious manual account management.
- Improve data workflow reliability. Check available export formats with `data_transfer_available_stream_processors` before starting a pipeline, ensuring your output matches the required schema (JSON, CSV, XLSX).
- Maintain compliance visibility. Use `get_active_product_license` to check license expiration and status automatically, keeping your records clean for audits.
- Simplify complex connections. Quickly determine if an account is properly set up by using `get_auth_providers` to list all supported authentication methods.

## How It Works

The bottom line is you get full database governance capabilities through conversational commands, bypassing the need for manual UI interaction.

1. First, subscribe to the DBeaver (CloudBeaver) MCP on Vinkius.
2. Next, provide your CloudBeaver Server URL and API Token to link your AI client to the system.
3. Finally, instruct your agent using natural language to perform any task, from checking connection status to provisioning a new team.

## Frequently Asked Questions

**How does the DBeaver (CloudBeaver) MCP help me manage user roles and permissions?**
It lets you programmatically handle user access. You can create new users, define teams for groups of people, and assign specific read or write permissions to individual database connections without touching the web interface.

**Can I use DBeaver (CloudBeaver) MCP to check if my licenses are up to date?**
Yes. The MCP allows you to query the active product license details, letting you instantly audit your current status and expiration dates for compliance reporting.

**What kind of data exports can I perform with DBeaver (CloudBeaver) MCP?**
You can export results from a specific SQL query or dump data from an entire table/schema. The system supports multiple formats, including JSON, CSV, and XLSX.

**Is the DBeaver (CloudBeaver) MCP suitable for DevOps automation?**
Absolutely. It's perfect for automation because you can use it to script user provisioning, verify server configurations, or manage database connections as part of a larger deployment pipeline.

**How do I check the connection status of my databases using DBeaver (CloudBeaver) MCP?**
You simply ask your agent for the connection info. It retrieves real-time operational data, telling you if a link is connected, which driver it uses, and its configured host details.

**Does DBeaver (CloudBeaver) MCP support multiple types of databases?**
Yes, the system supports many drivers. You can ask the MCP to list all supported drivers, confirming compatibility for everything from PostgreSQL and MySQL to Oracle and SQLite.