How to Use the OceanBase MCP in Windsurf

Q: Can Cascade in Windsurf troubleshoot a slow OceanBase cluster?

Yes, Cascade chains the getresourcestats and getclusterdetails tools to analyze performance bottlenecks. It reads the raw metrics, identifies resource-heavy tenants, and presents a remediation plan without manual intervention.

Q: How do I configure this OceanBase MCP Server inside my Windsurf settings?

Open your mcpconfig.json file in Windsurf and add the server definition under the mcpServers key. Cascade will automatically discover all ten tools, including listdatabases and listprojects, on the next startup.

Q: What happens if Cascade tries to run a tool on an offline instance?

When getinstancedetails returns an offline state, Windsurf halts the execution chain immediately. Cascade will report the specific node failure and ask for your input before attempting further operations.

Control your OceanBase distributed databases directly from Windsurf using Cascade to chain complex multi-step cluster operations.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect OceanBase MCP to Windsurf

Create your Vinkius account to connect OceanBase to Windsurf and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup OceanBase with Windsurf

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Autonomous Multi-Tenant Provisioning

The `list_tenants` tool lets your Windsurf agent inspect current resource allocation across your distributed infrastructure. Cascade automatically reads this tenant list, determines which clusters have head room, and maps out the deployment steps without requiring you to prompt every single action. If a tenant needs modification, the agent triggers `get_tenant_details` to verify memory and CPU limits. It chains these checks together to prevent over-provisioning, giving you a live, self-correcting database management assistant right inside your IDE.

Automated Performance Troubleshooting

This MCP Server exposes `get_resource_stats` to feed real-time telemetry directly into Cascade. When a query slows down, the agent pulls these metrics and correlates database load with active cluster configurations on its own. It then calls `get_cluster_details` to isolate noisy neighbors or hardware bottlenecks. Instead of manual terminal hopping, you get a clear diagnostic summary and a proposed fix generated by your IDE agent.

Multi-Cluster Directory Mapping in Windsurf

The `list_clusters` tool works with Windsurf to build an interactive map of your entire database footprint using this MCP integration. Cascade scans this inventory to understand your global topology before running any schema migrations or workspace updates. By combining `list_instances` and `get_instance_details`, the agent verifies node health across regions. You set the target environment, and Cascade handles the multi-step verification to ensure your destination is healthy.

Setup guide

Set up OceanBase MCP in Windsurf

Prerequisites

Windsurf IDE installed (macOS, Windows, or Linux)
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Click the Cascade assistant icon in the sidebar, then click the hammer icon (🔨) at the top of the panel. Select "Configure" to open ~/.codeium/windsurf/mcp_config.json.
2

Add the OceanBase MCP

Paste the JSON snippet shown on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Refresh MCPs

Go back to the hammer icon (🔨) in Cascade and click "Refresh". Windsurf will detect the new server. No full restart is needed — the connection is hot-reloaded.
4

Verify in Cascade

Start a new Cascade conversation and ask something like "Show my OceanBase payment history." If connected, Cascade will call the OceanBase tools directly. You will see a green dot next to the server name in the MCP panel.

mcp_config.json

{
  "mcpServers": {
    "oceanbase-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by OceanBase. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect OceanBase now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about OceanBase MCP in Windsurf

You add the OceanBase MCP Server to your Windsurf configuration, allowing Cascade to call `list_tenants` and `get_tenant_details` directly. Cascade then uses these tools to plan and execute multi-step database management tasks autonomously.

Yes, Cascade chains the `get_resource_stats` and `get_cluster_details` tools to analyze performance bottlenecks. It reads the raw metrics, identifies resource-heavy tenants, and presents a remediation plan without manual intervention.

Open your `mcp_config.json` file in Windsurf and add the server definition under the `mcpServers` key. Cascade will automatically discover all ten tools, including `list_databases` and `list_projects`, on the next startup.

When `get_instance_details` returns an offline state, Windsurf halts the execution chain immediately. Cascade will report the specific node failure and ask for your input before attempting further operations.

This connection operates within a secure local sandbox, passing only metadata like database names from `list_databases` and resource metrics. Your raw SQL data and master credentials never leave your local environment or transit to external servers.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript