OceanBase MCP Server

This repository hosts an OceanBase Model Context Protocol (MCP) server, designed to facilitate secure interactions with OceanBase databases. It enables AI assistants to explore and analyze databases safely through a controlled interface, allowing them to list tables, read data, and execute SQL queries.

The server's features include listing available OceanBase tables as resources, reading table contents, executing SQL queries with error handling, secure database access via environment variables, and comprehensive logging. Installation is straightforward using pip install oceanbase-mcp-server. Configuration requires setting environment variables for database connection details. It can be integrated with Claude Desktop using a configuration file or run as a standalone server after installing dependencies from requirements.txt.

Security is paramount, emphasizing the use of minimal permissions, avoiding root credentials, enabling logging, and regular security reviews. A dedicated SECURITY.md file provides detailed instructions on secure configuration.