This MCP server enables AI assistants to comprehensively interact with OceanBase databases and their ecosystem through standardized operations, monitoring, and management capabilities.
Core Database Operations:
Configure and manage secure connections using environment variables or explicit credentials
Execute SQL queries directly for data manipulation and retrieval
Access system information including current time, tenant details, server nodes, and resource capacity
Performance & Monitoring:
Generate Active Session History (ASH) reports for performance analysis and troubleshooting
Integrate with OceanBase Cloud Platform (OCP) for cluster monitoring
Utilize OBDIAG for diagnostic tool functionality and performance analysis
Administration & Management:
Access administrative functions requiring sys tenant privileges for cluster management
Manage cloud database functionalities through OBCloud services
Handle OceanBase deployments in Kubernetes environments using OKCTL
Use obshell for cluster creation, deployment, and operational management
Documentation & Support:
Search OceanBase documentation to provide context-aware responses and enhance answer accuracy
Enables interaction with GitHub for issue tracking and bug reporting through the 'Open an issue' functionality mentioned in the README.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-oceanbaseshow me the top 5 customers by total orders"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
๐ Awesome OceanBase MCP
Model Context Protocol (MCP) Server Collection for OceanBase Ecosystem
English | ็ฎไฝไธญๆ
๐ Project Overview
awesome-oceanbase-mcp is a Model Context Protocol (MCP) server repository specifically designed for the OceanBase ecosystem.
๐ฏ Mission: Enable AI assistants to interact directly with OceanBase databases and ecosystem components through standardized MCP protocols.
โจ Core Values:
๐ค AI-Friendly: Direct database operations within Claude, ChatGPT and other AI assistants
๐ Secure & Reliable: Provides safe database access and operation mechanisms
๐ ๏ธ Complete Ecosystem: Covers the complete OceanBase product and tool chain
๐ Ready to Use: Simple configuration to get started
Related MCP server: OpsLevel MCP
๐ What is MCP?
The Model Context Protocol (MCP) is an open protocol designed to enable seamless integration between AI applications and external data sources and tools. It provides a standardized way for AI models to access the contextual information and capabilities they need.
๐ Quick Start
Prerequisites
If you don't have an OceanBase database instance yet, please:
Visit OceanBase Official Repository to get the latest version
Or use OceanBase Online Trial for quick setup
๐๏ธ MCP Server Collection
This repository provides complete MCP servers for the OceanBase ecosystem:
๐ก Usage Tips: Click on the documentation links to view detailed installation and configuration guides.
๐ฌ Community & Support
We highly value community feedback and contributions!
๐โโ๏ธ Getting Help
๐ฌ Technical Discussion: Visit OceanBase Community Forum to connect with developers and community partners
๐ง Technical Support: Get official technical support through the community forum
๐ Documentation Hub: Check OceanBase Official Documentation
๐ Issue Reporting
If you encounter any issues during usage:
First check the documentation for the corresponding MCP server
Search existing Issues to confirm if the issue is known
If it's a new issue, please create a new Issue
๐ค Contributing
We welcome all forms of contributions:
๐ง Code Contribution: Submit Pull Requests
๐ Documentation: Improve docs and examples
๐ Bug Reports: Report bugs and suggest improvements
๐ก Feature Requests: Propose new feature requirements
๐ License
This project is released under the Apache License 2.0.
โญ If this project is helpful to you, please give us a Star!
Made with โค๏ธ by OceanBase Team
Resources
Looking for Admin?
Admins can modify the Dockerfile, update the server description, and track usage metrics. If you are the server author, to access the admin panel.