{"type":"mcp_server","name":"oceanbase_mcp_server","description":"The OceanBase MCP Server enables secure AI interaction with OceanBase databases. It allows listing tables, reading data, and executing SQL queries through a controlled and safe interface. The OceanBase MCP","category":"Database","language":"Python","stars":3,"forks":1,"owner":"yuanoOo","github_url":"https://github.com/yuanoOo/oceanbase_mcp_server","homepage":null,"setup":"## Setup\n\n1.  Install the package: `pip install oceanbase-mcp-server`\n2.  Set environment variables: `OB_HOST`, `OB_PORT`, `OB_USER`, `OB_PASSWORD`, `OB_DATABASE`.\n3.  For Claude Desktop, add the MCP server configuration to `claude_desktop_config.json` with the appropriate command, arguments, and environment variables.\n4.  As a standalone server, install dependencies using `pip install -r requirements.txt` and run the server using `python -m oceanbase_mcp_server`.\n5.  For development, clone the repository, create a virtual environment, install development dependencies using `pip install -r requirements-dev.txt`, and run tests using `pytest`.","tools":"## Available Tools\n\n1. List available OceanBase tables as resources (allows AI assistants to discover available data).\n2. Read table contents (enables AI assistants to access data within tables).\n3. Execute SQL queries with proper error handling (provides a controlled interface for data manipulation).\n4. Secure database access through environment variables (ensures credentials are not hardcoded).\n5. Comprehensive logging (provides audit trails and debugging information).","faq":null,"created_at":"2025-03-05T06:13:34+00:00","updated_at":"2025-03-26T01:45:22+00:00","source_url":"https://model-context-protocol.com/servers/oceanbase-secure-ai-database-interaction","related_articles":[]}