# OceanBase

> Use this tool when you need to securely interact with OceanBase databases through AI assistants, enabling data analysis and exploration while maintaining configurable permission levels. It solves problems of data accessibility and security, providing a standardized interface for listing tables, reading data, and executing SQL queries. With inputs of SQL queries and database credentials, and outputs of query results and database resources, OceanBase MCP Server is ideal for data analysts and database administrators requiring secure and direct data access.

Canonical page: https://skillsregistry.net/skills/yuanooo-oceanbase  
JSON: https://api.skillsregistry.net/v1/skills/yuanooo-oceanbase

## Description

OceanBase MCP Server provides a secure interface for AI assistants to interact with OceanBase databases through standardized tools and resources. Developed by yuanoOo, it enables listing tables, reading data, and executing SQL queries with configurable permission levels as outlined in its security documentation. The server implements the Model Context Protocol using Python's asyncio and mysql-connector, exposing database tables as resources and providing an execute_sql tool with special handling for common query types. This implementation is particularly valuable for data analysts and database administrators who need to explore and analyze OceanBase data directly through AI assistants without compromising security.

## Trust

- **Trust score (0–1):** 0.63
- **Verification tier:** scanned
- **Last scanned:** 2026-09-01

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-01

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/yuanooo-oceanbase)
- **Repository:** <https://github.com/yuanooo/oceanbase_mcp_server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "yuanooo-oceanbase"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/yuanooo-oceanbase` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/yuanooo-oceanbase/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt