• INVENTORY
  • TENANTS
  • DATABASES
  • HUMAN

How to audit database infrastructure with your AI

Connect OceanBase once. After that, your agent can pull a full inventory of your system through chat.

Ask AI about this page

Short answer

How can I audit my OceanBase setup with AI?

Your agent uses this MCP to pull a full list of your clusters, tenants, and databases. You get a complete structural map of your environment. This breakdown shows you how the agent gathers that data.

Audit outcomes

What you'll see

The agent organizes your infrastructure into these four views.

INVENTORY

Cluster list

The agent finds every cluster in your account. You'll see exactly what's running at the top level.

TENANTS

Tenant map

Your agent identifies all tenants within your clusters. This shows how your resources are split up.

DATABASES

Database list

The agent pulls every database from your tenants. You get a clear view of your data hierarchy.

HUMAN

Manual review

The agent only reads the structure. You'll need to handle any actual database changes or tuning yourself.

The workflow

What your AI does when the request arrives.

The agent crawls your OceanBase hierarchy to build your report.

  1. Find clusters

    The agent starts by identifying all active clusters in your account.

    list_clusters

  2. Identify tenants

    It then looks inside those clusters to find every tenant.

    list_tenants

  3. Locate databases

    The agent drills into each tenant to find the specific databases.

    list_databases

  4. Compile report

    The agent combines all the cluster, tenant, and database data into one summary.

    list_clusterslist_tenantslist_databases

Try it

Copy these to start.

Paste these into your chat to begin the audit.

Starting points

These are opening lines. Swap in specific tenant or cluster names if you want to narrow the scope.

OceanBase Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_8anQTWhuI7ipkbK5kvpG7CtvTALw739E72OpDrhb/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — OceanBase capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "oceanbase-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_8anQTWhuI7ipkbK5kvpG7CtvTALw739E72OpDrhb/mcp"
    }
  }
}
Copy into chat04

  • List all my OceanBase clusters and tenants.

  • Show me every database in the 'prod_tenant' tenant.

  • Audit my entire OceanBase setup and list all clusters, tenants, and databases.

  • Which databases are inside my primary cluster?

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect OceanBase once, then ask.

Link your account once. Your credentials stay encrypted on our side, and you can immediately start asking questions about your setup.

Connect OceanBase to your AI

FAQ

How this task behaves

  • 01

    Can the AI delete my databases?

    No. This MCP only has tools to list information. It cannot delete or modify anything.

  • 02

    Can the AI see the data inside my tables?

    No. The agent can only see the names of clusters, tenants, and databases. It cannot read your actual table rows.

  • 03

    Can I use this with Cursor or VS Code?

    Yes. You can use this with any MCP-compatible client.

  • 04

    Does the AI need my OceanBase admin password?

    No. You connect the MCP through Vinkius, which manages the connection securely.

  • 05

    Can the AI create new tenants for me?

    No. The tools provided are read-only for auditing purposes.

  • More questions about OceanBase? The Connector page answers them. See everything the OceanBase Connector can do

Connect OceanBase to Claude, Cursor, ChatGPT & more