mcp-oceanbase

Instructions

Implementation Reference

• src/oceanbase_mcp_server/oceanbase_mcp/server.py:223-237 (handler)

  The handler function for the 'get_current_time' tool. It executes SQL 'SELECT NOW()' on OceanBase to get the current time, falling back to Python's local time if the database query fails. The @app.tool decorator registers the tool.

  @app.tool(name="get_current_time", description="Get current time")
  def get_current_time() -> str:
      """Get current time from OceanBase database."""
      logger.info("Calling tool: get_current_time")
      sql_query = "SELECT NOW()"
      try:
          return execute_sql(sql_query)
      except Error as e:
          logger.error(f"Error getting database time: {e}")
          # Fallback to system time if database query fails
          local_time = time.localtime()
          formatted_time = time.strftime("%Y-%m-%d %H:%M:%S", local_time)
          logger.info(f"Fallback to system time: {formatted_time}")
          return formatted_time