# OceanBase MCP for AI Agents AI Agent Connect

> OceanBase MCP lets your AI agent handle the heavy lifting of your distributed relational database. You can manage clusters, monitor tenant resources, and audit database health through a simple chat interface. It replaces manual console navigation with direct, natural language commands for infrastructure management, making it easy to keep your data environment healthy and organized without switching tabs.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_8anQTWhuI7ipkbK5kvpG7CtvTALw739E72OpDrhb/ai-agent-connect
- **Tags:** distributed-database, relational-database, cluster-management, database-auditing, sql, infrastructure-as-code

## Description

Managing a distributed relational database usually means juggling dozens of tabs, keeping track of tenant limits, and digging through complex cloud consoles just to see if a cluster is healthy. It is tedious work that often leads to human error or missed alerts. This Connector changes that by letting your AI agent handle the grunt work for you. Instead of hunting for specific configuration files or manually pulling resource stats, you just ask your agent to do it. You can get a bird's-eye view of your entire database ecosystem or drill down into specific tenant metadata in seconds. It is about moving from how do I find this data to tell me what is happening with my data. By adding this to your workflow via the Vinkius catalog, you turn your AI into a real-time database reliability assistant. You can plan capacity, audit structures, and manage projects without ever leaving your primary workspace. It keeps your infrastructure accurate and your team focused on building features rather than babysitting the database layer.

## Tools

### get_workspaces
View all the different workspaces associated with your account. This helps you keep track of your different organizational environments.

### list_tenants
Browse all logical tenants within a specific cluster. This helps you manage multi-tenant resource allocation efficiently.

### get_cluster_details
Get the full configuration and status for a specific database cluster. This helps you understand the underlying hardware and settings at a glance.

### get_instance_details
Retrieve specific information about an OceanBase instance. Use this to check individual component health or configurations.

### get_resource_stats
Pull aggregate statistics on resource usage. This is perfect for identifying bottlenecks or planning for future growth.

### list_projects
See a list of all OceanBase projects you have access to. Use this to quickly navigate between different development or production scopes.

### get_tenant_details
Fetch detailed metadata for a specific logical tenant. This is essential for understanding how resources are partitioned.

### list_clusters
Get a complete list of all database clusters in your account. This provides a high-level view of your distributed database footprint.

### list_databases
See all the databases contained within a specific tenant. Use this to audit data assets and understand the structure of your tenant.

### list_instances
List every instance currently running in your OceanBase environment. This makes it easy to see your entire operational footprint.

## Prompt Examples

**Prompt:** 
```
List all the clusters in my account and tell me which ones are production.
```

**Response:** 
```
I've retrieved your OceanBase clusters. You have 4 active clusters:

* **Prod-Cluster-01**
* **Prod-Cluster-02**
* **Dev-Sandbox**
* **QA-Test**

Based on the naming, **Prod-Cluster-01** and **Prod-Cluster-02** appear to be your production environments. Would you like to see the tenant details for either of those?
```

**Prompt:** 
```
How much CPU are we using across all our instances?
```

**Response:** 
```
I've pulled the aggregate resource statistics for your organization:

| Metric | Usage | Status |
| :--- | :--- | :--- |
| **CPU** | 68% | Warning |
| **Memory** | 42% | Healthy |
| **Storage** | 1.4TB | Stable |

Would you like me to check if any specific tenants are approaching their limits?
```

**Prompt:** 
```
Show me the databases in the 'marketing-tenant'.
```

**Response:** 
```
I've retrieved the databases for the **marketing-tenant**. It contains 4 logical databases:

* Campaign_Data
* Lead_Gen_Raw
* Analytics_Archive
* User_Feedback

Do you need the configuration details for any of these?
```

## Capabilities

### List active database clusters
Get a high-level view of all your distributed database clusters in one command.

### Check cluster configurations
Retrieve detailed status and configuration data for any specific cluster.

### Browse account workspaces
View all different workspaces associated with your OceanBase account.

### Audit tenant databases
Identify all data assets and structures within specific logical tenants.

### Monitor resource usage
Pull aggregate statistics to see how much CPU and memory your organization is consuming.

### Retrieve instance details
Get specific information about individual instances to check health or settings.

## Use Cases

### Capacity Planning
An infrastructure engineer asks the agent to pull resource stats for all production clusters to see if they need to scale up before the end-of-month peak.

### Tenant Audit
A data architect needs to list all databases in a specific tenant to ensure they meet compliance standards and have the correct naming conventions.

### Developer Onboarding
A new backend developer asks the agent to list all projects and workspaces so they can find the correct staging environment for their new feature.

### Rapid Health Checks
A DBA uses the agent to quickly check the status of a specific cluster and its tenants after a reported latency spike in the production environment.

## Benefits

- Stop clicking through complex cloud consoles. Use list_clusters and list_tenants to get an immediate overview of your infrastructure without navigating multiple menus.
- Faster capacity planning. Use get_resource_stats to see exactly how much CPU and memory your organization is consuming across all instances in real-time.
- Simplified tenant auditing. Use list_databases and get_tenant_details to quickly verify data structures and resource allocations for any logical tenant.
- Faster environment setup for developers. Use list_projects and get_workspaces to help your team find the right instances and projects without manual lookups.
- Real-time reliability monitoring. Use get_cluster_details to pull status information on demand, making it easier to spot and resolve infrastructure issues faster.

## How It Works

The bottom line is you get a conversational interface for your entire distributed database infrastructure.

1. Subscribe to the OceanBase MCP on Vinkius.
2. Enter your OceanBase Access Key ID and Secret in your AI client settings.
3. Ask your agent to list clusters, check resource stats, or audit tenants.

## Frequently Asked Questions

**What can I do with the OceanBase MCP?**
You can use natural language to manage your distributed database clusters, browse tenants, and check resource usage stats. It gives your AI agent the ability to perform infrastructure tasks that usually require manual navigation in a cloud console.

**How do I use OceanBase for database auditing?**
The Connector allows your agent to list all databases within specific tenants and retrieve detailed metadata. This makes it easy to audit your data assets and ensure your infrastructure matches your documentation.

**Can the OceanBase MCP show me my resource usage?**
Yes. Your agent can pull aggregate resource statistics across your entire organization. This helps you monitor CPU, memory, and storage usage to plan for future growth or identify bottlenecks.

**Is the OceanBase MCP good for managing multi-tenant databases?**
It is specifically designed for that. You can list tenants within clusters and get detailed metadata for each one, making multi-tenant resource allocation much easier to manage via chat.

**How do I connect OceanBase to my AI agent?**
First, subscribe to the Connector on Vinkius. Then, provide your OceanBase Access Key ID and Secret in your AI client's configuration. From there, you can start asking your agent questions about your clusters and databases.

**Can I use OceanBase to see my database projects?**
Yes, the Connector includes tools to list all projects in your account. This helps you maintain a unified view of your database ecosystem and quickly find the right project for your current task.

**How do I find my OceanBase Access Key and Secret?**
Log in to your OceanBase Cloud console, go to [Security] → [Access Keys], and you will find your unique Access Key ID and Secret Key there. Ensure you keep them confidential.

**Can I list databases for a specific tenant through this server?**
Yes. Use the `list_databases` tool with the cluster ID and tenant ID. Your agent will retrieve the full list of logical databases belonging to that specific resource pool.

**Is it possible to check organization-wide resource usage?**
Yes! Use the `get_resource_stats` tool to retrieve aggregate statistics across your OceanBase account, helping you monitor total CPU, memory, and storage consumption.