OceanBase MCP
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| OB_HOST | Yes | Hostname or IP of the OceanBase proxy or direct connect address. | |
| OB_PORT | No | Port number of the OceanBase proxy. | 2883 |
| OB_USER | Yes | Username for the OceanBase connection, typically in format user@tenant#cluster. | |
| NODE_ENV | No | Node environment. | production |
| OB_MCP_HOST | No | Bind address for the HTTP server. | 127.0.0.1 |
| OB_PASSWORD | No | Password for the OceanBase user. Either this or OB_PASSWORD_FILE must be set. | |
| OB_PRODUCTION | No | Set to 'true' for production mode. | false |
| OB_COMPATIBILITY | No | Compatibility mode: 'mysql' or 'oracle'. | mysql |
| OB_MCP_READ_ONLY | No | Must be 'true' to start the server. | true |
| OB_PASSWORD_FILE | No | Path to a file containing the password. Alternative to OB_PASSWORD. | |
| OB_MCP_AUTH_TOKEN | No | Bearer token for HTTP authentication. | |
| OB_ALLOWED_SCHEMAS | No | Comma-separated list of allowed schemas. | |
| OB_MCP_ALLOWED_IPS | No | Comma-separated IPs or CIDR for source IP allowlist. | |
| OB_ALLOW_SELECT_STAR | No | Allow SELECT * queries. | false |
| OB_MCP_ALLOWED_HOSTS | No | Comma-separated allowed Host headers. | |
| OB_MCP_AUTH_TOKEN_FILE | No | Path to a file containing the bearer token. | |
| OB_ENFORCE_READ_ONLY_TX | No | Enforce read-only transactions. | true |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| resources | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| ob_list_profilesA | List configured OceanBase MCP profiles with redacted settings. |
| ob_config_diagnosticsB | Check profile, policy, TLS, HTTP, and production hardening settings. |
| ob_pingC | Verify the configured OceanBase connection. |
| ob_policy_explainB | Explain whether a SQL statement is allowed and which read-only or access-policy checks apply. |
| ob_queryC | Run a strictly read-only SQL statement against OceanBase. |
| ob_list_schemasC | List schemas/databases visible to the current OceanBase user, filtered by access policy. |
| ob_list_tablesB | List tables visible to the current OceanBase user, filtered by access policy. |
| ob_describe_tableC | Return column metadata for an allowed OceanBase table. |
| ob_explainC | Run EXPLAIN for a strictly read-only SQL statement. |
| ob_search_catalogC | Search schemas, tables, columns, and comments, filtered by access policy. |
| ob_get_table_schemaB | Return policy-filtered table columns and types for one table. |
| ob_get_indexesC | Return indexes for an allowed OceanBase table. |
| ob_get_constraintsC | Return constraints for an allowed OceanBase table. |
| ob_get_partitionsC | Return partition metadata for an allowed OceanBase table. |
| ob_sample_rowsB | Return a small, policy-filtered sample from an allowed table. Sensitive-looking fields are always masked. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| connection | Default OceanBase MCP connection settings, excluding password and SSL material. |
| profiles | Configured OceanBase profiles with redacted connection settings. |
Latest Blog Posts
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/sevoniva/oceanbase-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server